PREVIEW / etf_1hour / 2025-09-24

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-24.parquet
  size:    691 KB
  rows:    26,371

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.24	34335.0
2025-09-24 05:00:00	SPY	ETF	664.27	664.52	664.27	664.44	14637.0
2025-09-24 06:00:00	SPY	ETF	664.42	664.49	664.06	664.37	7473.0
2025-09-24 07:00:00	SPY	ETF	664.36	664.65	664.0	664.45	116667.0
2025-09-24 08:00:00	SPY	ETF	664.38	664.62	663.41	664.4	192211.0
2025-09-24 09:00:00	SPY	ETF	664.42	664.61	662.42	663.04	6508283.0
2025-09-24 10:00:00	SPY	ETF	663.045	663.655	662.65	662.93	6425129.0
2025-09-24 11:00:00	SPY	ETF	662.92	663.13	660.26	660.39	6285555.0
2025-09-24 12:00:00	SPY	ETF	660.39	661.12	659.67	660.52	7281783.0
2025-09-24 13:00:00	SPY	ETF	660.55	661.8	660.39	660.57	5180268.0
2025-09-24 14:00:00	SPY	ETF	660.56	661.15	659.96	661.105	5664966.0
2025-09-24 15:00:00	SPY	ETF	661.11	661.38	660.485	661.04	9758413.0
2025-09-24 16:00:00	SPY	ETF	661.04	661.74	661.04	661.47	2616941.0
2025-09-24 17:00:00	SPY	ETF	661.5	661.5	661.19	661.5	191293.0
2025-09-24 18:00:00	SPY	ETF	661.58	661.64	661.28	661.49	51935.0
2025-09-24 19:00:00	SPY	ETF	661.45	661.71	661.28	661.71	29709.0
2025-09-24 04:00:00	QQQ	ETF	599.81	600.03	599.53	599.8	66267.0
2025-09-24 05:00:00	QQQ	ETF	599.82	600.13	599.77	600.07	53874.0
2025-09-24 06:00:00	QQQ	ETF	599.99	600.16	599.57	600.02	50223.0
2025-09-24 07:00:00	QQQ	ETF	599.99	600.2	599.32	599.76	65031.0
2025-09-24 08:00:00	QQQ	ETF	599.97	600.17	598.4	599.47	468231.0
2025-09-24 09:00:00	QQQ	ETF	599.49	599.9	597.13	598.0013	5574107.0
2025-09-24 10:00:00	QQQ	ETF	597.99	598.46	597.27	597.342	4884051.0
2025-09-24 11:00:00	QQQ	ETF	597.35	597.73	594.55	594.6	5386323.0
2025-09-24 12:00:00	QQQ	ETF	594.6	595.24	593.36	594.74	6700803.0
2025-09-24 13:00:00	QQQ	ETF	594.75	596.47	594.68	595.34	3970099.0
2025-09-24 14:00:00	QQQ	ETF	595.34	596.095	594.69	596.05	3297609.0
2025-09-24 15:00:00	QQQ	ETF	596.05	596.31	595.11	596.06	4569722.0
2025-09-24 16:00:00	QQQ	ETF	596.06	596.43	595.8667	596.23	1230804.0
2025-09-24 17:00:00	QQQ	ETF	596.24	596.35	596.1531	596.25	33182.0
2025-09-24 18:00:00	QQQ	ETF	596.25	596.4	596.1	596.32	52549.0
2025-09-24 19:00:00	QQQ	ETF	596.28	596.47	596.1	596.47	34581.0
2025-09-24 04:00:00	IWM	ETF	244.14	244.22	243.98	244.16	21074.0
2025-09-24 05:00:00	IWM	ETF	244.16	244.32	244.03	244.27	17451.0
2025-09-24 06:00:00	IWM	ETF	244.25	244.28	243.91	244.05	28281.0
2025-09-24 07:00:00	IWM	ETF	244.06	244.35	243.96	244.17	94353.0
2025-09-24 08:00:00	IWM	ETF	244.36	244.4	243.62	244.21	163061.0
2025-09-24 09:00:00	IWM	ETF	244.26	244.61	243.175	243.8	3792751.0
2025-09-24 10:00:00	IWM	ETF	243.78	244.5	243.56	243.9	2378405.0
2025-09-24 11:00:00	IWM	ETF	243.94	243.97	241.97	242.14	2524649.0
2025-09-24 12:00:00	IWM	ETF	242.13	242.845	241.555	242.53	2907834.0
2025-09-24 13:00:00	IWM	ETF	242.53	242.93	241.92	242.06	2275891.0
2025-09-24 14:00:00	IWM	ETF	242.05	242.26	241.75	242.195	2541110.0
2025-09-24 15:00:00	IWM	ETF	242.195	242.195	241.605	241.61	4646821.0
2025-09-24 16:00:00	IWM	ETF	241.62	242.15	241.6	242.07	1919740.0
2025-09-24 17:00:00	IWM	ETF	242.13	242.16	241.94	242.0085	11731.0
2025-09-24 18:00:00	IWM	ETF	242.01	242.07	241.92	241.93	20067.0
2025-09-24 19:00:00	IWM	ETF	241.93	242.07	241.84	242.07	12412.0
2025-09-24 04:00:00	DIA	ETF	463.36	463.37	462.87	462.95	1400.0
2025-09-24 05:00:00	DIA	ETF	463.02	463.06	462.89	463.06	300.0

> showing 50 of 26,371 rows — these rows as CSV

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