PREVIEW / etf_1hour / 2025-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-01.parquet
  size:    709 KB
  rows:    27,577

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-10-01 04:00:00	SPY	ETF	661.23	662.34	660.93	662.1	78969.0
2025-10-01 05:00:00	SPY	ETF	662.16	663.03	662.04	662.72	86690.0
2025-10-01 06:00:00	SPY	ETF	662.76	663.07	662.31	662.5	27665.0
2025-10-01 07:00:00	SPY	ETF	662.47	663.95	662.47	663.91	133461.0
2025-10-01 08:00:00	SPY	ETF	662.74	666.18	660.51	663.5494	675972.0
2025-10-01 09:00:00	SPY	ETF	663.55	665.39	663.03	663.735	9192679.0
2025-10-01 10:00:00	SPY	ETF	663.74	666.06	663.41	665.805	7720157.0
2025-10-01 11:00:00	SPY	ETF	665.805	667.18	665.75	666.975	5930930.0
2025-10-01 12:00:00	SPY	ETF	666.99	667.16	666.43	666.91	3662989.0
2025-10-01 13:00:00	SPY	ETF	666.92	668.09	666.82	667.955	4492625.0
2025-10-01 14:00:00	SPY	ETF	667.95	669.35	667.89	669.13	5192626.0
2025-10-01 15:00:00	SPY	ETF	669.13	669.37	668.48	668.51	11286863.0
2025-10-01 16:00:00	SPY	ETF	668.5	668.56	666.8186	668.14	4510161.0
2025-10-01 17:00:00	SPY	ETF	668.17	668.24	667.96	668.0	90879.0
2025-10-01 18:00:00	SPY	ETF	668.07	668.48	668.07	668.25	97586.0
2025-10-01 19:00:00	SPY	ETF	668.25	668.55	668.01	668.2915	48414.0
2025-10-01 04:00:00	QQQ	ETF	596.88	596.88	594.62	596.13	202084.0
2025-10-01 05:00:00	QQQ	ETF	596.08	597.26	596.02	596.8	89903.0
2025-10-01 06:00:00	QQQ	ETF	596.86	597.2	596.2	596.43	75078.0
2025-10-01 07:00:00	QQQ	ETF	596.48	598.12	596.43	598.04	258590.0
2025-10-01 08:00:00	QQQ	ETF	596.45	599.92	594.31	597.52	794272.0
2025-10-01 09:00:00	QQQ	ETF	597.54	599.07	596.34	597.6	6558287.0
2025-10-01 10:00:00	QQQ	ETF	597.59	600.79	597.14	600.47	5133607.0
2025-10-01 11:00:00	QQQ	ETF	600.45	601.45	599.94	601.285	3877936.0
2025-10-01 12:00:00	QQQ	ETF	601.29	601.9051	601.21	601.8399	2696234.0
2025-10-01 13:00:00	QQQ	ETF	601.835	602.69	601.775	602.54	3180422.0
2025-10-01 14:00:00	QQQ	ETF	602.53	603.76	602.38	603.51	3519972.0
2025-10-01 15:00:00	QQQ	ETF	603.51	603.79	601.48	603.27	7005781.0
2025-10-01 16:00:00	QQQ	ETF	603.27	603.31	602.83	603.2	1295633.0
2025-10-01 17:00:00	QQQ	ETF	603.15	603.2802	603.01	603.17	36201.0
2025-10-01 18:00:00	QQQ	ETF	603.02	603.4495	603.0	603.33	51460.0
2025-10-01 19:00:00	QQQ	ETF	603.33	603.6196	603.08	603.44	58887.0
2025-10-01 04:00:00	IWM	ETF	240.02	240.44	239.74	240.35	60463.0
2025-10-01 05:00:00	IWM	ETF	240.37	240.91	240.33	240.76	27428.0
2025-10-01 06:00:00	IWM	ETF	240.78	240.91	240.53	240.63	36977.0
2025-10-01 07:00:00	IWM	ETF	240.61	241.57	240.59	241.51	38423.0
2025-10-01 08:00:00	IWM	ETF	240.75	241.55	239.16	240.93	532869.0
2025-10-01 09:00:00	IWM	ETF	240.93	242.02	240.47	240.93	4894605.0
2025-10-01 10:00:00	IWM	ETF	240.91	242.16	240.64	241.705	2751824.0
2025-10-01 11:00:00	IWM	ETF	241.695	242.38	241.35	242.11	2580219.0
2025-10-01 12:00:00	IWM	ETF	242.115	242.18	241.38	241.57	1709941.0
2025-10-01 13:00:00	IWM	ETF	241.59	241.985	241.315	241.46	1798812.0
2025-10-01 14:00:00	IWM	ETF	241.46	242.71	241.45	242.515	1988802.0
2025-10-01 15:00:00	IWM	ETF	242.515	243.04	242.4	242.53	4617105.0
2025-10-01 16:00:00	IWM	ETF	242.49	242.6	242.22	242.38	935421.0
2025-10-01 17:00:00	IWM	ETF	242.45	242.47	242.15	242.15	10453.0
2025-10-01 18:00:00	IWM	ETF	242.35	242.55	242.35	242.45	8795.0
2025-10-01 19:00:00	IWM	ETF	242.45	242.58	242.27	242.49	31840.0
2025-10-01 04:00:00	DIA	ETF	460.72	461.4	460.67	461.34	2834.0
2025-10-01 05:00:00	DIA	ETF	461.34	461.68	461.34	461.64	900.0

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

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