PREVIEW / etf_1hour / 2026-08-24

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-24.parquet
  size:    723 KB
  rows:    28,757

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
2026-08-24 04:00:00	SPY	ETF	764.0	767.15	763.48	764.72	313766.0
2026-08-24 05:00:00	SPY	ETF	764.61	764.99	764.42	764.62	12128.0
2026-08-24 06:00:00	SPY	ETF	764.65	764.73	763.54	763.65	21496.0
2026-08-24 07:00:00	SPY	ETF	763.639	765.22	763.07	764.55	182210.0
2026-08-24 08:00:00	SPY	ETF	764.53	764.77	763.53	764.47	269759.0
2026-08-24 09:00:00	SPY	ETF	764.4	764.81	762.08	763.39	3463634.0
2026-08-24 10:00:00	SPY	ETF	763.41	764.11	762.5	763.64	3025817.0
2026-08-24 11:00:00	SPY	ETF	763.64	764.73	762.37	764.5201	2944523.0
2026-08-24 12:00:00	SPY	ETF	764.52	765.22	764.12	764.19	2047505.0
2026-08-24 13:00:00	SPY	ETF	764.2	764.78	763.05	763.29	2114735.0
2026-08-24 14:00:00	SPY	ETF	763.31	765.11	763.28	764.0	2478021.0
2026-08-24 15:00:00	SPY	ETF	763.97	764.24	763.35	763.46	4531735.0
2026-08-24 16:00:00	SPY	ETF	763.48	764.1	763.25	764.09	1957376.0
2026-08-24 17:00:00	SPY	ETF	764.0	764.1	763.9	764.0	30495.0
2026-08-24 18:00:00	SPY	ETF	764.08	764.27	763.47	763.96	370387.0
2026-08-24 19:00:00	SPY	ETF	764.04	764.1	763.35	763.6496	39859.0
2026-08-24 04:00:00	QQQ	ETF	707.35	711.26	706.82	709.27	258478.0
2026-08-24 05:00:00	QQQ	ETF	709.13	709.93	708.85	709.5	31369.0
2026-08-24 06:00:00	QQQ	ETF	709.53	709.86	708.3151	708.44	95657.0
2026-08-24 07:00:00	QQQ	ETF	708.449	710.8	707.5	709.8231	236010.0
2026-08-24 08:00:00	QQQ	ETF	709.86	712.905	708.15	708.97	280615.0
2026-08-24 09:00:00	QQQ	ETF	709.01	709.79	702.7	704.48	4352744.0
2026-08-24 10:00:00	QQQ	ETF	704.465	706.545	702.83	705.93	4238230.0
2026-08-24 11:00:00	QQQ	ETF	705.93	708.8438	704.82	707.99	4116570.0
2026-08-24 12:00:00	QQQ	ETF	707.9801	709.3359	707.71	708.025	2337193.0
2026-08-24 13:00:00	QQQ	ETF	708.03	708.98	706.73	706.9	2780626.0
2026-08-24 14:00:00	QQQ	ETF	706.91	709.53	706.886	707.62	2410046.0
2026-08-24 15:00:00	QQQ	ETF	707.62	708.06	706.19	706.28	4970116.0
2026-08-24 16:00:00	QQQ	ETF	706.31	707.1	705.88	707.07	1670515.0
2026-08-24 17:00:00	QQQ	ETF	706.93	707.1	706.6341	707.07	54170.0
2026-08-24 18:00:00	QQQ	ETF	707.08	707.48	706.66	706.66	41264.0
2026-08-24 19:00:00	QQQ	ETF	706.81	706.96	705.73	706.19	72640.0
2026-08-24 04:00:00	IWM	ETF	299.55	300.11	299.55	299.94	41014.0
2026-08-24 05:00:00	IWM	ETF	299.87	299.99	299.77	299.8	4870.0
2026-08-24 06:00:00	IWM	ETF	299.85	299.9	299.32	299.32	10859.0
2026-08-24 07:00:00	IWM	ETF	299.4183	300.2	299.14	299.93	71307.0
2026-08-24 08:00:00	IWM	ETF	299.91	299.91	299.13	299.71	209094.0
2026-08-24 09:00:00	IWM	ETF	299.75	299.8	298.17	298.595	1523438.0
2026-08-24 10:00:00	IWM	ETF	298.59	299.01	298.045	298.585	1125679.0
2026-08-24 11:00:00	IWM	ETF	298.58	298.81	298.19	298.47	1390290.0
2026-08-24 12:00:00	IWM	ETF	298.465	298.78	297.97	298.015	816675.0
2026-08-24 13:00:00	IWM	ETF	298.015	298.525	297.4	297.59	1194698.0
2026-08-24 14:00:00	IWM	ETF	297.59	298.34	297.545	298.06	875875.0
2026-08-24 15:00:00	IWM	ETF	298.03	298.205	297.83	297.96	1695064.0
2026-08-24 16:00:00	IWM	ETF	297.97	298.3	297.885	298.22	700433.0
2026-08-24 17:00:00	IWM	ETF	298.27	298.28	298.09	298.2	16171.0
2026-08-24 18:00:00	IWM	ETF	298.2	298.33	298.13	298.18	22056.0
2026-08-24 19:00:00	IWM	ETF	298.19	298.2	297.81	297.94	11769.0
2026-08-24 04:00:00	DIA	ETF	531.88	532.08	531.79	532.08	3051.0
2026-08-24 05:00:00	DIA	ETF	532.23	532.23	532.23	532.23	50.0

> showing 50 of 28,757 rows — these rows as CSV

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