PREVIEW / etf_1hour / 2026-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-01.parquet
  size:    713 KB
  rows:    28,294

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-01 04:00:00	SPY	ETF	744.53	745.2	743.0	744.67	183372.0
2026-07-01 05:00:00	SPY	ETF	744.69	744.89	744.07	744.89	25864.0
2026-07-01 06:00:00	SPY	ETF	744.97	745.52	744.45	745.48	28100.0
2026-07-01 07:00:00	SPY	ETF	745.379	745.72	744.78	744.8693	133950.0
2026-07-01 08:00:00	SPY	ETF	745.01	745.58	744.26	744.66	202772.0
2026-07-01 09:00:00	SPY	ETF	744.77	745.72	742.375	745.34	5424308.0
2026-07-01 10:00:00	SPY	ETF	745.34	747.11	745.0	746.96	4558653.0
2026-07-01 11:00:00	SPY	ETF	746.99	749.365	746.9	748.79	3945160.0
2026-07-01 12:00:00	SPY	ETF	748.811	749.435	747.3225	747.52	2445354.0
2026-07-01 13:00:00	SPY	ETF	747.51	748.42	747.04	747.195	2495849.0
2026-07-01 14:00:00	SPY	ETF	747.2	747.69	746.45	746.85	2799377.0
2026-07-01 15:00:00	SPY	ETF	746.86	747.69	745.16	745.69	8446784.0
2026-07-01 16:00:00	SPY	ETF	745.67	745.76	744.2	744.9	3018766.0
2026-07-01 17:00:00	SPY	ETF	744.8999	745.24	744.75	745.11	87404.0
2026-07-01 18:00:00	SPY	ETF	745.16	745.76	744.76	745.6201	198639.0
2026-07-01 19:00:00	SPY	ETF	745.4896	745.53	744.5	744.91	41848.0
2026-07-01 04:00:00	QQQ	ETF	732.43	734.88	730.8	732.55	259959.0
2026-07-01 05:00:00	QQQ	ETF	732.28	732.75	731.63	732.74	67503.0
2026-07-01 06:00:00	QQQ	ETF	732.82	733.42	731.99	733.25	73846.0
2026-07-01 07:00:00	QQQ	ETF	733.3	733.94	732.07	732.21	230746.0
2026-07-01 08:00:00	QQQ	ETF	732.25	736.952	729.14	730.08	701842.0
2026-07-01 09:00:00	QQQ	ETF	729.9	731.03	725.52	730.17	6163709.0
2026-07-01 10:00:00	QQQ	ETF	730.24	731.29	726.6786	728.03	4043562.0
2026-07-01 11:00:00	QQQ	ETF	728.05	731.92	727.89	729.54	3514328.0
2026-07-01 12:00:00	QQQ	ETF	729.46	730.17	727.53	727.9	2322976.0
2026-07-01 13:00:00	QQQ	ETF	727.87	729.12	727.0	727.19	2003424.0
2026-07-01 14:00:00	QQQ	ETF	727.225	727.87	725.6526	726.46	2459215.0
2026-07-01 15:00:00	QQQ	ETF	726.45	728.93	724.6	725.16	5548630.0
2026-07-01 16:00:00	QQQ	ETF	725.19	725.35	723.56	724.85	1283176.0
2026-07-01 17:00:00	QQQ	ETF	724.99	725.74	724.49	725.58	71452.0
2026-07-01 18:00:00	QQQ	ETF	725.5	726.07	724.64	726.0	492081.0
2026-07-01 19:00:00	QQQ	ETF	725.91	725.91	723.62	724.25	86458.0
2026-07-01 04:00:00	IWM	ETF	299.38	299.72	298.37	299.6753	39640.0
2026-07-01 05:00:00	IWM	ETF	299.72	299.77	299.37	299.76	28008.0
2026-07-01 06:00:00	IWM	ETF	299.74	299.78	299.3	299.7	10324.0
2026-07-01 07:00:00	IWM	ETF	299.63	299.84	299.17	299.32	20624.0
2026-07-01 08:00:00	IWM	ETF	299.08	299.76	298.98	299.38	50157.0
2026-07-01 09:00:00	IWM	ETF	299.35	300.95	298.8	300.95	2459432.0
2026-07-01 10:00:00	IWM	ETF	300.99	302.31	300.42	300.89	2982727.0
2026-07-01 11:00:00	IWM	ETF	300.89	302.72	300.835	302.01	2377459.0
2026-07-01 12:00:00	IWM	ETF	302.01	302.43	301.43	301.63	1191839.0
2026-07-01 13:00:00	IWM	ETF	301.64	301.84	300.78	300.82	1315953.0
2026-07-01 14:00:00	IWM	ETF	300.83	301.095	299.93	300.23	1405567.0
2026-07-01 15:00:00	IWM	ETF	300.24	300.67	299.18	299.31	3042652.0
2026-07-01 16:00:00	IWM	ETF	299.34	299.35	298.7	299.05	985799.0
2026-07-01 17:00:00	IWM	ETF	299.09	299.3	298.8	299.28	4186.0
2026-07-01 18:00:00	IWM	ETF	299.17	299.17	298.77	299.1596	18829.0
2026-07-01 19:00:00	IWM	ETF	299.12	299.12	298.6078	298.84	12705.0
2026-07-01 04:00:00	DIA	ETF	520.63	521.23	520.14	521.22	10223.0
2026-07-01 05:00:00	DIA	ETF	521.05	521.08	521.04	521.07	738.0

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

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