PREVIEW / etf_1hour / 2026-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-20.parquet
  size:    729 KB
  rows:    29,007

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-20 04:00:00	SPY	ETF	769.05	770.63	767.7	768.07	67958.0
2026-08-20 05:00:00	SPY	ETF	767.98	768.805	767.98	768.52	8799.0
2026-08-20 06:00:00	SPY	ETF	768.32	769.17	768.32	769.17	32296.0
2026-08-20 07:00:00	SPY	ETF	769.16	769.42	766.45	766.46	212919.0
2026-08-20 08:00:00	SPY	ETF	766.5948	769.94	764.15	765.799	394339.0
2026-08-20 09:00:00	SPY	ETF	765.78	767.75	765.42	766.55	3665124.0
2026-08-20 10:00:00	SPY	ETF	766.5	767.48	765.36	767.15	3952160.0
2026-08-20 11:00:00	SPY	ETF	767.17	768.15	765.23	765.84	4361749.0
2026-08-20 12:00:00	SPY	ETF	765.84	766.64	765.36	766.42	2350180.0
2026-08-20 13:00:00	SPY	ETF	766.39	766.43	764.23	764.54	3006661.0
2026-08-20 14:00:00	SPY	ETF	764.55	764.55	763.15	763.24	4020027.0
2026-08-20 15:00:00	SPY	ETF	763.25	763.8	762.04	762.65	10536676.0
2026-08-20 16:00:00	SPY	ETF	762.64	763.01	761.99	762.97	2296619.0
2026-08-20 17:00:00	SPY	ETF	762.99	763.23	762.88	763.14	53122.0
2026-08-20 18:00:00	SPY	ETF	763.16	763.27	762.59	763.13	54393.0
2026-08-20 19:00:00	SPY	ETF	763.12	763.12	762.7	762.88	22964.0
2026-08-20 04:00:00	QQQ	ETF	718.44	720.15	714.6	714.99	241207.0
2026-08-20 05:00:00	QQQ	ETF	714.98	716.81	714.98	716.51	36892.0
2026-08-20 06:00:00	QQQ	ETF	716.35	717.23	716.0	717.23	76509.0
2026-08-20 07:00:00	QQQ	ETF	717.27	717.61	712.05	712.3	395227.0
2026-08-20 08:00:00	QQQ	ETF	712.3	714.9	709.435	711.97	1038255.0
2026-08-20 09:00:00	QQQ	ETF	711.92	714.94	711.07	712.19	3481355.0
2026-08-20 10:00:00	QQQ	ETF	712.1595	714.08	711.049	713.1095	3966181.0
2026-08-20 11:00:00	QQQ	ETF	713.09	714.66	710.1338	711.565	3795634.0
2026-08-20 12:00:00	QQQ	ETF	711.59	713.0	710.9237	712.7848	1713733.0
2026-08-20 13:00:00	QQQ	ETF	712.81	712.82	710.46	710.72	1779711.0
2026-08-20 14:00:00	QQQ	ETF	710.715	710.72	708.52	709.48	2378053.0
2026-08-20 15:00:00	QQQ	ETF	709.47	711.65	709.44	710.95	5178643.0
2026-08-20 16:00:00	QQQ	ETF	710.93	711.33	709.99	711.13	1411283.0
2026-08-20 17:00:00	QQQ	ETF	711.07	711.32	710.94	711.15	29842.0
2026-08-20 18:00:00	QQQ	ETF	711.23	711.89	710.28	711.37	87829.0
2026-08-20 19:00:00	QQQ	ETF	711.3267	711.47	710.6	710.66	47561.0
2026-08-20 04:00:00	IWM	ETF	301.81	302.56	301.01	301.11	32708.0
2026-08-20 05:00:00	IWM	ETF	301.0	301.37	300.97	301.27	14184.0
2026-08-20 06:00:00	IWM	ETF	301.31	301.51	301.18	301.32	13573.0
2026-08-20 07:00:00	IWM	ETF	301.4696	301.55	300.03	300.11	139607.0
2026-08-20 08:00:00	IWM	ETF	300.12	300.13	299.1	299.49	238627.0
2026-08-20 09:00:00	IWM	ETF	299.53	300.04	298.92	299.0	2472064.0
2026-08-20 10:00:00	IWM	ETF	299.0	299.13	297.92	298.92	4009025.0
2026-08-20 11:00:00	IWM	ETF	298.915	299.68	297.66	298.03	2128320.0
2026-08-20 12:00:00	IWM	ETF	298.03	298.255	297.705	298.21	1153484.0
2026-08-20 13:00:00	IWM	ETF	298.21	298.21	297.37	297.635	1253311.0
2026-08-20 14:00:00	IWM	ETF	297.64	297.64	297.04	297.265	1199628.0
2026-08-20 15:00:00	IWM	ETF	297.255	297.9	297.235	297.68	3128972.0
2026-08-20 16:00:00	IWM	ETF	297.7	297.81	297.41	297.53	768203.0
2026-08-20 17:00:00	IWM	ETF	297.47	297.7999	297.47	297.75	23201.0
2026-08-20 18:00:00	IWM	ETF	297.75	297.97	297.49	297.97	55020.0
2026-08-20 19:00:00	IWM	ETF	297.95	297.97	297.5	297.76	24758.0
2026-08-20 04:00:00	DIA	ETF	533.8	534.74	533.12	533.12	6075.0
2026-08-20 05:00:00	DIA	ETF	533.47	533.52	533.38	533.43	681.0

> showing 50 of 29,007 rows — these rows as CSV

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