PREVIEW / etf_1hour / 2025-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-30.parquet
  size:    694 KB
  rows:    27,138

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-30 04:00:00	SPY	ETF	662.08	662.8	662.0	662.65	19836.0
2025-09-30 05:00:00	SPY	ETF	662.64	662.82	662.35	662.39	7415.0
2025-09-30 06:00:00	SPY	ETF	662.46	662.69	661.93	662.63	72795.0
2025-09-30 07:00:00	SPY	ETF	662.59	662.72	662.18	662.4	59042.0
2025-09-30 08:00:00	SPY	ETF	662.43	663.69	661.9	663.06	218525.0
2025-09-30 09:00:00	SPY	ETF	663.061	663.28	661.9693	663.08	5582320.0
2025-09-30 10:00:00	SPY	ETF	663.05	663.5512	661.691	663.22	7406524.0
2025-09-30 11:00:00	SPY	ETF	663.22	663.63	661.61	663.0	5398245.0
2025-09-30 12:00:00	SPY	ETF	662.99	664.0526	662.59	662.819	3625309.0
2025-09-30 13:00:00	SPY	ETF	662.81	663.085	661.78	662.53	4804559.0
2025-09-30 14:00:00	SPY	ETF	662.51	664.63	662.425	664.422	6336163.0
2025-09-30 15:00:00	SPY	ETF	664.42	666.65	664.36	666.11	20763341.0
2025-09-30 16:00:00	SPY	ETF	666.09	666.23	664.5	664.79	5734769.0
2025-09-30 17:00:00	SPY	ETF	664.9	664.95	664.68	664.88	74248.0
2025-09-30 18:00:00	SPY	ETF	664.87	665.55	664.5	664.6904	191400.0
2025-09-30 19:00:00	SPY	ETF	664.75	664.97	664.38	664.68	49136.0
2025-09-30 04:00:00	QQQ	ETF	597.71	598.24	597.1	597.95	55311.0
2025-09-30 05:00:00	QQQ	ETF	597.96	598.43	597.65	597.86	69883.0
2025-09-30 06:00:00	QQQ	ETF	597.82	598.26	597.31	598.12	72618.0
2025-09-30 07:00:00	QQQ	ETF	598.1	598.37	597.7	598.08	60183.0
2025-09-30 08:00:00	QQQ	ETF	598.06	599.179	597.0	598.75	227766.0
2025-09-30 09:00:00	QQQ	ETF	598.78	598.78	596.1	597.63	4310987.0
2025-09-30 10:00:00	QQQ	ETF	597.72	599.21	596.66	598.94	5064504.0
2025-09-30 11:00:00	QQQ	ETF	598.94	599.41	596.85	598.2	4533417.0
2025-09-30 12:00:00	QQQ	ETF	598.18	598.97	597.22	597.54	2557537.0
2025-09-30 13:00:00	QQQ	ETF	597.53	597.88	596.33	597.21	3242101.0
2025-09-30 14:00:00	QQQ	ETF	597.2	599.2	597.04	598.855	2908617.0
2025-09-30 15:00:00	QQQ	ETF	598.87	600.71	598.48	600.33	6967950.0
2025-09-30 16:00:00	QQQ	ETF	600.32	600.4196	598.84	598.94	1312313.0
2025-09-30 17:00:00	QQQ	ETF	599.0	599.38	599.0	599.22	66041.0
2025-09-30 18:00:00	QQQ	ETF	599.05	599.8	598.62	598.85	99128.0
2025-09-30 19:00:00	QQQ	ETF	598.86	599.1399	598.54	598.75	69799.0
2025-09-30 04:00:00	IWM	ETF	241.19	241.28	240.83	241.17	24437.0
2025-09-30 05:00:00	IWM	ETF	241.1	241.14	240.85	240.91	9991.0
2025-09-30 06:00:00	IWM	ETF	240.9	241.03	240.46	240.84	15406.0
2025-09-30 07:00:00	IWM	ETF	240.83	240.83	240.45	240.73	42207.0
2025-09-30 08:00:00	IWM	ETF	240.62	241.62	240.47	241.15	69084.0
2025-09-30 09:00:00	IWM	ETF	241.163	242.125	240.92	241.57	2780898.0
2025-09-30 10:00:00	IWM	ETF	241.56	241.82	239.98	240.305	3210619.0
2025-09-30 11:00:00	IWM	ETF	240.3	240.45	239.53	239.95	3064668.0
2025-09-30 12:00:00	IWM	ETF	239.96	240.5	239.645	239.77	2061650.0
2025-09-30 13:00:00	IWM	ETF	239.7693	240.1893	239.4	239.9	2338848.0
2025-09-30 14:00:00	IWM	ETF	239.89	240.4	239.83	240.18	2758367.0
2025-09-30 15:00:00	IWM	ETF	240.19	242.065	240.1	241.96	6921230.0
2025-09-30 16:00:00	IWM	ETF	241.96	242.09	241.05	241.25	1745618.0
2025-09-30 17:00:00	IWM	ETF	241.15	241.5	241.02	241.26	39631.0
2025-09-30 18:00:00	IWM	ETF	241.43	241.48	241.0	241.07	65715.0
2025-09-30 19:00:00	IWM	ETF	241.08	241.3	240.92	241.18	8292.0
2025-09-30 04:00:00	DIA	ETF	461.89	462.11	461.86	462.08	800.0
2025-09-30 05:00:00	DIA	ETF	462.03	462.2	462.02	462.2	700.0

> showing 50 of 27,138 rows — these rows as CSV

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