PREVIEW / etf_1hour / 2026-08-12

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-12.parquet
  size:    719 KB
  rows:    28,355

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-12 04:00:00	SPY	ETF	771.5	771.89	770.93	771.84	57052.0
2026-08-12 05:00:00	SPY	ETF	771.79	772.84	771.79	772.14	25731.0
2026-08-12 06:00:00	SPY	ETF	772.16	772.52	771.47	772.11	76384.0
2026-08-12 07:00:00	SPY	ETF	772.16	772.67	772.0	772.6	153879.0
2026-08-12 08:00:00	SPY	ETF	772.59	774.2	770.85	774.0	698296.0
2026-08-12 09:00:00	SPY	ETF	774.0	774.9	772.09	772.59	3678832.0
2026-08-12 10:00:00	SPY	ETF	772.595	773.305	771.28	772.22	4125668.0
2026-08-12 11:00:00	SPY	ETF	772.2209	772.47	771.56	772.03	1927958.0
2026-08-12 12:00:00	SPY	ETF	772.015	773.2	771.97	772.905	2335087.0
2026-08-12 13:00:00	SPY	ETF	772.91	773.29	772.61	772.8101	1978710.0
2026-08-12 14:00:00	SPY	ETF	772.81	773.63	772.78	773.06	2196421.0
2026-08-12 15:00:00	SPY	ETF	773.035	773.38	772.0	772.52	4576986.0
2026-08-12 16:00:00	SPY	ETF	772.52	773.32	772.21	772.21	2312416.0
2026-08-12 17:00:00	SPY	ETF	772.21	772.58	772.11	772.51	83658.0
2026-08-12 18:00:00	SPY	ETF	772.51	772.64	772.21	772.3401	142811.0
2026-08-12 19:00:00	SPY	ETF	772.4562	772.658	772.26	772.3	31811.0
2026-08-12 04:00:00	QQQ	ETF	721.21	722.4	719.29	722.26	127290.0
2026-08-12 05:00:00	QQQ	ETF	722.3	723.57	722.3	722.7474	83138.0
2026-08-12 06:00:00	QQQ	ETF	722.7701	723.44	722.115	722.74	128704.0
2026-08-12 07:00:00	QQQ	ETF	722.77	723.49	722.52	723.49	128347.0
2026-08-12 08:00:00	QQQ	ETF	723.46	726.0	717.912	725.31	784107.0
2026-08-12 09:00:00	QQQ	ETF	725.32	727.25	723.73	725.04	4254513.0
2026-08-12 10:00:00	QQQ	ETF	725.04	725.93	723.23	724.08	3890711.0
2026-08-12 11:00:00	QQQ	ETF	724.09	724.64	722.92	723.24	1969888.0
2026-08-12 12:00:00	QQQ	ETF	723.24	725.25	723.16	724.99	1752872.0
2026-08-12 13:00:00	QQQ	ETF	724.98	725.43	724.59	725.115	1412459.0
2026-08-12 14:00:00	QQQ	ETF	725.115	725.56	724.51	724.63	1133214.0
2026-08-12 15:00:00	QQQ	ETF	724.63	724.96	723.035	723.66	3284867.0
2026-08-12 16:00:00	QQQ	ETF	723.65	724.95	717.37	722.59	1065241.0
2026-08-12 17:00:00	QQQ	ETF	722.75	723.3831	722.71	723.32	47802.0
2026-08-12 18:00:00	QQQ	ETF	723.32	723.32	722.01	722.44	91451.0
2026-08-12 19:00:00	QQQ	ETF	722.3731	722.81	722.34	722.58	63545.0
2026-08-12 04:00:00	IWM	ETF	301.43	301.64	301.19	301.52	52609.0
2026-08-12 05:00:00	IWM	ETF	301.53	302.02	301.51	301.58	7379.0
2026-08-12 06:00:00	IWM	ETF	301.66	301.8	301.19	301.275	30558.0
2026-08-12 07:00:00	IWM	ETF	301.3	301.85	301.26	301.82	53897.0
2026-08-12 08:00:00	IWM	ETF	301.81	303.25	301.27	302.75	537634.0
2026-08-12 09:00:00	IWM	ETF	302.75	303.41	301.89	301.89	2256831.0
2026-08-12 10:00:00	IWM	ETF	301.895	302.08	301.0	301.2	1766181.0
2026-08-12 11:00:00	IWM	ETF	301.19	302.1	301.025	302.07	1258086.0
2026-08-12 12:00:00	IWM	ETF	302.06	302.645	302.055	302.23	888964.0
2026-08-12 13:00:00	IWM	ETF	302.23	302.405	302.005	302.2901	846566.0
2026-08-12 14:00:00	IWM	ETF	302.3	303.015	302.26	302.7797	866467.0
2026-08-12 15:00:00	IWM	ETF	302.77	303.355	302.64	302.71	2290022.0
2026-08-12 16:00:00	IWM	ETF	302.71	303.03	302.61	302.71	459615.0
2026-08-12 17:00:00	IWM	ETF	302.73	302.84	302.53	302.78	22840.0
2026-08-12 18:00:00	IWM	ETF	302.82	303.05	302.79	302.89	11813.0
2026-08-12 19:00:00	IWM	ETF	302.94	303.02	302.86	302.92	13924.0
2026-08-12 04:00:00	DIA	ETF	537.52	537.55	537.25	537.25	2198.0
2026-08-12 05:00:00	DIA	ETF	537.48	538.03	537.42	538.03	660.0

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

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