PREVIEW / etf_30min / 2025-01-02

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-02.parquet
  size:    947 KB
  rows:    38,888

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-01-02 04:00:00	SPY	ETF	588.22	589.86	588.12	589.69	16324.0
2025-01-02 04:30:00	SPY	ETF	589.62	589.8	588.84	589.8	11138.0
2025-01-02 05:00:00	SPY	ETF	589.89	590.01	589.16	589.54	6315.0
2025-01-02 05:30:00	SPY	ETF	589.64	589.95	589.24	589.92	55052.0
2025-01-02 06:00:00	SPY	ETF	589.89	589.97	589.48	589.9	67077.0
2025-01-02 06:30:00	SPY	ETF	589.74	591.74	589.59	591.61	78292.0
2025-01-02 07:00:00	SPY	ETF	591.57	592.06	590.94	592.009	344811.0
2025-01-02 07:30:00	SPY	ETF	591.99	591.99	590.36	590.94	133550.0
2025-01-02 08:00:00	SPY	ETF	591.01	592.0113	588.49	590.48	128497.0
2025-01-02 08:30:00	SPY	ETF	590.52	591.35	586.08	590.34	66022.0
2025-01-02 09:00:00	SPY	ETF	590.4	590.45	589.0	589.31	299225.0
2025-01-02 09:30:00	SPY	ETF	589.39	590.52	586.14	590.17	4708972.0
2025-01-02 10:00:00	SPY	ETF	590.18	591.13	587.312	587.83	2966521.0
2025-01-02 10:30:00	SPY	ETF	587.81	588.78	586.34	587.61	1732299.0
2025-01-02 11:00:00	SPY	ETF	587.59	587.8	585.2	587.5301	2066581.0
2025-01-02 11:30:00	SPY	ETF	587.47	588.77	587.12	587.88	1098159.0
2025-01-02 12:00:00	SPY	ETF	587.875	588.67	584.21	584.49	1425818.0
2025-01-02 12:30:00	SPY	ETF	584.47	584.4734	580.94	582.86	4150734.0
2025-01-02 13:00:00	SPY	ETF	582.86	583.09	581.09	582.36	2439176.0
2025-01-02 13:30:00	SPY	ETF	582.325	582.38	580.5	581.9	2640610.0
2025-01-02 14:00:00	SPY	ETF	581.9	583.505	581.41	583.28	1918403.0
2025-01-02 14:30:00	SPY	ETF	583.265	583.99	582.02	582.1305	1702070.0
2025-01-02 15:00:00	SPY	ETF	582.16	584.81	582.14	584.47	1980892.0
2025-01-02 15:30:00	SPY	ETF	584.48	585.37	583.5502	584.58	4583030.0
2025-01-02 16:00:00	SPY	ETF	584.57	585.379	584.5351	585.379	2242954.0
2025-01-02 16:30:00	SPY	ETF	585.34	585.34	584.88	584.92	150472.0
2025-01-02 17:00:00	SPY	ETF	584.95	585.02	584.94	585.0	29441.0
2025-01-02 17:30:00	SPY	ETF	584.96	585.09	584.85	585.0	16987.0
2025-01-02 18:00:00	SPY	ETF	585.0	585.0	584.36	584.37	34984.0
2025-01-02 18:30:00	SPY	ETF	584.46	584.46	584.11	584.4	7083.0
2025-01-02 19:00:00	SPY	ETF	584.35	585.61	584.3	585.55	20513.0
2025-01-02 19:30:00	SPY	ETF	585.51	585.86	585.5001	585.86	57301.0
2025-01-02 04:00:00	QQQ	ETF	514.27	515.66	514.27	515.37	36364.0
2025-01-02 04:30:00	QQQ	ETF	515.35	515.49	514.67	515.39	10808.0
2025-01-02 05:00:00	QQQ	ETF	515.75	515.76	514.64	515.14	18940.0
2025-01-02 05:30:00	QQQ	ETF	515.33	515.56	514.8	515.53	9060.0
2025-01-02 06:00:00	QQQ	ETF	515.53	515.7	515.0	515.7	13098.0
2025-01-02 06:30:00	QQQ	ETF	515.47	517.27	515.27	517.23	40207.0
2025-01-02 07:00:00	QQQ	ETF	517.18	517.7	516.91	517.551	110603.0
2025-01-02 07:30:00	QQQ	ETF	517.59	517.59	515.93	516.63	94744.0
2025-01-02 08:00:00	QQQ	ETF	517.4	517.72	513.9	516.06	143027.0
2025-01-02 08:30:00	QQQ	ETF	516.06	517.15	511.23	516.0	114513.0
2025-01-02 09:00:00	QQQ	ETF	516.0	516.0	514.11	514.31	264159.0
2025-01-02 09:30:00	QQQ	ETF	514.325	515.82	510.02	515.39	4064758.0
2025-01-02 10:00:00	QQQ	ETF	515.44	516.64	512.17	513.05	2378183.0
2025-01-02 10:30:00	QQQ	ETF	512.93	513.9604	511.11	512.7094	1867988.0
2025-01-02 11:00:00	QQQ	ETF	512.74	513.24	510.52	513.0799	1489472.0
2025-01-02 11:30:00	QQQ	ETF	513.0489	514.58	512.5	513.64	1121277.0
2025-01-02 12:00:00	QQQ	ETF	513.61	514.24	509.52	509.73	1619276.0
2025-01-02 12:30:00	QQQ	ETF	509.71	509.71	505.71	507.92	3186021.0

> showing 50 of 38,888 rows — these rows as CSV

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