PREVIEW / etf_1hour / 2026-08-11

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-11.parquet
  size:    710 KB
  rows:    28,215

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-11 04:00:00	SPY	ETF	772.89	774.31	772.39	772.9	40499.0
2026-08-11 05:00:00	SPY	ETF	772.87	773.36	772.54	773.18	10263.0
2026-08-11 06:00:00	SPY	ETF	773.18	774.1	772.93	773.86	17083.0
2026-08-11 07:00:00	SPY	ETF	773.86	774.955	773.8567	774.27	173094.0
2026-08-11 08:00:00	SPY	ETF	774.32	774.83	773.5	774.15	209610.0
2026-08-11 09:00:00	SPY	ETF	774.18	774.66	772.58	773.615	2610585.0
2026-08-11 10:00:00	SPY	ETF	773.615	774.08	773.21	773.62	3110806.0
2026-08-11 11:00:00	SPY	ETF	773.63	773.81	771.75	772.0	3189766.0
2026-08-11 12:00:00	SPY	ETF	772.03	772.45	771.04	771.14	2651704.0
2026-08-11 13:00:00	SPY	ETF	771.15	771.355	770.26	771.24	2071431.0
2026-08-11 14:00:00	SPY	ETF	771.22	771.2395	769.2	770.075	2934061.0
2026-08-11 15:00:00	SPY	ETF	770.09	771.095	769.79	770.42	4762622.0
2026-08-11 16:00:00	SPY	ETF	770.45	771.2	770.17	770.75	4593860.0
2026-08-11 17:00:00	SPY	ETF	770.76	771.0	770.56	770.8	181867.0
2026-08-11 18:00:00	SPY	ETF	770.71	770.97	770.5	770.7784	107232.0
2026-08-11 19:00:00	SPY	ETF	770.76	770.98	770.62	770.98	22438.0
2026-08-11 04:00:00	QQQ	ETF	721.7	723.73	720.36	721.06	129381.0
2026-08-11 05:00:00	QQQ	ETF	721.16	721.89	720.4	721.5334	44119.0
2026-08-11 06:00:00	QQQ	ETF	721.62	723.06	721.18	722.73	61311.0
2026-08-11 07:00:00	QQQ	ETF	722.77	724.38	722.6	723.09	319874.0
2026-08-11 08:00:00	QQQ	ETF	723.09	724.01	722.8	723.11	242247.0
2026-08-11 09:00:00	QQQ	ETF	723.16	723.54	718.401	720.68	3233600.0
2026-08-11 10:00:00	QQQ	ETF	720.7	722.44	720.37	721.78	3092750.0
2026-08-11 11:00:00	QQQ	ETF	721.8	722.14	718.9716	719.0699	2174748.0
2026-08-11 12:00:00	QQQ	ETF	719.06	719.46	717.93	718.14	2428038.0
2026-08-11 13:00:00	QQQ	ETF	718.14	718.47	716.86	718.19	2288357.0
2026-08-11 14:00:00	QQQ	ETF	718.201	718.36	715.5	717.09	2075451.0
2026-08-11 15:00:00	QQQ	ETF	717.09	718.94	716.82	718.33	4293818.0
2026-08-11 16:00:00	QQQ	ETF	718.37	719.31	717.8951	718.62	1094883.0
2026-08-11 17:00:00	QQQ	ETF	718.7	718.94	718.5	718.74	46062.0
2026-08-11 18:00:00	QQQ	ETF	718.65	719.0	718.28	718.72	83792.0
2026-08-11 19:00:00	QQQ	ETF	718.6093	718.99	718.32	718.99	31658.0
2026-08-11 04:00:00	IWM	ETF	300.12	300.7	299.78	299.78	44554.0
2026-08-11 05:00:00	IWM	ETF	299.73	299.89	299.55	299.83	17968.0
2026-08-11 06:00:00	IWM	ETF	299.85	300.42	299.73	300.16	14072.0
2026-08-11 07:00:00	IWM	ETF	300.15	301.11	300.15	300.64	56513.0
2026-08-11 08:00:00	IWM	ETF	300.59	300.85	300.18	300.27	114510.0
2026-08-11 09:00:00	IWM	ETF	300.26	301.91	300.26	301.91	1592320.0
2026-08-11 10:00:00	IWM	ETF	301.89	301.99	301.21	301.33	1374815.0
2026-08-11 11:00:00	IWM	ETF	301.325	301.415	300.6	301.06	1456712.0
2026-08-11 12:00:00	IWM	ETF	301.06	301.572	300.96	301.29	916001.0
2026-08-11 13:00:00	IWM	ETF	301.3	301.47	301.055	301.33	771031.0
2026-08-11 14:00:00	IWM	ETF	301.315	301.585	300.925	301.26	1676843.0
2026-08-11 15:00:00	IWM	ETF	301.26	301.47	300.865	301.0	3112183.0
2026-08-11 16:00:00	IWM	ETF	301.02	301.25	300.9	300.97	849365.0
2026-08-11 17:00:00	IWM	ETF	301.01	301.2	300.9	301.01	8726.0
2026-08-11 18:00:00	IWM	ETF	301.1	301.16	300.94	300.99	4614.0
2026-08-11 19:00:00	IWM	ETF	300.98	301.04	300.93	301.03	2861.0
2026-08-11 04:00:00	DIA	ETF	538.51	538.88	538.0	538.36	3073.0
2026-08-11 05:00:00	DIA	ETF	538.32	538.53	538.32	538.49	1141.0

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

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