PREVIEW / etf_1hour / 2026-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-03.parquet
  size:    734 KB
  rows:    29,193

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-03 04:00:00	SPY	ETF	750.07	751.5	749.65	750.74	130569.0
2026-08-03 05:00:00	SPY	ETF	750.8224	750.87	750.25	750.58	29142.0
2026-08-03 06:00:00	SPY	ETF	750.6	751.14	750.48	751.12	57883.0
2026-08-03 07:00:00	SPY	ETF	751.111	751.55	750.44	750.6	249741.0
2026-08-03 08:00:00	SPY	ETF	750.58	751.45	750.2	751.15	387399.0
2026-08-03 09:00:00	SPY	ETF	751.14	753.6386	748.8	753.62	5961937.0
2026-08-03 10:00:00	SPY	ETF	753.6	755.4055	753.0	755.3701	7221128.0
2026-08-03 11:00:00	SPY	ETF	755.38	756.21	754.79	755.955	5295878.0
2026-08-03 12:00:00	SPY	ETF	755.96	756.62	755.76	756.22	3607253.0
2026-08-03 13:00:00	SPY	ETF	756.22	757.78	755.98	757.6451	3915856.0
2026-08-03 14:00:00	SPY	ETF	757.645	758.33	757.34	757.935	4470087.0
2026-08-03 15:00:00	SPY	ETF	757.94	758.58	757.43	757.67	9720065.0
2026-08-03 16:00:00	SPY	ETF	757.63	758.5	757.36	758.01	2078410.0
2026-08-03 17:00:00	SPY	ETF	758.04	758.17	757.8	757.95	35200.0
2026-08-03 18:00:00	SPY	ETF	757.81	758.49	757.81	758.34	33568.0
2026-08-03 19:00:00	SPY	ETF	758.36	758.41	758.11	758.33	64137.0
2026-08-03 04:00:00	QQQ	ETF	692.23	694.78	689.63	692.56	237112.0
2026-08-03 05:00:00	QQQ	ETF	692.71	692.71	690.89	691.8	81499.0
2026-08-03 06:00:00	QQQ	ETF	691.77	691.83	690.09	691.28	127487.0
2026-08-03 07:00:00	QQQ	ETF	691.3	691.47	687.98	688.4	276930.0
2026-08-03 08:00:00	QQQ	ETF	688.28	694.54	687.475	689.45	319188.0
2026-08-03 09:00:00	QQQ	ETF	689.45	693.4	685.82	693.305	4395119.0
2026-08-03 10:00:00	QQQ	ETF	693.29	697.7	691.08	697.585	6152434.0
2026-08-03 11:00:00	QQQ	ETF	697.59	697.87	695.66	697.38	3279132.0
2026-08-03 12:00:00	QQQ	ETF	697.44	698.7	697.3426	698.07	2653375.0
2026-08-03 13:00:00	QQQ	ETF	698.1	700.56	697.89	700.46	3058998.0
2026-08-03 14:00:00	QQQ	ETF	700.46	701.59	699.61	700.2372	3022553.0
2026-08-03 15:00:00	QQQ	ETF	700.23	701.11	699.27	700.06	5888210.0
2026-08-03 16:00:00	QQQ	ETF	700.06	701.01	699.5	700.7	2041992.0
2026-08-03 17:00:00	QQQ	ETF	700.75	700.8489	700.2	700.52	79676.0
2026-08-03 18:00:00	QQQ	ETF	700.77	701.55	700.58	701.2	96853.0
2026-08-03 19:00:00	QQQ	ETF	701.1302	701.8	700.87	701.8	73068.0
2026-08-03 04:00:00	IWM	ETF	291.9	293.4	291.9	293.12	43500.0
2026-08-03 05:00:00	IWM	ETF	293.08	293.25	292.75	293.09	17490.0
2026-08-03 06:00:00	IWM	ETF	293.0	293.49	292.9	293.31	33403.0
2026-08-03 07:00:00	IWM	ETF	293.3202	293.63	292.9704	293.1	85241.0
2026-08-03 08:00:00	IWM	ETF	293.01	294.04	292.82	293.9471	160434.0
2026-08-03 09:00:00	IWM	ETF	293.91	294.9	292.4	294.81	3269403.0
2026-08-03 10:00:00	IWM	ETF	294.78	296.15	294.63	295.955	3905607.0
2026-08-03 11:00:00	IWM	ETF	295.96	296.06	295.245	295.85	2141862.0
2026-08-03 12:00:00	IWM	ETF	295.85	296.01	295.055	295.225	1147736.0
2026-08-03 13:00:00	IWM	ETF	295.23	295.975	294.85	295.905	2131064.0
2026-08-03 14:00:00	IWM	ETF	295.905	296.31	295.68	295.72	1400702.0
2026-08-03 15:00:00	IWM	ETF	295.72	296.66	295.72	296.23	3269332.0
2026-08-03 16:00:00	IWM	ETF	296.22	296.7	296.1	296.51	1072014.0
2026-08-03 17:00:00	IWM	ETF	296.6	296.65	296.43	296.43	8981.0
2026-08-03 18:00:00	IWM	ETF	296.62	296.81	296.58	296.74	9134.0
2026-08-03 19:00:00	IWM	ETF	296.72	296.87	296.63	296.8	9066.0
2026-08-03 04:00:00	DIA	ETF	527.0	527.77	526.59	527.77	5402.0
2026-08-03 05:00:00	DIA	ETF	527.81	528.0	527.74	527.74	1999.0

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

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