PREVIEW / etf_1hour / 2026-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-05.parquet
  size:    733 KB
  rows:    29,096

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-05 04:00:00	SPY	ETF	773.73	774.82	772.97	773.3	102285.0
2026-08-05 05:00:00	SPY	ETF	773.3247	774.06	773.17	773.77	40493.0
2026-08-05 06:00:00	SPY	ETF	773.72	774.66	773.66	774.57	78480.0
2026-08-05 07:00:00	SPY	ETF	774.59	775.0	774.0	774.6704	244844.0
2026-08-05 08:00:00	SPY	ETF	774.68	775.42	774.46	774.81	221173.0
2026-08-05 09:00:00	SPY	ETF	774.86	776.85	774.39	776.7036	4573682.0
2026-08-05 10:00:00	SPY	ETF	776.67	776.7	772.54	773.47	5361098.0
2026-08-05 11:00:00	SPY	ETF	773.46	773.95	770.33	770.645	4517672.0
2026-08-05 12:00:00	SPY	ETF	770.63	772.22	769.91	771.8525	4551608.0
2026-08-05 13:00:00	SPY	ETF	771.89	772.16	771.01	771.555	2243105.0
2026-08-05 14:00:00	SPY	ETF	771.56	772.25	771.2	771.391	3364595.0
2026-08-05 15:00:00	SPY	ETF	771.4	771.989	769.51	769.76	6366905.0
2026-08-05 16:00:00	SPY	ETF	769.75	771.09	769.61	770.83	3327859.0
2026-08-05 17:00:00	SPY	ETF	770.76	771.0	770.35	770.5	133487.0
2026-08-05 18:00:00	SPY	ETF	770.61	771.97	770.59	771.35	59311.0
2026-08-05 19:00:00	SPY	ETF	771.33	771.71	771.0	771.12	17636.0
2026-08-05 04:00:00	QQQ	ETF	723.84	726.55	721.92	722.81	281573.0
2026-08-05 05:00:00	QQQ	ETF	722.9	724.1	722.3	723.33	83087.0
2026-08-05 06:00:00	QQQ	ETF	723.52	723.69	722.79	723.54	59618.0
2026-08-05 07:00:00	QQQ	ETF	723.53	725.4	723.51	724.87	287169.0
2026-08-05 08:00:00	QQQ	ETF	724.7986	725.54	724.18	724.78	218327.0
2026-08-05 09:00:00	QQQ	ETF	724.7993	728.54	724.34	727.99	4191270.0
2026-08-05 10:00:00	QQQ	ETF	727.9	727.93	721.6	723.04	5267767.0
2026-08-05 11:00:00	QQQ	ETF	723.07	724.115	719.77	720.37	3470790.0
2026-08-05 12:00:00	QQQ	ETF	720.38	722.88	719.48	722.14	2857322.0
2026-08-05 13:00:00	QQQ	ETF	722.17	722.4	720.32	720.855	1309472.0
2026-08-05 14:00:00	QQQ	ETF	720.86	721.6	720.05	720.09	1516673.0
2026-08-05 15:00:00	QQQ	ETF	720.11	721.41	716.92	717.24	3473837.0
2026-08-05 16:00:00	QQQ	ETF	717.24	720.688	715.43	716.92	2011763.0
2026-08-05 17:00:00	QQQ	ETF	716.85	717.34	715.56	715.95	394772.0
2026-08-05 18:00:00	QQQ	ETF	716.11	718.95	716.11	717.66	264690.0
2026-08-05 19:00:00	QQQ	ETF	717.6596	718.2	716.3	716.51	96958.0
2026-08-05 04:00:00	IWM	ETF	302.77	302.96	302.02	302.11	32698.0
2026-08-05 05:00:00	IWM	ETF	302.2	302.31	302.05	302.2	7941.0
2026-08-05 06:00:00	IWM	ETF	302.28	302.32	302.06	302.2	18109.0
2026-08-05 07:00:00	IWM	ETF	302.2305	302.51	302.13	302.37	59358.0
2026-08-05 08:00:00	IWM	ETF	302.39	302.73	302.24	302.66	55213.0
2026-08-05 09:00:00	IWM	ETF	302.58	303.06	301.45	303.03	2430891.0
2026-08-05 10:00:00	IWM	ETF	303.0	303.03	300.8	301.135	2480742.0
2026-08-05 11:00:00	IWM	ETF	301.13	301.63	300.1	300.23	2206824.0
2026-08-05 12:00:00	IWM	ETF	300.22	301.1	300.21	300.985	1869156.0
2026-08-05 13:00:00	IWM	ETF	301.0	301.34	300.58	301.2	1331469.0
2026-08-05 14:00:00	IWM	ETF	301.2	301.27	300.395	300.4	1476814.0
2026-08-05 15:00:00	IWM	ETF	300.4	300.72	299.75	299.76	2423952.0
2026-08-05 16:00:00	IWM	ETF	299.77	300.1854	299.62	300.11	675437.0
2026-08-05 17:00:00	IWM	ETF	300.02	300.16	299.83	299.9	10088.0
2026-08-05 18:00:00	IWM	ETF	300.08	300.33	300.042	300.05	16651.0
2026-08-05 19:00:00	IWM	ETF	300.005	300.17	299.99	300.03	6764.0
2026-08-05 04:00:00	DIA	ETF	542.29	542.91	541.54	541.84	6156.0
2026-08-05 05:00:00	DIA	ETF	541.95	542.15	541.93	541.9599	1924.0

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

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