PREVIEW / etf_1hour / 2026-06-25

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-25.parquet
  size:    711 KB
  rows:    28,373

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-06-25 04:00:00	SPY	ETF	739.0	739.48	736.41	738.02	90384.0
2026-06-25 05:00:00	SPY	ETF	738.11	738.72	737.98	738.56	54727.0
2026-06-25 06:00:00	SPY	ETF	738.43	739.0	738.35	738.58	25089.0
2026-06-25 07:00:00	SPY	ETF	738.68	738.99	737.54	738.02	399229.0
2026-06-25 08:00:00	SPY	ETF	737.96	739.92	737.61	739.04	291975.0
2026-06-25 09:00:00	SPY	ETF	739.0	739.37	729.6	729.85	6256351.0
2026-06-25 10:00:00	SPY	ETF	729.84	737.82	729.78	735.23	7163334.0
2026-06-25 11:00:00	SPY	ETF	735.26	736.52	731.85	734.14	4264503.0
2026-06-25 12:00:00	SPY	ETF	734.16	736.27	731.5	732.54	2829308.0
2026-06-25 13:00:00	SPY	ETF	732.56	734.25	731.6	733.45	2465333.0
2026-06-25 14:00:00	SPY	ETF	733.44	736.06	731.38	733.88	4181886.0
2026-06-25 15:00:00	SPY	ETF	733.93	733.9414	731.33	733.26	7530271.0
2026-06-25 16:00:00	SPY	ETF	733.27	735.86	733.23	733.74	3340020.0
2026-06-25 17:00:00	SPY	ETF	734.0	734.02	733.4	733.5	136309.0
2026-06-25 18:00:00	SPY	ETF	733.5	733.99	732.2	733.12	80659.0
2026-06-25 19:00:00	SPY	ETF	733.05	735.86	732.2812	732.7	146320.0
2026-06-25 04:00:00	QQQ	ETF	726.57	727.44	722.24	725.18	293115.0
2026-06-25 05:00:00	QQQ	ETF	725.1	725.94	725.0	725.3	121896.0
2026-06-25 06:00:00	QQQ	ETF	725.29	726.62	725.24	725.99	118703.0
2026-06-25 07:00:00	QQQ	ETF	726.029	726.8	724.55	725.29	320608.0
2026-06-25 08:00:00	QQQ	ETF	725.28	728.42	725.0	727.04	510632.0
2026-06-25 09:00:00	QQQ	ETF	727.05	727.29	705.3	705.76	9099793.0
2026-06-25 10:00:00	QQQ	ETF	705.84	716.77	705.61	713.43	8761640.0
2026-06-25 11:00:00	QQQ	ETF	713.46	716.47	709.24	714.05	3955526.0
2026-06-25 12:00:00	QQQ	ETF	714.05	719.11	712.3	714.62	3681960.0
2026-06-25 13:00:00	QQQ	ETF	714.6036	717.69	714.39	717.3412	2568230.0
2026-06-25 14:00:00	QQQ	ETF	717.31	719.6	714.58	716.74	3283358.0
2026-06-25 15:00:00	QQQ	ETF	716.77	716.81	712.96	716.26	5008573.0
2026-06-25 16:00:00	QQQ	ETF	716.26	720.32	716.12	716.41	1514619.0
2026-06-25 17:00:00	QQQ	ETF	716.59	716.6841	715.57	715.81	40022.0
2026-06-25 18:00:00	QQQ	ETF	715.88	716.45	712.88	714.48	189516.0
2026-06-25 19:00:00	QQQ	ETF	714.5309	719.63	714.2	714.93	322918.0
2026-06-25 04:00:00	IWM	ETF	297.77	298.1	296.84	297.11	29501.0
2026-06-25 05:00:00	IWM	ETF	297.11	297.44	297.0	297.19	37983.0
2026-06-25 06:00:00	IWM	ETF	297.36	297.84	297.3	297.32	9198.0
2026-06-25 07:00:00	IWM	ETF	297.33	297.47	296.9097	297.18	41924.0
2026-06-25 08:00:00	IWM	ETF	297.23	299.14	297.0	298.6	323127.0
2026-06-25 09:00:00	IWM	ETF	298.67	300.97	296.9	297.11	3153058.0
2026-06-25 10:00:00	IWM	ETF	297.13	301.5	297.13	300.44	3361512.0
2026-06-25 11:00:00	IWM	ETF	300.47	300.63	298.0	298.21	2543347.0
2026-06-25 12:00:00	IWM	ETF	298.23	299.66	297.715	298.34	2007651.0
2026-06-25 13:00:00	IWM	ETF	298.345	299.08	297.61	298.58	1734978.0
2026-06-25 14:00:00	IWM	ETF	298.59	298.905	297.0	297.61	1884043.0
2026-06-25 15:00:00	IWM	ETF	297.63	298.89	296.73	298.83	4802970.0
2026-06-25 16:00:00	IWM	ETF	298.86	299.66	298.86	299.07	1390421.0
2026-06-25 17:00:00	IWM	ETF	299.1	299.3	298.699	298.7	114536.0
2026-06-25 18:00:00	IWM	ETF	298.85	299.04	298.3	298.77	72024.0
2026-06-25 19:00:00	IWM	ETF	298.79	299.99	298.33	298.4392	43574.0
2026-06-25 04:00:00	DIA	ETF	519.25	519.25	518.39	518.91	1520.0
2026-06-25 05:00:00	DIA	ETF	519.0	519.07	519.0	519.07	627.0

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

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