PREVIEW / etf_30min / 2026-01-23

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-01-23.parquet
  size:    1.1 MB
  rows:    47,026

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2026-01-23 04:00:00	SPY	ETF	690.39	690.39	688.33	688.49	52596.0
2026-01-23 04:30:00	SPY	ETF	688.53	688.54	687.23	687.6	53957.0
2026-01-23 05:00:00	SPY	ETF	687.57	687.75	687.35	687.43	14611.0
2026-01-23 05:30:00	SPY	ETF	687.48	687.6	687.28	687.6	20593.0
2026-01-23 06:00:00	SPY	ETF	687.65	688.85	687.6	688.85	93390.0
2026-01-23 06:30:00	SPY	ETF	688.82	689.02	687.85	688.0	44633.0
2026-01-23 07:00:00	SPY	ETF	687.99	688.48	687.92	688.39	43493.0
2026-01-23 07:30:00	SPY	ETF	688.38	688.86	687.77	688.67	114772.0
2026-01-23 08:00:00	SPY	ETF	688.8199	690.93	687.23	687.45	271448.0
2026-01-23 08:30:00	SPY	ETF	687.46	688.01	687.24	687.42	266153.0
2026-01-23 09:00:00	SPY	ETF	687.47	688.25	687.121	688.15	249007.0
2026-01-23 09:30:00	SPY	ETF	688.15	688.81	687.16	688.77	6509975.0
2026-01-23 10:00:00	SPY	ETF	688.83	689.8501	688.31	689.325	4521352.0
2026-01-23 10:30:00	SPY	ETF	689.32	690.71	689.21	690.48	3404476.0
2026-01-23 11:00:00	SPY	ETF	690.47	690.96	689.92	690.07	3151451.0
2026-01-23 11:30:00	SPY	ETF	690.06	690.615	689.42	689.7481	2980238.0
2026-01-23 12:00:00	SPY	ETF	689.75	690.35	689.35	690.19	2218268.0
2026-01-23 12:30:00	SPY	ETF	690.198	690.28	687.73	687.99	4028665.0
2026-01-23 13:00:00	SPY	ETF	687.98	689.135	687.86	688.92	2883899.0
2026-01-23 13:30:00	SPY	ETF	688.94	689.28	688.37	688.97	1912105.0
2026-01-23 14:00:00	SPY	ETF	688.97	690.1995	688.91	689.5479	3087892.0
2026-01-23 14:30:00	SPY	ETF	689.55	689.86	688.94	689.53	2839385.0
2026-01-23 15:00:00	SPY	ETF	689.52	689.585	688.51	688.845	3338464.0
2026-01-23 15:30:00	SPY	ETF	688.84	689.61	688.55	689.185	7437578.0
2026-01-23 16:00:00	SPY	ETF	689.18	689.2542	687.9	688.0608	3075232.0
2026-01-23 16:30:00	SPY	ETF	688.09	688.31	687.94	688.01	145545.0
2026-01-23 17:00:00	SPY	ETF	688.05	688.5	687.85	688.03	91683.0
2026-01-23 17:30:00	SPY	ETF	688.03	688.2	687.98	688.15	9836.0
2026-01-23 18:00:00	SPY	ETF	688.15	688.33	688.15	688.22	7878.0
2026-01-23 18:30:00	SPY	ETF	688.22	688.39	688.22	688.3	5326.0
2026-01-23 19:00:00	SPY	ETF	688.29	688.39	688.26	688.39	5613.0
2026-01-23 19:30:00	SPY	ETF	688.39	688.45	687.9	687.99	22294.0
2026-01-23 04:00:00	QQQ	ETF	622.04	622.04	619.37	619.58	58227.0
2026-01-23 04:30:00	QQQ	ETF	619.6	619.6	618.09	618.56	78382.0
2026-01-23 05:00:00	QQQ	ETF	618.51	618.88	618.37	618.63	30002.0
2026-01-23 05:30:00	QQQ	ETF	618.55	618.85	618.39	618.85	25078.0
2026-01-23 06:00:00	QQQ	ETF	618.9	620.62	618.78	620.62	155635.0
2026-01-23 06:30:00	QQQ	ETF	620.5	620.89	619.44	619.6	68986.0
2026-01-23 07:00:00	QQQ	ETF	619.66	620.16	619.47	619.93	62062.0
2026-01-23 07:30:00	QQQ	ETF	619.91	620.3	619.17	620.19	64767.0
2026-01-23 08:00:00	QQQ	ETF	619.68	622.67	618.21	618.9	268881.0
2026-01-23 08:30:00	QQQ	ETF	618.86	619.61	618.58	618.84	234145.0
2026-01-23 09:00:00	QQQ	ETF	618.86	619.8	618.49	619.69	308103.0
2026-01-23 09:30:00	QQQ	ETF	619.71	621.13	618.65	621.13	5425302.0
2026-01-23 10:00:00	QQQ	ETF	621.08	623.46	621.08	623.05	4517065.0
2026-01-23 10:30:00	QQQ	ETF	623.07	624.97	623.0299	624.945	3040386.0
2026-01-23 11:00:00	QQQ	ETF	624.95	625.3999	623.8171	624.0901	2734200.0
2026-01-23 11:30:00	QQQ	ETF	624.09	624.96	623.38	624.04	2712367.0
2026-01-23 12:00:00	QQQ	ETF	624.05	624.49	623.51	624.26	1457206.0
2026-01-23 12:30:00	QQQ	ETF	624.27	624.31	621.535	621.78	2677314.0

> showing 50 of 47,026 rows — these rows as CSV

> unlock the full archive -- $79 one-time