PREVIEW / etf_1hour / 2026-09-02

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-09-02.parquet
  size:    714 KB
  rows:    28,413

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-09-02 04:00:00	SPY	ETF	761.09	762.05	759.72	760.0	45083.0
2026-09-02 05:00:00	SPY	ETF	760.05	760.61	759.55	759.92	19580.0
2026-09-02 06:00:00	SPY	ETF	759.9572	760.22	759.52	759.83	34849.0
2026-09-02 07:00:00	SPY	ETF	760.021	761.97	759.27	761.97	218117.0
2026-09-02 08:00:00	SPY	ETF	761.96	763.26	761.35	761.36	219953.0
2026-09-02 09:00:00	SPY	ETF	761.38	763.065	761.38	763.065	2608844.0
2026-09-02 10:00:00	SPY	ETF	763.03	766.34	762.86	765.31	4047355.0
2026-09-02 11:00:00	SPY	ETF	765.31	766.43	764.97	765.925	2219612.0
2026-09-02 12:00:00	SPY	ETF	765.92	765.92	764.69	764.92	1259768.0
2026-09-02 13:00:00	SPY	ETF	764.92	765.48	764.35	765.18	1545533.0
2026-09-02 14:00:00	SPY	ETF	765.18	766.0899	764.59	764.81	2919348.0
2026-09-02 15:00:00	SPY	ETF	764.79	765.52	764.67	765.14	4638099.0
2026-09-02 16:00:00	SPY	ETF	765.18	765.58	764.0	764.29	1941426.0
2026-09-02 17:00:00	SPY	ETF	764.35	765.2	764.18	764.76	173316.0
2026-09-02 18:00:00	SPY	ETF	764.75	765.29	764.52	764.96	61702.0
2026-09-02 19:00:00	SPY	ETF	765.01	765.45	764.8	765.37	68334.0
2026-09-02 04:00:00	QQQ	ETF	706.18	707.53	703.61	704.02	212034.0
2026-09-02 05:00:00	QQQ	ETF	704.2	705.3	703.28	704.05	82840.0
2026-09-02 06:00:00	QQQ	ETF	703.9886	704.54	703.41	704.28	89919.0
2026-09-02 07:00:00	QQQ	ETF	704.38	706.71	702.96	706.71	332804.0
2026-09-02 08:00:00	QQQ	ETF	706.7	708.25	705.5	705.66	287160.0
2026-09-02 09:00:00	QQQ	ETF	705.73	707.54	705.1	706.18	2914761.0
2026-09-02 10:00:00	QQQ	ETF	706.19	709.7988	705.49	707.6	3346163.0
2026-09-02 11:00:00	QQQ	ETF	707.59	709.74	707.2975	709.195	1771634.0
2026-09-02 12:00:00	QQQ	ETF	709.2	709.48	707.98	708.42	1126445.0
2026-09-02 13:00:00	QQQ	ETF	708.45	709.09	707.72	708.54	1541020.0
2026-09-02 14:00:00	QQQ	ETF	708.54	709.5	707.85	708.21	1203063.0
2026-09-02 15:00:00	QQQ	ETF	708.225	709.44	708.07	709.25	2389070.0
2026-09-02 16:00:00	QQQ	ETF	709.31	709.77	707.6	708.16	843732.0
2026-09-02 17:00:00	QQQ	ETF	708.33	709.44	707.92	708.9787	175935.0
2026-09-02 18:00:00	QQQ	ETF	708.97	709.69	708.32	709.0599	66652.0
2026-09-02 19:00:00	QQQ	ETF	709.18	709.81	708.74	709.6	62946.0
2026-09-02 04:00:00	IWM	ETF	290.71	291.12	289.99	290.07	19037.0
2026-09-02 05:00:00	IWM	ETF	290.17	290.45	289.85	290.04	23543.0
2026-09-02 06:00:00	IWM	ETF	289.97	290.05	289.74	289.85	23857.0
2026-09-02 07:00:00	IWM	ETF	289.86	291.1	289.58	291.1	156095.0
2026-09-02 08:00:00	IWM	ETF	291.02	291.62	290.6	290.66	238398.0
2026-09-02 09:00:00	IWM	ETF	290.66	292.74	290.66	292.35	2908485.0
2026-09-02 10:00:00	IWM	ETF	292.35	293.775	292.26	293.15	2670960.0
2026-09-02 11:00:00	IWM	ETF	293.16	293.18	292.49	293.15	1614299.0
2026-09-02 12:00:00	IWM	ETF	293.15	293.22	292.865	293.165	711270.0
2026-09-02 13:00:00	IWM	ETF	293.165	293.63	293.08	293.565	1203020.0
2026-09-02 14:00:00	IWM	ETF	293.57	294.09	293.38	293.98	1525659.0
2026-09-02 15:00:00	IWM	ETF	293.98	294.35	293.72	294.01	4521093.0
2026-09-02 16:00:00	IWM	ETF	294.03	294.27	293.7251	293.91	1829201.0
2026-09-02 17:00:00	IWM	ETF	294.05	294.18	293.7	294.11	27882.0
2026-09-02 18:00:00	IWM	ETF	294.01	294.01	293.65	293.97	49077.0
2026-09-02 19:00:00	IWM	ETF	294.0	294.13	293.89	294.05	7362.0
2026-09-02 04:00:00	DIA	ETF	527.84	527.84	527.05	527.05	484.0
2026-09-02 05:00:00	DIA	ETF	527.29	527.29	526.84	526.84	1580.0

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

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