PREVIEW / etf_1hour / 2026-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-26.parquet
  size:    715 KB
  rows:    28,387

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-26 04:00:00	SPY	ETF	765.36	765.87	764.87	765.44	32614.0
2026-08-26 05:00:00	SPY	ETF	765.64	765.69	765.11	765.69	9286.0
2026-08-26 06:00:00	SPY	ETF	765.56	765.74	765.02	765.46	13755.0
2026-08-26 07:00:00	SPY	ETF	765.451	766.18	765.1	765.55	113189.0
2026-08-26 08:00:00	SPY	ETF	765.53	766.43	764.47	764.76	218130.0
2026-08-26 09:00:00	SPY	ETF	764.74	766.8999	764.51	766.89	2309984.0
2026-08-26 10:00:00	SPY	ETF	766.88	766.96	764.83	765.85	2515271.0
2026-08-26 11:00:00	SPY	ETF	765.87	766.47	765.14	765.32	2427523.0
2026-08-26 12:00:00	SPY	ETF	765.33	765.44	763.93	764.72	2390035.0
2026-08-26 13:00:00	SPY	ETF	764.7	765.87	764.5702	765.68	1840596.0
2026-08-26 14:00:00	SPY	ETF	765.67	766.64	765.35	766.51	2699873.0
2026-08-26 15:00:00	SPY	ETF	766.53	767.35	765.49	766.01	5899604.0
2026-08-26 16:00:00	SPY	ETF	765.95	767.69	765.81	767.69	2250369.0
2026-08-26 17:00:00	SPY	ETF	767.72	770.4	767.51	769.97	681411.0
2026-08-26 18:00:00	SPY	ETF	769.98	770.86	768.83	770.4115	389361.0
2026-08-26 19:00:00	SPY	ETF	770.41	770.67	770.11	770.67	57285.0
2026-08-26 04:00:00	QQQ	ETF	709.22	710.96	708.7	709.46	147218.0
2026-08-26 05:00:00	QQQ	ETF	709.7	709.81	708.85	709.8	18702.0
2026-08-26 06:00:00	QQQ	ETF	709.7	710.0	708.78	709.92	44700.0
2026-08-26 07:00:00	QQQ	ETF	709.9	710.9	708.7	709.5	116712.0
2026-08-26 08:00:00	QQQ	ETF	709.48	710.47	707.41	707.91	331961.0
2026-08-26 09:00:00	QQQ	ETF	707.81	712.2	707.43	712.16	2222117.0
2026-08-26 10:00:00	QQQ	ETF	712.16	712.18	707.97	710.3	2424363.0
2026-08-26 11:00:00	QQQ	ETF	710.32	711.2196	709.405	709.44	1645762.0
2026-08-26 12:00:00	QQQ	ETF	709.43	709.62	708.29	709.3999	1347261.0
2026-08-26 13:00:00	QQQ	ETF	709.39	711.24	709.26	711.01	1368533.0
2026-08-26 14:00:00	QQQ	ETF	711.02	712.08	710.56	711.89	1315457.0
2026-08-26 15:00:00	QQQ	ETF	711.875	713.02	710.885	711.29	2689463.0
2026-08-26 16:00:00	QQQ	ETF	711.32	714.55	711.05	714.5	1096617.0
2026-08-26 17:00:00	QQQ	ETF	714.4789	718.0	713.85	717.02	1050912.0
2026-08-26 18:00:00	QQQ	ETF	716.99	719.27	716.0	718.74	577969.0
2026-08-26 19:00:00	QQQ	ETF	718.68	719.83	718.2315	719.7676	95617.0
2026-08-26 04:00:00	IWM	ETF	299.34	299.62	299.06	299.16	9833.0
2026-08-26 05:00:00	IWM	ETF	299.36	299.43	299.08	299.21	4603.0
2026-08-26 06:00:00	IWM	ETF	299.19	299.27	298.92	299.1	8984.0
2026-08-26 07:00:00	IWM	ETF	299.08	299.3396	299.07	299.22	16707.0
2026-08-26 08:00:00	IWM	ETF	299.12	299.65	298.32	298.49	144938.0
2026-08-26 09:00:00	IWM	ETF	298.47	299.82	298.13	299.67	1688734.0
2026-08-26 10:00:00	IWM	ETF	299.67	299.95	298.5399	298.66	1324695.0
2026-08-26 11:00:00	IWM	ETF	298.66	298.835	298.27	298.58	853987.0
2026-08-26 12:00:00	IWM	ETF	298.585	298.655	298.235	298.6	957344.0
2026-08-26 13:00:00	IWM	ETF	298.605	298.94	298.51	298.885	609387.0
2026-08-26 14:00:00	IWM	ETF	298.89	299.16	298.83	299.12	609762.0
2026-08-26 15:00:00	IWM	ETF	299.11	299.42	298.79	298.92	1784375.0
2026-08-26 16:00:00	IWM	ETF	298.95	299.24	298.93	299.21	533370.0
2026-08-26 17:00:00	IWM	ETF	299.22	299.49	299.01	299.11	41515.0
2026-08-26 18:00:00	IWM	ETF	299.28	299.86	298.95	299.67	50098.0
2026-08-26 19:00:00	IWM	ETF	299.72	299.72	299.43	299.675	5493.0
2026-08-26 04:00:00	DIA	ETF	535.34	535.8	535.34	535.8	2320.0
2026-08-26 05:00:00	DIA	ETF	536.0	536.0	535.82	535.82	265.0

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

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