PREVIEW / etf_1hour / 2025-09-08

all etf 1-hour files

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

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-08 04:00:00	SPY	ETF	648.25	648.66	647.9	648.49	18338.0
2025-09-08 05:00:00	SPY	ETF	648.47	648.77	648.3	648.77	7646.0
2025-09-08 06:00:00	SPY	ETF	648.71	648.96	648.7	648.7	18561.0
2025-09-08 07:00:00	SPY	ETF	648.67	648.83	648.25	648.25	83117.0
2025-09-08 08:00:00	SPY	ETF	648.72	648.84	647.61	648.63	162369.0
2025-09-08 09:00:00	SPY	ETF	648.65	649.06	648.0542	648.37	6124915.0
2025-09-08 10:00:00	SPY	ETF	648.375	649.765	647.75	649.38	6263923.0
2025-09-08 11:00:00	SPY	ETF	649.37	649.84	648.5	649.38	4656505.0
2025-09-08 12:00:00	SPY	ETF	649.38	649.4	647.78	648.56	3869282.0
2025-09-08 13:00:00	SPY	ETF	648.56	648.76	647.23	647.59	3006900.0
2025-09-08 14:00:00	SPY	ETF	647.5999	648.58	647.36	648.235	4187483.0
2025-09-08 15:00:00	SPY	ETF	648.22	648.88	647.335	648.8	12968242.0
2025-09-08 16:00:00	SPY	ETF	648.8	648.99	648.5055	648.82	3079834.0
2025-09-08 17:00:00	SPY	ETF	648.77	649.04	648.73	649.0	103295.0
2025-09-08 18:00:00	SPY	ETF	648.94	649.47	648.88	649.45	57331.0
2025-09-08 19:00:00	SPY	ETF	649.45	649.55	649.109	649.15	29526.0
2025-09-08 04:00:00	QQQ	ETF	577.6	578.0	577.38	577.91	25814.0
2025-09-08 05:00:00	QQQ	ETF	577.9	578.38	577.67	578.26	31006.0
2025-09-08 06:00:00	QQQ	ETF	578.32	578.53	578.03	578.13	42709.0
2025-09-08 07:00:00	QQQ	ETF	578.07	578.3	577.86	577.87	42520.0
2025-09-08 08:00:00	QQQ	ETF	578.06	578.39	575.628	578.16	174444.0
2025-09-08 09:00:00	QQQ	ETF	578.25	580.56	578.04	579.84	6291186.0
2025-09-08 10:00:00	QQQ	ETF	579.84	580.84	578.87	580.16	6029975.0
2025-09-08 11:00:00	QQQ	ETF	580.15	580.74	579.46	580.49	3897227.0
2025-09-08 12:00:00	QQQ	ETF	580.49	580.5	578.5	579.0199	3502245.0
2025-09-08 13:00:00	QQQ	ETF	579.01	579.15	577.84	578.32	2991657.0
2025-09-08 14:00:00	QQQ	ETF	578.33	579.21	578.08	578.585	2591585.0
2025-09-08 15:00:00	QQQ	ETF	578.58	579.02	577.77	578.82	6235717.0
2025-09-08 16:00:00	QQQ	ETF	578.84	578.9701	578.56	578.7	1113629.0
2025-09-08 17:00:00	QQQ	ETF	578.67	579.0	578.55	579.0	29471.0
2025-09-08 18:00:00	QQQ	ETF	578.78	579.41	578.78	579.33	50877.0
2025-09-08 19:00:00	QQQ	ETF	579.33	579.459	578.85	578.92	25316.0
2025-09-08 04:00:00	IWM	ETF	237.95	238.14	237.93	237.96	17328.0
2025-09-08 05:00:00	IWM	ETF	237.99	238.04	237.85	238.04	12213.0
2025-09-08 06:00:00	IWM	ETF	237.99	238.48	237.97	238.3	44845.0
2025-09-08 07:00:00	IWM	ETF	238.29	238.45	238.1	238.26	17168.0
2025-09-08 08:00:00	IWM	ETF	238.43	238.56	237.75	238.49	77499.0
2025-09-08 09:00:00	IWM	ETF	238.49	238.81	236.625	236.955	4397090.0
2025-09-08 10:00:00	IWM	ETF	236.95	237.93	236.39	237.86	4108684.0
2025-09-08 11:00:00	IWM	ETF	237.87	238.2074	237.27	237.625	2978569.0
2025-09-08 12:00:00	IWM	ETF	237.62	237.71	237.225	237.541	2200975.0
2025-09-08 13:00:00	IWM	ETF	237.54	237.965	237.19	237.28	2362844.0
2025-09-08 14:00:00	IWM	ETF	237.28	238.33	237.24	238.2459	2550933.0
2025-09-08 15:00:00	IWM	ETF	238.24	238.275	237.6174	238.26	5150569.0
2025-09-08 16:00:00	IWM	ETF	238.25	238.36	238.2	238.28	851627.0
2025-09-08 17:00:00	IWM	ETF	238.33	238.34	237.98	238.01	20371.0
2025-09-08 18:00:00	IWM	ETF	238.17	238.57	238.17	238.52	17124.0
2025-09-08 19:00:00	IWM	ETF	238.56	238.57	238.39	238.42	5416.0
2025-09-08 04:00:00	DIA	ETF	455.68	455.82	455.68	455.82	200.0
2025-09-08 05:00:00	DIA	ETF	455.75	455.75	455.55	455.55	700.0

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

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