PREVIEW / etf_30min / 2025-12-24

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-12-24.parquet
  size:    679 KB
  rows:    27,235

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
2025-12-24 04:00:00	SPY	ETF	687.45	687.9	687.45	687.8	30777.0
2025-12-24 04:30:00	SPY	ETF	687.77	687.81	687.69	687.73	2534.0
2025-12-24 05:00:00	SPY	ETF	687.69	687.76	687.54	687.66	3518.0
2025-12-24 05:30:00	SPY	ETF	687.68	687.81	687.67	687.75	2609.0
2025-12-24 06:00:00	SPY	ETF	687.7	687.83	687.63	687.74	5430.0
2025-12-24 06:30:00	SPY	ETF	687.72	687.77	687.63	687.71	4213.0
2025-12-24 07:00:00	SPY	ETF	687.7	688.1	687.69	687.91	43722.0
2025-12-24 07:30:00	SPY	ETF	687.94	688.1	687.94	688.09	28155.0
2025-12-24 08:00:00	SPY	ETF	688.07	688.0941	687.35	687.97	81522.0
2025-12-24 08:30:00	SPY	ETF	688.0	688.33	687.97	688.23	100319.0
2025-12-24 09:00:00	SPY	ETF	688.22	688.28	687.88	687.97	106511.0
2025-12-24 09:30:00	SPY	ETF	687.95	688.73	687.8	688.6	4039553.0
2025-12-24 10:00:00	SPY	ETF	688.59	689.215	688.51	689.165	3443352.0
2025-12-24 10:30:00	SPY	ETF	689.16	689.49	689.0125	689.47	2536617.0
2025-12-24 11:00:00	SPY	ETF	689.465	689.98	689.37	689.965	3010112.0
2025-12-24 11:30:00	SPY	ETF	689.965	690.485	689.8892	690.37	2943125.0
2025-12-24 12:00:00	SPY	ETF	690.37	690.64	690.27	690.535	3359294.0
2025-12-24 12:30:00	SPY	ETF	690.535	690.83	690.17	690.28	6797076.0
2025-12-24 13:00:00	SPY	ETF	690.29	690.38	689.75	690.1	1946476.0
2025-12-24 13:30:00	SPY	ETF	690.0702	690.1	689.9	689.95	108497.0
2025-12-24 14:00:00	SPY	ETF	689.9498	690.18	689.9498	690.07	99697.0
2025-12-24 14:30:00	SPY	ETF	690.0597	690.0597	689.98	690.01	14397.0
2025-12-24 15:00:00	SPY	ETF	690.0103	690.02	689.75	689.91	9063.0
2025-12-24 15:30:00	SPY	ETF	689.9	689.99	689.86	689.87	26814.0
2025-12-24 16:00:00	SPY	ETF	689.87	689.87	689.7	689.75	13579.0
2025-12-24 16:30:00	SPY	ETF	689.742	689.79	689.55	689.56	16290.0
2025-12-24 04:00:00	QQQ	ETF	621.91	622.24	621.72	622.16	17145.0
2025-12-24 04:30:00	QQQ	ETF	622.11	622.18	622.04	622.09	4072.0
2025-12-24 05:00:00	QQQ	ETF	622.07	622.07	621.81	621.95	8660.0
2025-12-24 05:30:00	QQQ	ETF	621.97	622.04	621.91	621.98	5604.0
2025-12-24 06:00:00	QQQ	ETF	621.94	622.12	621.85	621.89	12669.0
2025-12-24 06:30:00	QQQ	ETF	621.88	621.94	621.8	621.9	7745.0
2025-12-24 07:00:00	QQQ	ETF	621.94	622.5	621.88	622.25	26662.0
2025-12-24 07:30:00	QQQ	ETF	622.27	622.54	622.27	622.52	19623.0
2025-12-24 08:00:00	QQQ	ETF	622.5	622.576	621.59	622.38	80606.0
2025-12-24 08:30:00	QQQ	ETF	622.37	622.86	622.33	622.68	93673.0
2025-12-24 09:00:00	QQQ	ETF	622.68	622.69	621.92	621.98	144294.0
2025-12-24 09:30:00	QQQ	ETF	622.0	622.78	621.72	622.34	2845367.0
2025-12-24 10:00:00	QQQ	ETF	622.3232	623.075	622.19	622.4813	1976313.0
2025-12-24 10:30:00	QQQ	ETF	622.4812	622.87	622.32	622.7913	1307802.0
2025-12-24 11:00:00	QQQ	ETF	622.8	623.43	622.78	623.36	1477827.0
2025-12-24 11:30:00	QQQ	ETF	623.37	624.08	623.29	623.88	1803503.0
2025-12-24 12:00:00	QQQ	ETF	623.89	624.04	623.611	623.87	1188191.0
2025-12-24 12:30:00	QQQ	ETF	623.86	624.28	623.65	623.94	2453486.0
2025-12-24 13:00:00	QQQ	ETF	623.94	624.0	622.9188	623.1869	1034466.0
2025-12-24 13:30:00	QQQ	ETF	623.18	623.1817	622.95	623.02	106721.0
2025-12-24 14:00:00	QQQ	ETF	623.03	623.25	623.021	623.25	10004.0
2025-12-24 14:30:00	QQQ	ETF	623.25	623.25	623.05	623.1	5438.0
2025-12-24 15:00:00	QQQ	ETF	623.1	623.24	623.1	623.209	5293.0
2025-12-24 15:30:00	QQQ	ETF	623.19	623.32	623.18	623.2	10554.0

> showing 50 of 27,235 rows — these rows as CSV

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