PREVIEW / etf_1hour / 2026-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-22.parquet
  size:    732 KB
  rows:    28,803

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-22 04:00:00	SPY	ETF	745.5	747.02	743.0	746.27	85323.0
2026-06-22 05:00:00	SPY	ETF	746.24	746.75	745.87	745.87	13415.0
2026-06-22 06:00:00	SPY	ETF	745.87	746.82	745.87	746.26	34885.0
2026-06-22 07:00:00	SPY	ETF	746.22	748.1	746.22	746.7	115505.0
2026-06-22 08:00:00	SPY	ETF	746.87	747.97	744.06	747.19	157198.0
2026-06-22 09:00:00	SPY	ETF	747.2	749.94	747.19	749.91	3735567.0
2026-06-22 10:00:00	SPY	ETF	749.91	750.18	743.15	744.72	5241422.0
2026-06-22 11:00:00	SPY	ETF	744.69	746.28	743.87	744.61	3673311.0
2026-06-22 12:00:00	SPY	ETF	744.62	745.36	743.59	744.95	3278709.0
2026-06-22 13:00:00	SPY	ETF	744.96	745.34	743.96	744.69	2035532.0
2026-06-22 14:00:00	SPY	ETF	744.71	745.74	743.6	743.725	3482191.0
2026-06-22 15:00:00	SPY	ETF	743.73	744.87	743.13	744.37	10138295.0
2026-06-22 16:00:00	SPY	ETF	744.33	745.04	744.25	744.5264	2961064.0
2026-06-22 17:00:00	SPY	ETF	744.48	744.63	744.32	744.56	35906.0
2026-06-22 18:00:00	SPY	ETF	744.58	745.15	743.44	743.76	351572.0
2026-06-22 19:00:00	SPY	ETF	743.75	743.86	743.18	743.67	120583.0
2026-06-22 04:00:00	QQQ	ETF	740.34	742.0	735.0	739.82	343440.0
2026-06-22 05:00:00	QQQ	ETF	739.85	740.44	739.1	739.1	57375.0
2026-06-22 06:00:00	QQQ	ETF	739.11	740.62	739.0	739.64	128116.0
2026-06-22 07:00:00	QQQ	ETF	739.57	742.11	739.43	740.43	275965.0
2026-06-22 08:00:00	QQQ	ETF	740.5	742.57	740.065	741.6	225031.0
2026-06-22 09:00:00	QQQ	ETF	741.56	744.695	740.43	744.695	3886457.0
2026-06-22 10:00:00	QQQ	ETF	744.6	745.45	735.35	737.6695	4987318.0
2026-06-22 11:00:00	QQQ	ETF	737.71	738.59	735.36	735.7376	2792855.0
2026-06-22 12:00:00	QQQ	ETF	735.74	737.0886	734.39	736.47	2214737.0
2026-06-22 13:00:00	QQQ	ETF	736.48	737.96	735.1	737.12	1833575.0
2026-06-22 14:00:00	QQQ	ETF	737.13	738.28	735.54	735.72	2199938.0
2026-06-22 15:00:00	QQQ	ETF	735.74	738.51	735.1283	738.001	4305785.0
2026-06-22 16:00:00	QQQ	ETF	738.06	738.55	737.68	738.18	1809847.0
2026-06-22 17:00:00	QQQ	ETF	738.34	738.34	737.6	738.1	66309.0
2026-06-22 18:00:00	QQQ	ETF	738.05	739.16	736.0	736.3	256447.0
2026-06-22 19:00:00	QQQ	ETF	736.14	736.39	735.28	736.17	107396.0
2026-06-22 04:00:00	IWM	ETF	293.55	295.25	293.21	294.93	28290.0
2026-06-22 05:00:00	IWM	ETF	294.93	295.38	294.74	295.22	19526.0
2026-06-22 06:00:00	IWM	ETF	295.25	295.81	295.25	295.55	13398.0
2026-06-22 07:00:00	IWM	ETF	295.49	296.78	295.49	296.4	99858.0
2026-06-22 08:00:00	IWM	ETF	296.35	296.87	296.29	296.45	40662.0
2026-06-22 09:00:00	IWM	ETF	296.43	299.49	296.43	299.45	3535953.0
2026-06-22 10:00:00	IWM	ETF	299.43	299.43	296.16	297.04	2581296.0
2026-06-22 11:00:00	IWM	ETF	297.04	298.26	296.98	297.77	1443382.0
2026-06-22 12:00:00	IWM	ETF	297.79	298.3	297.13	298.11	1115979.0
2026-06-22 13:00:00	IWM	ETF	298.12	298.41	297.34	298.34	1151771.0
2026-06-22 14:00:00	IWM	ETF	298.345	299.17	298.02	298.07	1458893.0
2026-06-22 15:00:00	IWM	ETF	298.09	298.63	297.81	298.19	2971496.0
2026-06-22 16:00:00	IWM	ETF	298.18	298.56	297.86	298.18	967757.0
2026-06-22 17:00:00	IWM	ETF	297.96	298.39	297.86	298.25	16266.0
2026-06-22 18:00:00	IWM	ETF	298.1	298.11	297.5178	297.68	27233.0
2026-06-22 19:00:00	IWM	ETF	297.62	297.9	297.47	297.9	10243.0
2026-06-22 04:00:00	DIA	ETF	514.34	515.67	513.93	515.43	5593.0
2026-06-22 05:00:00	DIA	ETF	515.961	516.09	515.54	515.54	752.0

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

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