PREVIEW / etf_30min / 2025-09-24

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-09-24.parquet
  size:    1.0 MB
  rows:    42,875

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-09-24 04:00:00	SPY	ETF	663.6	664.56	663.6	664.1	22780.0
2025-09-24 04:30:00	SPY	ETF	664.08	664.26	664.07	664.24	11555.0
2025-09-24 05:00:00	SPY	ETF	664.27	664.5	664.27	664.5	12680.0
2025-09-24 05:30:00	SPY	ETF	664.52	664.52	664.3	664.44	1957.0
2025-09-24 06:00:00	SPY	ETF	664.42	664.49	664.09	664.09	4573.0
2025-09-24 06:30:00	SPY	ETF	664.19	664.38	664.06	664.37	2900.0
2025-09-24 07:00:00	SPY	ETF	664.36	664.64	664.33	664.49	47631.0
2025-09-24 07:30:00	SPY	ETF	664.48	664.65	664.0	664.45	69036.0
2025-09-24 08:00:00	SPY	ETF	664.38	664.62	663.41	664.3	95100.0
2025-09-24 08:30:00	SPY	ETF	664.33	664.4	664.16	664.4	97111.0
2025-09-24 09:00:00	SPY	ETF	664.42	664.58	664.11	664.49	198159.0
2025-09-24 09:30:00	SPY	ETF	664.5	664.61	662.42	663.04	6310124.0
2025-09-24 10:00:00	SPY	ETF	663.045	663.49	662.65	663.21	3760109.0
2025-09-24 10:30:00	SPY	ETF	663.19	663.655	662.7851	662.93	2665020.0
2025-09-24 11:00:00	SPY	ETF	662.92	663.13	662.4	662.66	2048488.0
2025-09-24 11:30:00	SPY	ETF	662.65	662.685	660.26	660.39	4237067.0
2025-09-24 12:00:00	SPY	ETF	660.39	661.12	659.67	660.91	5232505.0
2025-09-24 12:30:00	SPY	ETF	660.92	661.11	660.4	660.52	2049278.0
2025-09-24 13:00:00	SPY	ETF	660.55	661.68	660.44	661.37	2372202.0
2025-09-24 13:30:00	SPY	ETF	661.38	661.8	660.39	660.57	2808066.0
2025-09-24 14:00:00	SPY	ETF	660.56	660.68	659.96	660.385	2981493.0
2025-09-24 14:30:00	SPY	ETF	660.39	661.15	660.26	661.105	2683473.0
2025-09-24 15:00:00	SPY	ETF	661.11	661.12	660.57	660.795	2252700.0
2025-09-24 15:30:00	SPY	ETF	660.81	661.38	660.485	661.04	7505713.0
2025-09-24 16:00:00	SPY	ETF	661.04	661.74	661.04	661.52	2551779.0
2025-09-24 16:30:00	SPY	ETF	661.51	661.6699	661.44	661.47	65162.0
2025-09-24 17:00:00	SPY	ETF	661.5	661.5	661.3	661.34	22622.0
2025-09-24 17:30:00	SPY	ETF	661.19	661.5	661.19	661.5	168671.0
2025-09-24 18:00:00	SPY	ETF	661.58	661.64	661.28	661.29	40928.0
2025-09-24 18:30:00	SPY	ETF	661.35	661.52	661.35	661.49	11007.0
2025-09-24 19:00:00	SPY	ETF	661.45	661.52	661.3501	661.41	5666.0
2025-09-24 19:30:00	SPY	ETF	661.31	661.71	661.28	661.71	24043.0
2025-09-24 04:00:00	QQQ	ETF	599.81	600.03	599.58	599.61	44263.0
2025-09-24 04:30:00	QQQ	ETF	599.53	599.82	599.53	599.8	22004.0
2025-09-24 05:00:00	QQQ	ETF	599.82	600.07	599.77	599.98	36893.0
2025-09-24 05:30:00	QQQ	ETF	600.0	600.13	599.82	600.07	16981.0
2025-09-24 06:00:00	QQQ	ETF	599.99	600.16	599.57	599.58	20361.0
2025-09-24 06:30:00	QQQ	ETF	599.62	600.08	599.57	600.02	29862.0
2025-09-24 07:00:00	QQQ	ETF	599.99	600.2	599.86	599.86	26170.0
2025-09-24 07:30:00	QQQ	ETF	599.92	600.0	599.32	599.76	38861.0
2025-09-24 08:00:00	QQQ	ETF	599.97	600.17	598.4	599.46	309105.0
2025-09-24 08:30:00	QQQ	ETF	599.43	599.54	599.19	599.47	159126.0
2025-09-24 09:00:00	QQQ	ETF	599.49	599.65	599.27	599.52	101082.0
2025-09-24 09:30:00	QQQ	ETF	599.57	599.9	597.13	598.0013	5473025.0
2025-09-24 10:00:00	QQQ	ETF	597.99	598.46	597.6	597.93	2843929.0
2025-09-24 10:30:00	QQQ	ETF	597.92	598.22	597.27	597.342	2040122.0
2025-09-24 11:00:00	QQQ	ETF	597.35	597.73	596.9402	597.355	2010532.0
2025-09-24 11:30:00	QQQ	ETF	597.36	597.365	594.55	594.6	3375791.0
2025-09-24 12:00:00	QQQ	ETF	594.6	595.21	593.36	595.05	4727318.0
2025-09-24 12:30:00	QQQ	ETF	595.05	595.24	594.6	594.74	1973485.0

> showing 50 of 42,875 rows — these rows as CSV

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