PREVIEW / etf_1hour / 2025-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-19.parquet
  size:    690 KB
  rows:    26,342

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-19 04:00:00	SPY	ETF	660.5	661.11	660.38	660.97	28440.0
2025-09-19 05:00:00	SPY	ETF	660.95	661.4	660.89	661.06	11711.0
2025-09-19 06:00:00	SPY	ETF	660.88	661.4	660.81	661.39	49154.0
2025-09-19 07:00:00	SPY	ETF	661.38	661.66	661.12	661.61	118104.0
2025-09-19 08:00:00	SPY	ETF	661.57	662.2	659.62	661.87	272466.0
2025-09-19 09:00:00	SPY	ETF	661.85	662.83	661.32	662.15	8329972.0
2025-09-19 10:00:00	SPY	ETF	662.14	662.4	660.96	661.59	6623458.0
2025-09-19 11:00:00	SPY	ETF	661.59	661.945	660.37	661.6	5262269.0
2025-09-19 12:00:00	SPY	ETF	661.59	662.76	661.57	662.53	5176615.0
2025-09-19 13:00:00	SPY	ETF	662.54	662.89	662.21	662.69	3621128.0
2025-09-19 14:00:00	SPY	ETF	662.69	663.11	662.325	663.09	5363611.0
2025-09-19 15:00:00	SPY	ETF	663.09	664.55	663.04	663.64	16924062.0
2025-09-19 16:00:00	SPY	ETF	663.62	663.96	663.28	663.3702	4583914.0
2025-09-19 17:00:00	SPY	ETF	663.47	663.7661	662.9	663.22	1819128.0
2025-09-19 18:00:00	SPY	ETF	663.3	663.68	663.25	663.5	52888.0
2025-09-19 19:00:00	SPY	ETF	663.59	663.6	663.24	663.47	48861.0
2025-09-19 04:00:00	QQQ	ETF	595.29	596.0	595.19	595.81	39331.0
2025-09-19 05:00:00	QQQ	ETF	595.83	596.34	595.75	595.78	33568.0
2025-09-19 06:00:00	QQQ	ETF	595.83	596.4	595.68	596.27	40433.0
2025-09-19 07:00:00	QQQ	ETF	596.31	596.52	596.02	596.52	52272.0
2025-09-19 08:00:00	QQQ	ETF	596.11	596.95	594.61	596.58	238819.0
2025-09-19 09:00:00	QQQ	ETF	596.55	598.43	596.5025	597.83	5962086.0
2025-09-19 10:00:00	QQQ	ETF	597.83	598.22	596.51	597.18	5265993.0
2025-09-19 11:00:00	QQQ	ETF	597.19	597.545	595.85	597.36	4390153.0
2025-09-19 12:00:00	QQQ	ETF	597.34	598.8181	597.33	598.49	4378999.0
2025-09-19 13:00:00	QQQ	ETF	598.49	598.68	597.91	598.3684	2525833.0
2025-09-19 14:00:00	QQQ	ETF	598.38	598.71	598.075	598.545	2463782.0
2025-09-19 15:00:00	QQQ	ETF	598.54	600.05	598.45	599.45	8803431.0
2025-09-19 16:00:00	QQQ	ETF	599.45	600.0833	599.28	599.51	3117014.0
2025-09-19 17:00:00	QQQ	ETF	599.43	599.65	598.9	599.09	83718.0
2025-09-19 18:00:00	QQQ	ETF	599.14	599.46	599.14	599.45	12543.0
2025-09-19 19:00:00	QQQ	ETF	599.4797	600.0	599.35	599.69	29431.0
2025-09-19 04:00:00	IWM	ETF	245.49	245.49	244.74	244.94	26060.0
2025-09-19 05:00:00	IWM	ETF	244.88	245.1	244.76	244.76	13191.0
2025-09-19 06:00:00	IWM	ETF	244.72	244.76	244.46	244.67	54684.0
2025-09-19 07:00:00	IWM	ETF	244.69	245.04	244.53	244.99	34107.0
2025-09-19 08:00:00	IWM	ETF	244.66	245.57	244.34	245.43	148530.0
2025-09-19 09:00:00	IWM	ETF	245.429	246.01	244.11	244.44	3913499.0
2025-09-19 10:00:00	IWM	ETF	244.43	244.55	243.22	243.54	4699924.0
2025-09-19 11:00:00	IWM	ETF	243.55	243.79	242.84	243.39	4116296.0
2025-09-19 12:00:00	IWM	ETF	243.39	243.93	243.26	243.5499	2859524.0
2025-09-19 13:00:00	IWM	ETF	243.55	243.7	243.165	243.285	2470536.0
2025-09-19 14:00:00	IWM	ETF	243.285	243.345	242.51	242.97	3158858.0
2025-09-19 15:00:00	IWM	ETF	242.97	243.27	242.595	242.93	7265320.0
2025-09-19 16:00:00	IWM	ETF	242.93	243.37	242.87	243.37	1533025.0
2025-09-19 17:00:00	IWM	ETF	243.251	243.3	243.073	243.15	21284.0
2025-09-19 18:00:00	IWM	ETF	243.2	243.4799	243.15	243.15	8399.0
2025-09-19 19:00:00	IWM	ETF	243.23	243.3	243.15	243.21	8750.0
2025-09-19 04:00:00	DIA	ETF	461.36	461.68	461.36	461.61	1750.0
2025-09-19 05:00:00	DIA	ETF	461.45	461.5	461.37	461.4	2875.0

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

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