PREVIEW / etf_1hour / 2026-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-18.parquet
  size:    724 KB
  rows:    28,919

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-18 04:00:00	SPY	ETF	769.21	770.42	767.8	768.95	135064.0
2026-08-18 05:00:00	SPY	ETF	768.8	769.14	768.285	768.99	29294.0
2026-08-18 06:00:00	SPY	ETF	768.96	769.4088	768.2499	769.15	135210.0
2026-08-18 07:00:00	SPY	ETF	769.18	769.85	769.14	769.51	212586.0
2026-08-18 08:00:00	SPY	ETF	769.49	769.88	768.9	769.55	254044.0
2026-08-18 09:00:00	SPY	ETF	769.6	769.65	767.9	768.47	4306835.0
2026-08-18 10:00:00	SPY	ETF	768.49	769.27	767.63	767.92	4783112.0
2026-08-18 11:00:00	SPY	ETF	767.93	768.63	767.33	768.35	3085556.0
2026-08-18 12:00:00	SPY	ETF	768.35	768.87	768.07	768.63	1546341.0
2026-08-18 13:00:00	SPY	ETF	768.62	768.82	767.61	767.62	1554757.0
2026-08-18 14:00:00	SPY	ETF	767.62	768.565	767.45	767.7	2787429.0
2026-08-18 15:00:00	SPY	ETF	767.69	768.22	766.92	767.41	8240753.0
2026-08-18 16:00:00	SPY	ETF	767.41	767.56	767.11	767.27	2034428.0
2026-08-18 17:00:00	SPY	ETF	767.28	767.36	767.1	767.36	48343.0
2026-08-18 18:00:00	SPY	ETF	767.36	767.72	766.75	766.75	51641.0
2026-08-18 19:00:00	SPY	ETF	766.75	767.35	766.7	767.04	39741.0
2026-08-18 04:00:00	QQQ	ETF	723.6	725.94	721.38	721.99	413540.0
2026-08-18 05:00:00	QQQ	ETF	722.1	722.32	720.19	721.3	147894.0
2026-08-18 06:00:00	QQQ	ETF	721.28	721.71	720.58	721.4	140476.0
2026-08-18 07:00:00	QQQ	ETF	721.41	722.31	721.1501	721.65	245495.0
2026-08-18 08:00:00	QQQ	ETF	721.62	729.323	720.06	720.805	330253.0
2026-08-18 09:00:00	QQQ	ETF	720.79	722.13	718.11	719.125	5362470.0
2026-08-18 10:00:00	QQQ	ETF	719.14	720.56	716.46	716.72	6108397.0
2026-08-18 11:00:00	QQQ	ETF	716.73	718.97	715.92	718.87	5356479.0
2026-08-18 12:00:00	QQQ	ETF	718.88	719.67	718.0501	719.18	3969174.0
2026-08-18 13:00:00	QQQ	ETF	719.16	719.44	717.12	717.125	3133470.0
2026-08-18 14:00:00	QQQ	ETF	717.121	718.3	716.69	717.24	2824347.0
2026-08-18 15:00:00	QQQ	ETF	717.24	718.17	716.92	717.62	5176950.0
2026-08-18 16:00:00	QQQ	ETF	717.6125	717.86	716.79	717.04	1425541.0
2026-08-18 17:00:00	QQQ	ETF	717.04	717.52	716.9	717.05	118405.0
2026-08-18 18:00:00	QQQ	ETF	717.04	717.74	715.98	716.04	163594.0
2026-08-18 19:00:00	QQQ	ETF	715.97	717.1487	715.97	716.18	110571.0
2026-08-18 04:00:00	IWM	ETF	302.83	303.56	302.48	303.19	71360.0
2026-08-18 05:00:00	IWM	ETF	303.14	303.27	302.96	303.27	37079.0
2026-08-18 06:00:00	IWM	ETF	303.25	303.46	303.0	303.28	40364.0
2026-08-18 07:00:00	IWM	ETF	303.08	303.35	302.97	303.2	52194.0
2026-08-18 08:00:00	IWM	ETF	303.13	303.37	302.86	303.08	173871.0
2026-08-18 09:00:00	IWM	ETF	303.08	303.15	301.89	302.5	2444871.0
2026-08-18 10:00:00	IWM	ETF	302.51	302.68	301.12	301.15	2806997.0
2026-08-18 11:00:00	IWM	ETF	301.16	301.39	300.535	301.13	1749116.0
2026-08-18 12:00:00	IWM	ETF	301.16	301.3	300.82	301.03	867990.0
2026-08-18 13:00:00	IWM	ETF	301.0	301.19	300.39	300.39	669940.0
2026-08-18 14:00:00	IWM	ETF	300.395	300.765	300.12	300.515	1503009.0
2026-08-18 15:00:00	IWM	ETF	300.51	300.79	300.11	300.26	3618892.0
2026-08-18 16:00:00	IWM	ETF	300.23	300.29	300.02	300.24	830256.0
2026-08-18 17:00:00	IWM	ETF	300.33	300.33	299.8	299.95	166277.0
2026-08-18 18:00:00	IWM	ETF	300.17	300.34	299.98	300.02	88595.0
2026-08-18 19:00:00	IWM	ETF	299.96	300.26	299.96	300.16	12609.0
2026-08-18 04:00:00	DIA	ETF	533.0	533.83	532.78	533.74	8528.0
2026-08-18 05:00:00	DIA	ETF	533.65	533.87	533.63	533.79	1321.0

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

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