PREVIEW / etf_30min / 2025-02-24

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-02-24.parquet
  size:    972 KB
  rows:    40,373

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-02-24 04:00:00	SPY	ETF	601.74	603.78	601.74	603.69	41072.0
2025-02-24 04:30:00	SPY	ETF	603.63	603.72	603.15	603.25	49346.0
2025-02-24 05:00:00	SPY	ETF	603.26	603.32	602.96	603.01	29752.0
2025-02-24 05:30:00	SPY	ETF	603.08	603.16	602.91	603.0	12000.0
2025-02-24 06:00:00	SPY	ETF	602.71	603.25	602.71	603.23	9931.0
2025-02-24 06:30:00	SPY	ETF	603.23	603.35	602.9	603.14	77668.0
2025-02-24 07:00:00	SPY	ETF	603.13	603.15	602.47	602.66	210726.0
2025-02-24 07:30:00	SPY	ETF	602.66	603.09	602.4	602.87	42900.0
2025-02-24 08:00:00	SPY	ETF	602.91	603.5996	601.5	603.09	190777.0
2025-02-24 08:30:00	SPY	ETF	603.07	603.23	602.82	603.2091	115890.0
2025-02-24 09:00:00	SPY	ETF	603.2	603.27	601.89	602.0	234633.0
2025-02-24 09:30:00	SPY	ETF	602.02	603.03	598.6313	598.76	4122452.0
2025-02-24 10:00:00	SPY	ETF	598.76	599.445	596.49	597.95	4465641.0
2025-02-24 10:30:00	SPY	ETF	597.93	598.45	596.75	597.7	1843613.0
2025-02-24 11:00:00	SPY	ETF	597.72	600.38	597.47	600.0962	2100408.0
2025-02-24 11:30:00	SPY	ETF	600.13	600.8	599.4019	599.97	1436216.0
2025-02-24 12:00:00	SPY	ETF	599.98	601.58	599.8202	601.04	1107293.0
2025-02-24 12:30:00	SPY	ETF	601.08	601.85	600.55	600.635	935100.0
2025-02-24 13:00:00	SPY	ETF	600.644	601.71	600.53	601.41	625649.0
2025-02-24 13:30:00	SPY	ETF	601.39	601.6133	600.36	600.64	579848.0
2025-02-24 14:00:00	SPY	ETF	600.62	601.43	599.84	600.07	1304749.0
2025-02-24 14:30:00	SPY	ETF	600.06	600.66	599.39	599.78	1282729.0
2025-02-24 15:00:00	SPY	ETF	599.81	600.03	598.9	599.1	2558965.0
2025-02-24 15:30:00	SPY	ETF	599.11	599.72	596.64	597.2	7684730.0
2025-02-24 16:00:00	SPY	ETF	597.2	597.98	596.93	597.64	3745417.0
2025-02-24 16:30:00	SPY	ETF	597.6	597.75	597.32	597.63	164817.0
2025-02-24 17:00:00	SPY	ETF	597.6	597.64	597.4	597.44	28188.0
2025-02-24 17:30:00	SPY	ETF	597.4599	597.53	597.44	597.52	12138.0
2025-02-24 18:00:00	SPY	ETF	597.57	597.9	597.48	597.82	39540.0
2025-02-24 18:30:00	SPY	ETF	597.85	597.85	596.64	597.0	60119.0
2025-02-24 19:00:00	SPY	ETF	597.1	598.13	597.09	597.98	26769.0
2025-02-24 19:30:00	SPY	ETF	598.03	598.21	597.9	598.03	48347.0
2025-02-24 04:00:00	QQQ	ETF	528.43	529.35	527.77	529.19	59506.0
2025-02-24 04:30:00	QQQ	ETF	529.21	529.31	528.5	528.69	33022.0
2025-02-24 05:00:00	QQQ	ETF	528.67	528.72	528.14	528.26	12423.0
2025-02-24 05:30:00	QQQ	ETF	528.24	528.36	528.05	528.16	6844.0
2025-02-24 06:00:00	QQQ	ETF	528.14	528.59	527.82	528.49	18218.0
2025-02-24 06:30:00	QQQ	ETF	528.47	528.72	528.15	528.55	25348.0
2025-02-24 07:00:00	QQQ	ETF	528.48	528.5	527.681	527.89	71628.0
2025-02-24 07:30:00	QQQ	ETF	527.95	528.371	527.63	528.04	54972.0
2025-02-24 08:00:00	QQQ	ETF	527.92	529.194	526.85	528.56	175429.0
2025-02-24 08:30:00	QQQ	ETF	528.48	529.09	528.39	529.0699	122544.0
2025-02-24 09:00:00	QQQ	ETF	529.0601	529.14	527.51	527.91	222945.0
2025-02-24 09:30:00	QQQ	ETF	527.88	529.069	523.2	523.34	4074239.0
2025-02-24 10:00:00	QQQ	ETF	523.34	523.79	520.1892	521.88	3877102.0
2025-02-24 10:30:00	QQQ	ETF	521.84	522.42	520.37	521.55	2273750.0
2025-02-24 11:00:00	QQQ	ETF	521.59	524.34	521.18	524.02	1822839.0
2025-02-24 11:30:00	QQQ	ETF	524.05	524.775	523.06	523.66	1623038.0
2025-02-24 12:00:00	QQQ	ETF	523.66	525.49	523.48	524.895	1427261.0
2025-02-24 12:30:00	QQQ	ETF	524.93	525.65	524.23	524.3346	891168.0

> showing 50 of 40,373 rows — these rows as CSV

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