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  ...  [226.08937072753903, 219.489990234375, 215.653...
1   AAPL  ...  [302.7049865722656, 301.57000732421875, 292.52...
2   MSFT  ...  [375.7490234375, 376.0356750488281, 378.822906...
3   MSFT  ...  [412.2900085449219, 411.739990234375, 409.4849...
4    SPY  ...  [551.14453125, 546.5628662109375, 549.46331787...

[5 rows x 12 columns]