PREVIEW / etf_30min / 2026-01-09

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-01-09.parquet
  size:    1.1 MB
  rows:    46,268

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-09 04:00:00	SPY	ETF	689.43	689.99	689.37	689.98	16735.0
2026-01-09 04:30:00	SPY	ETF	690.0	690.4	690.0	690.38	9602.0
2026-01-09 05:00:00	SPY	ETF	690.46	690.54	690.29	690.51	9703.0
2026-01-09 05:30:00	SPY	ETF	690.41	690.51	690.24	690.33	6825.0
2026-01-09 06:00:00	SPY	ETF	690.35	690.64	690.21	690.64	7399.0
2026-01-09 06:30:00	SPY	ETF	690.65	690.93	690.38	690.44	24128.0
2026-01-09 07:00:00	SPY	ETF	690.4	690.69	690.24	690.3	27866.0
2026-01-09 07:30:00	SPY	ETF	690.32	690.93	690.14	690.84	44723.0
2026-01-09 08:00:00	SPY	ETF	690.41	691.27	689.33	691.1	335790.0
2026-01-09 08:30:00	SPY	ETF	691.21	692.42	691.0	692.23	446011.0
2026-01-09 09:00:00	SPY	ETF	692.24	692.5	690.42	690.65	507633.0
2026-01-09 09:30:00	SPY	ETF	690.65	692.295	690.46	691.51	8425637.0
2026-01-09 10:00:00	SPY	ETF	691.56	693.34	689.18	693.13	8123591.0
2026-01-09 10:30:00	SPY	ETF	693.13	693.45	691.28	691.93	5965290.0
2026-01-09 11:00:00	SPY	ETF	691.94	693.65	691.93	692.8599	4718508.0
2026-01-09 11:30:00	SPY	ETF	692.85	694.03	692.545	693.89	3368947.0
2026-01-09 12:00:00	SPY	ETF	693.88	694.38	693.72	694.22	2490100.0
2026-01-09 12:30:00	SPY	ETF	694.23	694.5	693.95	693.975	2310790.0
2026-01-09 13:00:00	SPY	ETF	693.96	694.01	693.36	693.87	2287436.0
2026-01-09 13:30:00	SPY	ETF	693.87	694.8899	693.855	694.53	2751432.0
2026-01-09 14:00:00	SPY	ETF	694.52	694.845	694.36	694.81	2006848.0
2026-01-09 14:30:00	SPY	ETF	694.805	695.23	694.71	694.8999	2853001.0
2026-01-09 15:00:00	SPY	ETF	694.89	695.31	694.76	695.025	3072692.0
2026-01-09 15:30:00	SPY	ETF	695.02	695.12	693.9	693.99	10083678.0
2026-01-09 16:00:00	SPY	ETF	694.02	694.13	693.8	693.88	2798580.0
2026-01-09 16:30:00	SPY	ETF	693.88	694.08	689.6022	694.03	4850539.0
2026-01-09 17:00:00	SPY	ETF	694.0292	694.05	693.93	694.0	52767.0
2026-01-09 17:30:00	SPY	ETF	694.0444	694.14	693.9252	694.14	940075.0
2026-01-09 18:00:00	SPY	ETF	694.12	694.3899	694.069	694.3899	32233.0
2026-01-09 18:30:00	SPY	ETF	694.38	694.52	694.25	694.33	28591.0
2026-01-09 19:00:00	SPY	ETF	694.3394	694.5	694.18	694.24	17264.0
2026-01-09 19:30:00	SPY	ETF	694.2899	694.48	694.23	694.48	7188.0
2026-01-09 04:00:00	QQQ	ETF	620.46	621.03	620.22	621.03	21243.0
2026-01-09 04:30:00	QQQ	ETF	621.04	621.73	621.04	621.65	33859.0
2026-01-09 05:00:00	QQQ	ETF	621.72	622.03	621.56	621.85	18715.0
2026-01-09 05:30:00	QQQ	ETF	621.85	621.99	621.66	621.85	27138.0
2026-01-09 06:00:00	QQQ	ETF	621.86	622.25	621.64	622.24	15580.0
2026-01-09 06:30:00	QQQ	ETF	622.3	622.71	622.02	622.1	36348.0
2026-01-09 07:00:00	QQQ	ETF	622.05	622.34	621.62	621.74	43552.0
2026-01-09 07:30:00	QQQ	ETF	621.77	622.26	621.44	622.24	27127.0
2026-01-09 08:00:00	QQQ	ETF	622.14	622.59	620.0	622.17	199651.0
2026-01-09 08:30:00	QQQ	ETF	621.93	623.6	621.92	623.56	462388.0
2026-01-09 09:00:00	QQQ	ETF	623.61	624.02	621.08	621.38	544684.0
2026-01-09 09:30:00	QQQ	ETF	621.41	623.26	619.84	621.9215	6207746.0
2026-01-09 10:00:00	QQQ	ETF	621.95	624.895	619.06	624.74	5465008.0
2026-01-09 10:30:00	QQQ	ETF	624.75	625.34	622.52	623.76	3886697.0
2026-01-09 11:00:00	QQQ	ETF	623.8	625.88	623.77	624.9707	2727272.0
2026-01-09 11:30:00	QQQ	ETF	624.97	626.33	624.53	626.09	2243003.0
2026-01-09 12:00:00	QQQ	ETF	626.07	626.46	625.505	626.155	1824332.0
2026-01-09 12:30:00	QQQ	ETF	626.16	626.69	625.94	626.4	1707316.0

> showing 50 of 46,268 rows — these rows as CSV

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