PREVIEW / etf_30min / 2026-01-14

all etf 30-min files

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

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-14 04:00:00	SPY	ETF	692.71	693.18	692.71	692.94	9894.0
2026-01-14 04:30:00	SPY	ETF	693.0	693.04	692.5	692.83	7387.0
2026-01-14 05:00:00	SPY	ETF	692.78	692.79	691.3	691.57	48889.0
2026-01-14 05:30:00	SPY	ETF	691.53	691.58	690.54	690.99	102212.0
2026-01-14 06:00:00	SPY	ETF	690.94	691.51	690.48	691.4	47309.0
2026-01-14 06:30:00	SPY	ETF	691.45	691.47	690.97	691.19	21912.0
2026-01-14 07:00:00	SPY	ETF	691.07	691.78	690.23	691.65	91609.0
2026-01-14 07:30:00	SPY	ETF	691.65	691.92	691.32	691.44	51218.0
2026-01-14 08:00:00	SPY	ETF	691.12	693.18	690.27	691.57	263054.0
2026-01-14 08:30:00	SPY	ETF	691.76	693.65	690.5	690.88	261270.0
2026-01-14 09:00:00	SPY	ETF	690.91	691.27	690.7501	691.06	246922.0
2026-01-14 09:30:00	SPY	ETF	691.0	691.72	688.66	688.72	9935044.0
2026-01-14 10:00:00	SPY	ETF	688.72	690.85	687.67	688.76	7433465.0
2026-01-14 10:30:00	SPY	ETF	688.75	689.01	686.51	687.16	6432535.0
2026-01-14 11:00:00	SPY	ETF	687.16	689.33	686.99	689.15	4193218.0
2026-01-14 11:30:00	SPY	ETF	689.16	689.47	686.13	686.59	5031434.0
2026-01-14 12:00:00	SPY	ETF	686.58	687.35	686.04	687.0999	3180418.0
2026-01-14 12:30:00	SPY	ETF	687.09	687.45	686.19	686.6377	3050037.0
2026-01-14 13:00:00	SPY	ETF	686.63	687.65	686.51	687.6	2427734.0
2026-01-14 13:30:00	SPY	ETF	687.59	688.24	686.26	688.11	3334983.0
2026-01-14 14:00:00	SPY	ETF	688.11	688.315	687.61	688.125	3238646.0
2026-01-14 14:30:00	SPY	ETF	688.13	688.59	687.62	688.06	2808702.0
2026-01-14 15:00:00	SPY	ETF	688.05	689.69	687.32	689.15	6479291.0
2026-01-14 15:30:00	SPY	ETF	689.15	690.64	688.62	690.44	13122742.0
2026-01-14 16:00:00	SPY	ETF	690.44	693.8932	689.76	689.83	3845157.0
2026-01-14 16:30:00	SPY	ETF	689.85	690.01	688.19	689.7	440683.0
2026-01-14 17:00:00	SPY	ETF	689.68	690.3	689.46	689.65	75750.0
2026-01-14 17:30:00	SPY	ETF	689.6101	689.8299	689.28	689.52	38235.0
2026-01-14 18:00:00	SPY	ETF	689.51	689.75	688.64	689.4	116735.0
2026-01-14 18:30:00	SPY	ETF	689.4401	689.71	689.23	689.62	45675.0
2026-01-14 19:00:00	SPY	ETF	689.55	689.65	689.22	689.35	27893.0
2026-01-14 19:30:00	SPY	ETF	689.39	689.65	689.3	689.52	16063.0
2026-01-14 04:00:00	QQQ	ETF	625.1	625.61	625.05	625.27	32606.0
2026-01-14 04:30:00	QQQ	ETF	625.3	625.37	624.6	624.93	29691.0
2026-01-14 05:00:00	QQQ	ETF	624.95	624.96	622.7	623.01	62625.0
2026-01-14 05:30:00	QQQ	ETF	622.9	623.08	621.6	622.21	156065.0
2026-01-14 06:00:00	QQQ	ETF	622.3	622.86	621.63	622.71	68288.0
2026-01-14 06:30:00	QQQ	ETF	622.78	622.88	622.23	622.35	36841.0
2026-01-14 07:00:00	QQQ	ETF	622.32	623.25	621.36	623.05	97157.0
2026-01-14 07:30:00	QQQ	ETF	623.08	623.33	623.0	623.2	66290.0
2026-01-14 08:00:00	QQQ	ETF	622.17	625.771	621.39	623.52	268767.0
2026-01-14 08:30:00	QQQ	ETF	623.67	623.86	622.1	622.58	271767.0
2026-01-14 09:00:00	QQQ	ETF	622.59	623.0	622.12	622.23	186579.0
2026-01-14 09:30:00	QQQ	ETF	622.24	623.45	618.44	618.52	9955050.0
2026-01-14 10:00:00	QQQ	ETF	618.54	621.08	617.25	619.17	7198015.0
2026-01-14 10:30:00	QQQ	ETF	619.15	619.66	615.75	616.26	6514541.0
2026-01-14 11:00:00	QQQ	ETF	616.26	618.575	616.15	618.31	4576028.0
2026-01-14 11:30:00	QQQ	ETF	618.31	618.63	615.03	615.5	4304740.0
2026-01-14 12:00:00	QQQ	ETF	615.49	616.59	614.93	616.29	2875500.0
2026-01-14 12:30:00	QQQ	ETF	616.27	616.6599	614.86	615.25	2676671.0

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

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