PREVIEW / etf_1hour / 2026-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-07.parquet
  size:    716 KB
  rows:    28,248

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-07 04:00:00	SPY	ETF	768.46	769.94	767.88	769.82	187735.0
2026-08-07 05:00:00	SPY	ETF	769.82	770.16	769.73	769.85	18542.0
2026-08-07 06:00:00	SPY	ETF	769.8443	770.16	769.68	769.92	41766.0
2026-08-07 07:00:00	SPY	ETF	769.94	771.0	769.9262	770.16	103909.0
2026-08-07 08:00:00	SPY	ETF	770.15	773.11	768.35	772.67	719743.0
2026-08-07 09:00:00	SPY	ETF	772.7	772.78	770.46	771.0403	3744729.0
2026-08-07 10:00:00	SPY	ETF	771.07	773.35	769.61	772.88	4443058.0
2026-08-07 11:00:00	SPY	ETF	772.88	773.915	772.37	773.03	3259151.0
2026-08-07 12:00:00	SPY	ETF	773.04	773.38	771.0615	771.965	2881198.0
2026-08-07 13:00:00	SPY	ETF	771.9601	772.46	771.73	772.17	1814621.0
2026-08-07 14:00:00	SPY	ETF	772.165	772.285	770.89	771.71	2475607.0
2026-08-07 15:00:00	SPY	ETF	771.68	773.83	771.66	773.2	7120207.0
2026-08-07 16:00:00	SPY	ETF	773.16	773.4	772.55	773.12	3664771.0
2026-08-07 17:00:00	SPY	ETF	773.08	773.08	772.92	772.98	54045.0
2026-08-07 18:00:00	SPY	ETF	772.95	773.2116	772.84	772.84	13175.0
2026-08-07 19:00:00	SPY	ETF	772.89	773.4	772.8	773.375	14357.0
2026-08-07 04:00:00	QQQ	ETF	717.11	718.525	714.0	718.3	160279.0
2026-08-07 05:00:00	QQQ	ETF	718.3	718.58	717.83	717.8304	37037.0
2026-08-07 06:00:00	QQQ	ETF	717.92	718.1	717.23	717.61	32730.0
2026-08-07 07:00:00	QQQ	ETF	717.62	719.1	717.62	717.83	157590.0
2026-08-07 08:00:00	QQQ	ETF	717.72	723.85	716.21	723.3	917773.0
2026-08-07 09:00:00	QQQ	ETF	723.3	723.43	718.46	719.31	3607383.0
2026-08-07 10:00:00	QQQ	ETF	719.32	721.65	716.51	720.27	4828445.0
2026-08-07 11:00:00	QQQ	ETF	720.27	723.4999	720.02	722.5	3764212.0
2026-08-07 12:00:00	QQQ	ETF	722.53	722.91	719.05	720.7	2724478.0
2026-08-07 13:00:00	QQQ	ETF	720.68	721.38	720.38	720.8	1462195.0
2026-08-07 14:00:00	QQQ	ETF	720.795	721.07	719.22	720.38	1741293.0
2026-08-07 15:00:00	QQQ	ETF	720.37	723.63	720.34	722.98	4664551.0
2026-08-07 16:00:00	QQQ	ETF	722.95	723.38	722.25	723.0205	1247532.0
2026-08-07 17:00:00	QQQ	ETF	722.8	723.11	722.62	722.9386	53987.0
2026-08-07 18:00:00	QQQ	ETF	722.85	722.97	722.71	722.73	12475.0
2026-08-07 19:00:00	QQQ	ETF	722.81	723.3997	722.55	723.23	28455.0
2026-08-07 04:00:00	IWM	ETF	297.85	298.79	297.69	298.77	42986.0
2026-08-07 05:00:00	IWM	ETF	298.78	299.1	298.76	299.02	9402.0
2026-08-07 06:00:00	IWM	ETF	299.01	299.16	298.93	299.04	25880.0
2026-08-07 07:00:00	IWM	ETF	299.16	299.73	299.16	299.43	95716.0
2026-08-07 08:00:00	IWM	ETF	299.34	301.44	299.34	300.85	595971.0
2026-08-07 09:00:00	IWM	ETF	300.87	301.19	299.87	300.54	2442046.0
2026-08-07 10:00:00	IWM	ETF	300.57	301.31	299.795	300.505	1598709.0
2026-08-07 11:00:00	IWM	ETF	300.52	301.32	300.34	300.985	1629069.0
2026-08-07 12:00:00	IWM	ETF	300.985	301.382	300.45	301.1	1306868.0
2026-08-07 13:00:00	IWM	ETF	301.11	301.38	300.93	301.265	1109342.0
2026-08-07 14:00:00	IWM	ETF	301.275	301.3399	300.75	301.04	1145778.0
2026-08-07 15:00:00	IWM	ETF	301.04	302.03	301.03	301.53	4224188.0
2026-08-07 16:00:00	IWM	ETF	301.52	301.7	301.29	301.5	780528.0
2026-08-07 17:00:00	IWM	ETF	301.27	302.1	301.27	301.6578	28637.0
2026-08-07 18:00:00	IWM	ETF	301.71	301.88	301.56	301.73	15753.0
2026-08-07 19:00:00	IWM	ETF	301.66	302.0411	301.66	301.93	3844.0
2026-08-07 04:00:00	DIA	ETF	537.75	538.1	537.13	538.1	5298.0
2026-08-07 05:00:00	DIA	ETF	538.14	538.51	538.14	538.39	2245.0

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

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