PREVIEW / etf_30min / 2026-01-16

all etf 30-min files

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

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-16 04:00:00	SPY	ETF	693.93	694.49	693.93	694.49	41897.0
2026-01-16 04:30:00	SPY	ETF	694.43	694.46	693.86	693.86	34457.0
2026-01-16 05:00:00	SPY	ETF	694.01	694.24	693.79	694.24	9008.0
2026-01-16 05:30:00	SPY	ETF	694.21	694.4	694.18	694.26	31047.0
2026-01-16 06:00:00	SPY	ETF	694.27	694.45	694.05	694.42	36069.0
2026-01-16 06:30:00	SPY	ETF	694.44	694.44	693.0	693.4	50263.0
2026-01-16 07:00:00	SPY	ETF	693.36	693.67	693.12	693.39	19932.0
2026-01-16 07:30:00	SPY	ETF	693.34	693.85	692.86	693.24	95090.0
2026-01-16 08:00:00	SPY	ETF	693.27	694.65	692.9533	693.34	137056.0
2026-01-16 08:30:00	SPY	ETF	693.36	694.31	692.98	693.16	151536.0
2026-01-16 09:00:00	SPY	ETF	693.16	693.95	693.11	693.65	313478.0
2026-01-16 09:30:00	SPY	ETF	693.67	694.25	691.93	691.96	7267738.0
2026-01-16 10:00:00	SPY	ETF	691.96	692.81	691.5	691.65	6691274.0
2026-01-16 10:30:00	SPY	ETF	691.65	691.88	690.1	691.86	6355884.0
2026-01-16 11:00:00	SPY	ETF	691.85	692.82	691.555	692.715	4552427.0
2026-01-16 11:30:00	SPY	ETF	692.72	693.47	692.13	692.665	3174769.0
2026-01-16 12:00:00	SPY	ETF	692.65	692.9699	692.4301	692.52	1689825.0
2026-01-16 12:30:00	SPY	ETF	692.52	692.91	691.89	691.93	1904320.0
2026-01-16 13:00:00	SPY	ETF	691.94	693.2	691.82	693.0	1862212.0
2026-01-16 13:30:00	SPY	ETF	693.0	693.25	692.5842	692.64	1489246.0
2026-01-16 14:00:00	SPY	ETF	692.63	693.71	691.96	692.04	3758283.0
2026-01-16 14:30:00	SPY	ETF	692.05	693.0	692.01	692.68	2880170.0
2026-01-16 15:00:00	SPY	ETF	692.67	692.87	692.155	692.155	2474475.0
2026-01-16 15:30:00	SPY	ETF	692.15	692.4886	691.47	691.58	9948686.0
2026-01-16 16:00:00	SPY	ETF	691.6	691.94	691.33	691.86	4138835.0
2026-01-16 16:30:00	SPY	ETF	691.77	691.83	691.59	691.68	194668.0
2026-01-16 17:00:00	SPY	ETF	691.6917	691.95	691.3	691.59	56709.0
2026-01-16 17:30:00	SPY	ETF	691.6	691.7099	691.35	691.66	29696.0
2026-01-16 18:00:00	SPY	ETF	691.6584	691.69	691.3304	691.5301	11006.0
2026-01-16 18:30:00	SPY	ETF	691.6798	692.0	691.53	691.72	9478.0
2026-01-16 19:00:00	SPY	ETF	691.84	692.0	691.72	691.94	7707.0
2026-01-16 19:30:00	SPY	ETF	691.89	691.986	691.41	691.42	16786.0
2026-01-16 04:00:00	QQQ	ETF	624.0	624.91	624.0	624.9	72220.0
2026-01-16 04:30:00	QQQ	ETF	624.94	624.97	624.34	624.34	31047.0
2026-01-16 05:00:00	QQQ	ETF	624.39	624.93	624.22	624.87	34316.0
2026-01-16 05:30:00	QQQ	ETF	624.91	625.46	624.91	625.25	51088.0
2026-01-16 06:00:00	QQQ	ETF	625.3	625.69	625.11	625.6	41550.0
2026-01-16 06:30:00	QQQ	ETF	625.58	625.6	624.6	624.73	59997.0
2026-01-16 07:00:00	QQQ	ETF	624.72	624.97	624.43	624.711	66635.0
2026-01-16 07:30:00	QQQ	ETF	624.7	625.15	624.08	624.66	81630.0
2026-01-16 08:00:00	QQQ	ETF	624.8	625.65	621.314	624.48	306144.0
2026-01-16 08:30:00	QQQ	ETF	624.48	624.81	624.1202	624.52	179242.0
2026-01-16 09:00:00	QQQ	ETF	624.59	625.76	624.46	625.55	423023.0
2026-01-16 09:30:00	QQQ	ETF	625.51	626.08	622.14	622.19	7261873.0
2026-01-16 10:00:00	QQQ	ETF	622.19	623.06	620.66	620.75	5972547.0
2026-01-16 10:30:00	QQQ	ETF	620.74	621.06	618.88	621.0276	6143506.0
2026-01-16 11:00:00	QQQ	ETF	621.02	621.915	620.54	621.8499	3318217.0
2026-01-16 11:30:00	QQQ	ETF	621.86	622.7	621.125	621.825	2811996.0
2026-01-16 12:00:00	QQQ	ETF	621.83	621.94	621.3299	621.44	1830614.0
2026-01-16 12:30:00	QQQ	ETF	621.44	621.76	620.41	620.455	1910366.0

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

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