PREVIEW / etf_1hour / 2026-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-04.parquet
  size:    745 KB
  rows:    29,425

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-04 04:00:00	SPY	ETF	759.21	759.88	758.45	758.64	53950.0
2026-08-04 05:00:00	SPY	ETF	758.58	758.75	758.11	758.64	58176.0
2026-08-04 06:00:00	SPY	ETF	758.64	759.68	758.47	759.25	70357.0
2026-08-04 07:00:00	SPY	ETF	759.19	760.64	759.1	760.29	296063.0
2026-08-04 08:00:00	SPY	ETF	760.33	761.0	760.0	760.05	187792.0
2026-08-04 09:00:00	SPY	ETF	760.02	763.48	759.86	763.39	5165882.0
2026-08-04 10:00:00	SPY	ETF	763.37	766.42	763.09	766.3	7237696.0
2026-08-04 11:00:00	SPY	ETF	766.33	768.9	766.17	768.44	5669089.0
2026-08-04 12:00:00	SPY	ETF	768.445	770.32	768.14	770.265	4582008.0
2026-08-04 13:00:00	SPY	ETF	770.27	773.085	770.165	771.57	5818136.0
2026-08-04 14:00:00	SPY	ETF	771.57	772.4798	771.08	772.07	5127243.0
2026-08-04 15:00:00	SPY	ETF	772.085	773.41	770.96	771.25	12127111.0
2026-08-04 16:00:00	SPY	ETF	771.24	772.96	771.0	772.27	3639324.0
2026-08-04 17:00:00	SPY	ETF	772.0779	772.28	771.93	772.12	189741.0
2026-08-04 18:00:00	SPY	ETF	772.14	773.0	771.92	772.8	82892.0
2026-08-04 19:00:00	SPY	ETF	772.84	773.03	772.39	772.68	46669.0
2026-08-04 04:00:00	QQQ	ETF	703.78	705.7	701.81	704.16	232369.0
2026-08-04 05:00:00	QQQ	ETF	704.02	704.58	702.72	704.35	79567.0
2026-08-04 06:00:00	QQQ	ETF	704.21	706.01	704.21	705.28	152167.0
2026-08-04 07:00:00	QQQ	ETF	705.3	708.39	705.2812	708.24	308256.0
2026-08-04 08:00:00	QQQ	ETF	708.21	708.22	699.545	707.49	486741.0
2026-08-04 09:00:00	QQQ	ETF	707.49	714.66	707.16	713.65	5579351.0
2026-08-04 10:00:00	QQQ	ETF	713.64	716.4	712.98	715.8008	5764409.0
2026-08-04 11:00:00	QQQ	ETF	715.85	719.4	715.74	718.8	5981551.0
2026-08-04 12:00:00	QQQ	ETF	718.785	720.6	718.56	720.57	4631174.0
2026-08-04 13:00:00	QQQ	ETF	720.57	724.28	720.48	722.73	4783118.0
2026-08-04 14:00:00	QQQ	ETF	722.73	724.2	722.12	723.85	2574833.0
2026-08-04 15:00:00	QQQ	ETF	723.86	725.66	723.05	723.68	6143404.0
2026-08-04 16:00:00	QQQ	ETF	723.69	725.5	712.8416	722.35	3208488.0
2026-08-04 17:00:00	QQQ	ETF	722.25	723.0	721.22	721.4173	165655.0
2026-08-04 18:00:00	QQQ	ETF	721.42	722.85	721.39	722.43	123352.0
2026-08-04 19:00:00	QQQ	ETF	722.48	723.18	721.98	722.77	91772.0
2026-08-04 04:00:00	IWM	ETF	297.01	297.28	296.34	296.53	45607.0
2026-08-04 05:00:00	IWM	ETF	296.57	296.57	295.89	296.09	44920.0
2026-08-04 06:00:00	IWM	ETF	296.1	296.8672	295.94	296.61	30766.0
2026-08-04 07:00:00	IWM	ETF	296.6	298.2	296.41	297.89	213822.0
2026-08-04 08:00:00	IWM	ETF	297.99	298.2	297.55	297.73	101939.0
2026-08-04 09:00:00	IWM	ETF	297.7	298.555	297.22	298.19	2026205.0
2026-08-04 10:00:00	IWM	ETF	298.225	299.63	298.07	299.48	2016377.0
2026-08-04 11:00:00	IWM	ETF	299.48	300.86	299.44	300.59	2028410.0
2026-08-04 12:00:00	IWM	ETF	300.58	301.65	300.475	301.65	1704660.0
2026-08-04 13:00:00	IWM	ETF	301.645	302.19	301.51	301.805	1488393.0
2026-08-04 14:00:00	IWM	ETF	301.8	302.08	301.53	301.75	1572380.0
2026-08-04 15:00:00	IWM	ETF	301.77	302.39	301.57	301.68	3804504.0
2026-08-04 16:00:00	IWM	ETF	301.7	302.15	301.69	302.06	665822.0
2026-08-04 17:00:00	IWM	ETF	302.01	302.39	301.68	302.34	45757.0
2026-08-04 18:00:00	IWM	ETF	302.23	302.5303	302.1	302.43	49718.0
2026-08-04 19:00:00	IWM	ETF	302.41	302.46	302.23	302.34	9390.0
2026-08-04 04:00:00	DIA	ETF	532.12	532.48	531.48	531.48	6821.0
2026-08-04 05:00:00	DIA	ETF	531.81	532.09	531.65	531.82	5568.0

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

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