PREVIEW / etf_1hour / 2025-09-18

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-18.parquet
  size:    697 KB
  rows:    27,077

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-18 04:00:00	SPY	ETF	663.11	665.02	663.04	664.95	92278.0
2025-09-18 05:00:00	SPY	ETF	664.95	665.1	664.54	664.67	93080.0
2025-09-18 06:00:00	SPY	ETF	664.69	664.9	663.85	664.12	150351.0
2025-09-18 07:00:00	SPY	ETF	664.18	664.8	663.78	664.1	230792.0
2025-09-18 08:00:00	SPY	ETF	664.55	665.01	659.2174	662.47	497101.0
2025-09-18 09:00:00	SPY	ETF	662.49	662.53	660.27	662.06	11195788.0
2025-09-18 10:00:00	SPY	ETF	662.06	664.89	662.0	662.77	11726334.0
2025-09-18 11:00:00	SPY	ETF	662.77	663.99	662.1751	662.5999	6394987.0
2025-09-18 12:00:00	SPY	ETF	662.575	664.19	662.31	664.045	4352653.0
2025-09-18 13:00:00	SPY	ETF	664.04	664.23	662.52	662.79	4541108.0
2025-09-18 14:00:00	SPY	ETF	662.79	663.51	662.34	663.24	4502472.0
2025-09-18 15:00:00	SPY	ETF	663.24	663.44	661.955	662.28	14938070.0
2025-09-18 16:00:00	SPY	ETF	662.29	663.1308	662.18	662.98	2858465.0
2025-09-18 17:00:00	SPY	ETF	662.99	663.04	662.98	662.99	66999.0
2025-09-18 18:00:00	SPY	ETF	663.03	663.5799	662.8898	663.5	102125.0
2025-09-18 19:00:00	SPY	ETF	663.5	663.66	663.4	663.41	55029.0
2025-09-18 04:00:00	QQQ	ETF	594.57	596.22	593.15	596.16	117762.0
2025-09-18 05:00:00	QQQ	ETF	596.17	596.22	595.69	595.91	76138.0
2025-09-18 06:00:00	QQQ	ETF	595.87	596.15	595.31	595.63	70840.0
2025-09-18 07:00:00	QQQ	ETF	595.58	596.79	595.35	596.46	198858.0
2025-09-18 08:00:00	QQQ	ETF	596.22	596.92	592.87	595.2	373238.0
2025-09-18 09:00:00	QQQ	ETF	595.16	595.72	592.96	595.32	8492453.0
2025-09-18 10:00:00	QQQ	ETF	595.32	597.97	595.25	596.205	7547160.0
2025-09-18 11:00:00	QQQ	ETF	596.21	598.14	596.01	596.29	5905005.0
2025-09-18 12:00:00	QQQ	ETF	596.28	597.6	595.9	597.47	3520882.0
2025-09-18 13:00:00	QQQ	ETF	597.47	597.685	595.935	596.2	4157795.0
2025-09-18 14:00:00	QQQ	ETF	596.19	596.95	596.04	596.72	2865599.0
2025-09-18 15:00:00	QQQ	ETF	596.72	596.7708	595.29	595.38	7596237.0
2025-09-18 16:00:00	QQQ	ETF	595.38	595.93	595.03	595.75	2050374.0
2025-09-18 17:00:00	QQQ	ETF	595.8	596.0	595.69	595.87	26434.0
2025-09-18 18:00:00	QQQ	ETF	595.82	596.4	595.68	596.29	44559.0
2025-09-18 19:00:00	QQQ	ETF	596.3	596.51	596.17	596.35	96675.0
2025-09-18 04:00:00	IWM	ETF	241.16	242.4	241.03	242.39	56837.0
2025-09-18 05:00:00	IWM	ETF	242.38	242.76	242.26	242.48	45434.0
2025-09-18 06:00:00	IWM	ETF	242.51	242.75	242.1	242.36	47615.0
2025-09-18 07:00:00	IWM	ETF	242.35	242.84	241.77	241.94	158168.0
2025-09-18 08:00:00	IWM	ETF	241.75	242.8593	239.58	240.81	442031.0
2025-09-18 09:00:00	IWM	ETF	240.79	241.985	240.13	241.97	5177288.0
2025-09-18 10:00:00	IWM	ETF	241.96	243.51	241.91	242.0	5691672.0
2025-09-18 11:00:00	IWM	ETF	242.01	243.085	241.65	242.93	4207577.0
2025-09-18 12:00:00	IWM	ETF	242.91	244.6	242.91	244.575	3367618.0
2025-09-18 13:00:00	IWM	ETF	244.55	244.865	244.125	244.2	4024222.0
2025-09-18 14:00:00	IWM	ETF	244.2	244.7489	243.94	244.71	3067619.0
2025-09-18 15:00:00	IWM	ETF	244.71	245.15	244.2	244.82	8278028.0
2025-09-18 16:00:00	IWM	ETF	244.82	245.06	244.5	244.98	1922641.0
2025-09-18 17:00:00	IWM	ETF	245.03	245.06	244.93	245.01	11911.0
2025-09-18 18:00:00	IWM	ETF	245.0	245.41	244.9203	245.344	50858.0
2025-09-18 19:00:00	IWM	ETF	245.3491	245.65	245.3491	245.5383	36654.0
2025-09-18 04:00:00	DIA	ETF	463.6	464.68	463.34	464.47	4234.0
2025-09-18 05:00:00	DIA	ETF	464.59	464.78	464.43	464.53	6359.0

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

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