PREVIEW / etf_1hour / 2025-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-26.parquet
  size:    685 KB
  rows:    26,087

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-26 04:00:00	SPY	ETF	657.36	659.4	657.36	658.3	32690.0
2025-09-26 05:00:00	SPY	ETF	658.14	658.67	657.85	658.66	12904.0
2025-09-26 06:00:00	SPY	ETF	658.29	658.34	657.93	658.15	9158.0
2025-09-26 07:00:00	SPY	ETF	658.16	659.0	657.9	658.71	66136.0
2025-09-26 08:00:00	SPY	ETF	658.67	661.1	657.6	660.24	703252.0
2025-09-26 09:00:00	SPY	ETF	660.28	661.9	658.92	661.79	8356156.0
2025-09-26 10:00:00	SPY	ETF	661.8	662.37	657.88	658.45	9802736.0
2025-09-26 11:00:00	SPY	ETF	658.44	660.06	658.05	658.67	4802209.0
2025-09-26 12:00:00	SPY	ETF	658.68	661.495	658.5	661.33	4631908.0
2025-09-26 13:00:00	SPY	ETF	661.33	661.755	660.76	661.35	4059005.0
2025-09-26 14:00:00	SPY	ETF	661.34	662.14	660.85	661.92	4790096.0
2025-09-26 15:00:00	SPY	ETF	661.915	662.01	661.15	661.75	8425056.0
2025-09-26 16:00:00	SPY	ETF	661.75	662.37	661.65	661.85	3001635.0
2025-09-26 17:00:00	SPY	ETF	661.85	661.98	661.5	661.65	42303.0
2025-09-26 18:00:00	SPY	ETF	661.7	662.1	661.6657	661.99	17176.0
2025-09-26 19:00:00	SPY	ETF	662.02	662.15	662.02	662.11	12696.0
2025-09-26 04:00:00	QQQ	ETF	593.72	594.34	592.62	592.62	52549.0
2025-09-26 05:00:00	QQQ	ETF	592.62	593.44	592.26	593.36	53957.0
2025-09-26 06:00:00	QQQ	ETF	593.42	593.64	592.63	592.96	157519.0
2025-09-26 07:00:00	QQQ	ETF	592.94	594.28	592.78	593.92	67505.0
2025-09-26 08:00:00	QQQ	ETF	593.93	596.57	592.38	595.3	576836.0
2025-09-26 09:00:00	QQQ	ETF	595.31	595.765	592.96	595.525	6446765.0
2025-09-26 10:00:00	QQQ	ETF	595.55	596.2	591.06	592.18	9295275.0
2025-09-26 11:00:00	QQQ	ETF	592.18	593.87	591.72	592.565	4991229.0
2025-09-26 12:00:00	QQQ	ETF	592.585	595.39	592.27	595.175	4288438.0
2025-09-26 13:00:00	QQQ	ETF	595.18	595.8086	594.57	595.205	3593748.0
2025-09-26 14:00:00	QQQ	ETF	595.2	596.3	594.73	596.035	3587806.0
2025-09-26 15:00:00	QQQ	ETF	596.03	596.27	595.4045	596.05	5200325.0
2025-09-26 16:00:00	QQQ	ETF	596.05	596.53	595.94	596.0403	1527496.0
2025-09-26 17:00:00	QQQ	ETF	596.15	596.22	596.0	596.12	23978.0
2025-09-26 18:00:00	QQQ	ETF	596.1501	596.2867	596.02	596.2	6374.0
2025-09-26 19:00:00	QQQ	ETF	596.19	596.26	596.15	596.15	4479.0
2025-09-26 04:00:00	IWM	ETF	239.6	239.87	239.09	239.09	25468.0
2025-09-26 05:00:00	IWM	ETF	239.04	239.26	238.85	239.18	16893.0
2025-09-26 06:00:00	IWM	ETF	239.12	239.13	238.52	238.77	19462.0
2025-09-26 07:00:00	IWM	ETF	238.85	239.25	238.8	239.03	33892.0
2025-09-26 08:00:00	IWM	ETF	239.02	240.49	238.8003	239.98	304435.0
2025-09-26 09:00:00	IWM	ETF	240.03	241.35	239.4	241.32	3776372.0
2025-09-26 10:00:00	IWM	ETF	241.34	241.68	239.5051	239.6	3535454.0
2025-09-26 11:00:00	IWM	ETF	239.61	240.53	239.3344	239.99	2327957.0
2025-09-26 12:00:00	IWM	ETF	240.01	241.14	239.87	241.095	2181732.0
2025-09-26 13:00:00	IWM	ETF	241.09	241.28	240.81	241.18	1709657.0
2025-09-26 14:00:00	IWM	ETF	241.17	241.39	240.79	241.34	1768753.0
2025-09-26 15:00:00	IWM	ETF	241.34	241.64	241.04	241.36	4337288.0
2025-09-26 16:00:00	IWM	ETF	241.34	241.53	241.25	241.25	709894.0
2025-09-26 17:00:00	IWM	ETF	241.24	241.35	241.2	241.2588	7912.0
2025-09-26 18:00:00	IWM	ETF	241.3	241.43	241.25	241.27	4383.0
2025-09-26 19:00:00	IWM	ETF	241.4	241.42	241.34	241.3603	4983.0
2025-09-26 04:00:00	DIA	ETF	460.42	460.75	460.3	460.3	6140.0
2025-09-26 05:00:00	DIA	ETF	460.2	460.38	460.2	460.38	1525.0

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

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