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  ...  [235.8233184814453, 238.0689697265625, 241.109...
1   AAPL  ...  [263.3500061035156, 262.7300109863281, 262.450...
2   MSFT  ...  [419.4018249511719, 426.8497619628906, 427.067...
3   MSFT  ...  [409.0199890136719, 407.9831848144531, 405.0, ...
4    SPY  ...  [591.9419555664062, 593.0030517578125, 593.278...

[5 rows x 12 columns]