PREVIEW / etf_1hour / 2026-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-31.parquet
  size:    719 KB
  rows:    28,719

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-31 04:00:00	SPY	ETF	768.78	768.82	766.3	768.52	50867.0
2026-08-31 05:00:00	SPY	ETF	768.42	768.7401	767.925	768.0	7359.0
2026-08-31 06:00:00	SPY	ETF	767.83	768.25	767.73	768.19	9477.0
2026-08-31 07:00:00	SPY	ETF	768.151	768.2798	767.24	767.43	81205.0
2026-08-31 08:00:00	SPY	ETF	767.41	768.11	766.34	766.54	337807.0
2026-08-31 09:00:00	SPY	ETF	766.55	767.62	765.5	766.18	3434921.0
2026-08-31 10:00:00	SPY	ETF	766.19	766.399	764.715	765.95	3156046.0
2026-08-31 11:00:00	SPY	ETF	765.95	766.46	765.31	765.4199	2226402.0
2026-08-31 12:00:00	SPY	ETF	765.42	765.98	764.98	765.84	2044783.0
2026-08-31 13:00:00	SPY	ETF	765.85	766.81	765.17	766.52	1698214.0
2026-08-31 14:00:00	SPY	ETF	766.5	766.84	765.05	765.67	2527843.0
2026-08-31 15:00:00	SPY	ETF	765.67	767.995	765.67	766.95	10831071.0
2026-08-31 16:00:00	SPY	ETF	766.95	767.66	766.785	767.31	3707238.0
2026-08-31 17:00:00	SPY	ETF	767.32	767.45	767.05	767.44	52127.0
2026-08-31 18:00:00	SPY	ETF	767.36	767.45	767.25	767.26	22800.0
2026-08-31 19:00:00	SPY	ETF	767.3	767.67	767.2768	767.51	20850.0
2026-08-31 04:00:00	QQQ	ETF	716.4	717.51	712.7	716.24	181536.0
2026-08-31 05:00:00	QQQ	ETF	716.31	716.86	715.375	715.45	27394.0
2026-08-31 06:00:00	QQQ	ETF	715.48	715.955	715.24	715.66	92768.0
2026-08-31 07:00:00	QQQ	ETF	715.621	715.94	714.86	714.92	84219.0
2026-08-31 08:00:00	QQQ	ETF	714.93	716.23	713.7	713.9882	333010.0
2026-08-31 09:00:00	QQQ	ETF	714.0	717.001	713.7	715.23	2819240.0
2026-08-31 10:00:00	QQQ	ETF	715.2	715.42	713.16	714.6	2334247.0
2026-08-31 11:00:00	QQQ	ETF	714.61	715.31	713.85	713.955	1484587.0
2026-08-31 12:00:00	QQQ	ETF	713.97	715.28	713.36	715.21	1984246.0
2026-08-31 13:00:00	QQQ	ETF	715.2	715.62	713.99	715.235	1522528.0
2026-08-31 14:00:00	QQQ	ETF	715.15	715.75	713.82	714.35	1231367.0
2026-08-31 15:00:00	QQQ	ETF	714.357	717.58	714.31	716.82	3549163.0
2026-08-31 16:00:00	QQQ	ETF	716.85	717.27	716.76	717.09	1098658.0
2026-08-31 17:00:00	QQQ	ETF	717.05	717.09	716.88	717.0	31535.0
2026-08-31 18:00:00	QQQ	ETF	716.99	717.1	716.45	716.53	53598.0
2026-08-31 19:00:00	QQQ	ETF	716.48	717.04	716.34	716.7	45074.0
2026-08-31 04:00:00	IWM	ETF	294.94	296.21	294.84	296.0915	34093.0
2026-08-31 05:00:00	IWM	ETF	296.09	296.26	295.82	295.82	17586.0
2026-08-31 06:00:00	IWM	ETF	295.82	295.82	295.46	295.68	17327.0
2026-08-31 07:00:00	IWM	ETF	295.6598	295.83	295.31	295.54	57239.0
2026-08-31 08:00:00	IWM	ETF	295.6	295.76	294.53	294.68	283060.0
2026-08-31 09:00:00	IWM	ETF	294.65	295.35	293.375	293.445	2638047.0
2026-08-31 10:00:00	IWM	ETF	293.445	293.67	293.0	293.28	2517700.0
2026-08-31 11:00:00	IWM	ETF	293.28	293.6	292.8912	293.17	1208990.0
2026-08-31 12:00:00	IWM	ETF	293.16	293.34	292.92	293.06	921334.0
2026-08-31 13:00:00	IWM	ETF	293.06	293.255	292.705	293.17	2298253.0
2026-08-31 14:00:00	IWM	ETF	293.17	293.29	292.89	293.18	1014978.0
2026-08-31 15:00:00	IWM	ETF	293.2	294.34	293.16	293.91	3383743.0
2026-08-31 16:00:00	IWM	ETF	293.9	294.22	293.9	294.0	1759875.0
2026-08-31 17:00:00	IWM	ETF	294.03	294.05	293.8994	294.02	34361.0
2026-08-31 18:00:00	IWM	ETF	293.97	294.0	293.88	293.9	16596.0
2026-08-31 19:00:00	IWM	ETF	293.9	294.1	293.9	293.951	11352.0
2026-08-31 04:00:00	DIA	ETF	533.44	534.59	533.44	534.4211	1137.0
2026-08-31 05:00:00	DIA	ETF	534.6	534.6	534.3	534.3	684.0

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

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