Skip to content

query_bars_summary

function backtide.storage.query_bars_summary()

Return a pre-aggregated summary of stored bars as a dataframe.

Each row represents one (symbol, interval, provider) series. The sparkline column contains the last 365 adj_close values.

Returns

pd.DataFrame | pl.DataFrame

One summary row per stored series.


See Also

query_bars

Return stored OHLCV bars as a dataframe.

query_dividends

Return stored dividend events as a dataframe.

query_instruments

Return stored instrument metadata, optionally filtered.


Example

>>> from backtide.storage import query_bars_summary

>>> df = query_bars_summary()
>>> print(df.head())

  symbol  ...                                          sparkline
0   AAPL  ...  [241.49703979492188, 241.29830932617188, 245.1...
1   AAPL  ...  [260.5050048828125, 260.7200012207031, 259.994...
2   MSFT  ...  [437.4307861328125, 438.3696594238281, 440.790...
3   MSFT  ...  [404.7001037597656, 405.760009765625, 404.4500...
4    SPY  ...  [595.9795532226562, 597.109375, 594.0344238281...

[5 rows x 12 columns]