PREVIEW / etf_1hour / 2026-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-02.parquet
  size:    709 KB
  rows:    28,150

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-07-02 04:00:00	SPY	ETF	745.24	747.4	744.01	746.17	70457.0
2026-07-02 05:00:00	SPY	ETF	746.13	746.16	745.48	745.63	25033.0
2026-07-02 06:00:00	SPY	ETF	745.62	746.3	745.2	746.22	17161.0
2026-07-02 07:00:00	SPY	ETF	746.171	746.84	745.8	746.2665	105666.0
2026-07-02 08:00:00	SPY	ETF	746.15	749.54	746.03	748.0565	651650.0
2026-07-02 09:00:00	SPY	ETF	748.1	751.245	747.1	750.76	4004597.0
2026-07-02 10:00:00	SPY	ETF	750.78	751.31	746.015	747.66	5505882.0
2026-07-02 11:00:00	SPY	ETF	747.65	747.828	744.05	744.645	4593617.0
2026-07-02 12:00:00	SPY	ETF	744.65	744.87	741.81	742.18	3195013.0
2026-07-02 13:00:00	SPY	ETF	742.2	742.28	740.03	740.24	3575918.0
2026-07-02 14:00:00	SPY	ETF	740.26	743.51	740.05	742.9895	3134933.0
2026-07-02 15:00:00	SPY	ETF	742.99	745.58	741.27	744.8	10371787.0
2026-07-02 16:00:00	SPY	ETF	744.8799	745.5312	743.98	744.51	3979641.0
2026-07-02 17:00:00	SPY	ETF	744.56	744.78	744.2	744.64	175390.0
2026-07-02 18:00:00	SPY	ETF	744.64	745.64	744.6	745.64	82675.0
2026-07-02 19:00:00	SPY	ETF	745.63	745.85	745.1	745.7101	19426.0
2026-07-02 04:00:00	QQQ	ETF	721.71	728.0	719.45	724.43	363037.0
2026-07-02 05:00:00	QQQ	ETF	724.27	724.27	722.29	722.58	112399.0
2026-07-02 06:00:00	QQQ	ETF	722.6	723.74	721.69	723.65	93031.0
2026-07-02 07:00:00	QQQ	ETF	723.68	725.5	722.85	724.5	232497.0
2026-07-02 08:00:00	QQQ	ETF	724.44	731.33	724.19	728.12	906808.0
2026-07-02 09:00:00	QQQ	ETF	728.15	730.0	723.871	729.9	4076570.0
2026-07-02 10:00:00	QQQ	ETF	729.94	730.83	717.21	719.815	7424479.0
2026-07-02 11:00:00	QQQ	ETF	719.845	720.1	714.2827	715.87	4942727.0
2026-07-02 12:00:00	QQQ	ETF	715.92	716.1579	710.12	710.785	4326389.0
2026-07-02 13:00:00	QQQ	ETF	710.78	711.29	707.56	707.78	3721090.0
2026-07-02 14:00:00	QQQ	ETF	707.82	712.405	707.63	711.5	3546210.0
2026-07-02 15:00:00	QQQ	ETF	711.5	713.78	708.07	712.74	6053676.0
2026-07-02 16:00:00	QQQ	ETF	712.71	713.26	712.11	713.04	1888000.0
2026-07-02 17:00:00	QQQ	ETF	713.035	713.4489	712.6	713.44	332194.0
2026-07-02 18:00:00	QQQ	ETF	713.45	714.65	713.22	714.6	68945.0
2026-07-02 19:00:00	QQQ	ETF	714.47	714.5556	713.12	714.22	73421.0
2026-07-02 04:00:00	IWM	ETF	299.16	299.73	298.5	299.63	24098.0
2026-07-02 05:00:00	IWM	ETF	299.6	299.87	299.47	299.65	11369.0
2026-07-02 06:00:00	IWM	ETF	299.62	300.15	299.62	299.94	10433.0
2026-07-02 07:00:00	IWM	ETF	299.99	300.45	299.87	300.24	48725.0
2026-07-02 08:00:00	IWM	ETF	300.04	302.23	299.97	301.2028	491947.0
2026-07-02 09:00:00	IWM	ETF	301.25	302.23	300.085	301.85	2079595.0
2026-07-02 10:00:00	IWM	ETF	301.85	301.92	298.05	298.66	2868799.0
2026-07-02 11:00:00	IWM	ETF	298.7	298.71	296.76	297.64	2371847.0
2026-07-02 12:00:00	IWM	ETF	297.67	297.83	296.006	296.48	1295466.0
2026-07-02 13:00:00	IWM	ETF	296.49	296.61	295.07	295.19	1575036.0
2026-07-02 14:00:00	IWM	ETF	295.21	296.47	295.08	296.1999	1827302.0
2026-07-02 15:00:00	IWM	ETF	296.2	297.61	294.98	297.53	3339800.0
2026-07-02 16:00:00	IWM	ETF	297.54	297.58	296.74	297.13	1218383.0
2026-07-02 17:00:00	IWM	ETF	297.06	297.58	296.8301	296.9265	131038.0
2026-07-02 18:00:00	IWM	ETF	297.08	297.35	297.08	297.34	67884.0
2026-07-02 19:00:00	IWM	ETF	297.34	297.42	297.13	297.31	6418.0
2026-07-02 04:00:00	DIA	ETF	522.75	523.25	521.89	523.12	6925.0
2026-07-02 05:00:00	DIA	ETF	522.92	522.97	522.91	522.96	1282.0

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

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