PREVIEW / etf_1hour / 2026-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-23.parquet
  size:    725 KB
  rows:    28,960

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-23 04:00:00	SPY	ETF	733.97	741.63	732.91	733.61	286997.0
2026-06-23 05:00:00	SPY	ETF	733.8	735.3	733.79	735.05	178830.0
2026-06-23 06:00:00	SPY	ETF	735.12	735.64	733.49	734.38	137083.0
2026-06-23 07:00:00	SPY	ETF	734.42	736.16	734.03	735.95	386447.0
2026-06-23 08:00:00	SPY	ETF	735.88	736.25	733.64	734.08	290021.0
2026-06-23 09:00:00	SPY	ETF	734.145	737.23	732.3	737.17	6458293.0
2026-06-23 10:00:00	SPY	ETF	737.125	739.63	736.5	737.03	5608272.0
2026-06-23 11:00:00	SPY	ETF	737.07	737.43	734.21	735.97	3927206.0
2026-06-23 12:00:00	SPY	ETF	735.98	737.98	735.86	737.444	2883347.0
2026-06-23 13:00:00	SPY	ETF	737.43	738.1	735.75	735.795	2653169.0
2026-06-23 14:00:00	SPY	ETF	735.83	736.57	733.32	734.0225	5276494.0
2026-06-23 15:00:00	SPY	ETF	734.0	735.6	733.5	733.67	14725380.0
2026-06-23 16:00:00	SPY	ETF	733.69	734.9	733.38	734.8789	3137945.0
2026-06-23 17:00:00	SPY	ETF	734.85	735.04	734.21	734.87	145389.0
2026-06-23 18:00:00	SPY	ETF	734.95	735.42	733.25	733.88	175765.0
2026-06-23 19:00:00	SPY	ETF	733.67	735.3839	732.43	735.02	79534.0
2026-06-23 04:00:00	QQQ	ETF	720.02	732.3	717.05	718.24	676552.0
2026-06-23 05:00:00	QQQ	ETF	718.29	720.92	718.29	719.69	195897.0
2026-06-23 06:00:00	QQQ	ETF	719.7	720.49	716.55	718.1526	200936.0
2026-06-23 07:00:00	QQQ	ETF	718.14	719.79	717.42	719.54	485145.0
2026-06-23 08:00:00	QQQ	ETF	719.51	737.397	715.54	716.12	540728.0
2026-06-23 09:00:00	QQQ	ETF	716.24	720.9	713.28	720.71	6760881.0
2026-06-23 10:00:00	QQQ	ETF	720.69	723.61	717.89	718.8716	6260856.0
2026-06-23 11:00:00	QQQ	ETF	718.88	719.65	715.09	717.5314	4246015.0
2026-06-23 12:00:00	QQQ	ETF	717.54	720.3	717.33	719.045	3168924.0
2026-06-23 13:00:00	QQQ	ETF	719.01	719.79	715.85	715.87	2335546.0
2026-06-23 14:00:00	QQQ	ETF	715.93	717.08	712.1101	713.38	4140281.0
2026-06-23 15:00:00	QQQ	ETF	713.36	716.35	712.975	713.69	9173894.0
2026-06-23 16:00:00	QQQ	ETF	713.71	716.1995	713.31	716.0	1999008.0
2026-06-23 17:00:00	QQQ	ETF	715.89	716.86	715.75	716.63	145989.0
2026-06-23 18:00:00	QQQ	ETF	716.64	717.32	713.35	714.43	302587.0
2026-06-23 19:00:00	QQQ	ETF	714.5	716.423	712.3	716.04	235774.0
2026-06-23 04:00:00	IWM	ETF	293.56	296.89	292.61	293.05	121315.0
2026-06-23 05:00:00	IWM	ETF	293.14	293.99	293.14	293.83	14295.0
2026-06-23 06:00:00	IWM	ETF	293.92	294.1	292.98	293.4	175079.0
2026-06-23 07:00:00	IWM	ETF	293.569	294.78	293.38	294.689	346600.0
2026-06-23 08:00:00	IWM	ETF	294.59	294.63	293.0	293.24	124677.0
2026-06-23 09:00:00	IWM	ETF	293.17	295.96	292.4	295.95	3850206.0
2026-06-23 10:00:00	IWM	ETF	295.95	297.43	295.56	296.47	3731996.0
2026-06-23 11:00:00	IWM	ETF	296.5	296.79	295.39	296.48	1624180.0
2026-06-23 12:00:00	IWM	ETF	296.5	297.75	296.36	297.205	1549294.0
2026-06-23 13:00:00	IWM	ETF	297.195	297.75	295.975	296.01	989778.0
2026-06-23 14:00:00	IWM	ETF	296.02	296.46	294.63	295.01	1994944.0
2026-06-23 15:00:00	IWM	ETF	295.03	296.13	294.91	295.31	4549177.0
2026-06-23 16:00:00	IWM	ETF	295.27	295.72	295.19	295.55	1428693.0
2026-06-23 17:00:00	IWM	ETF	295.5	295.9	295.36	295.68	40073.0
2026-06-23 18:00:00	IWM	ETF	295.51	295.71	294.79	294.9	180179.0
2026-06-23 19:00:00	IWM	ETF	294.93	295.81	294.38	295.69	30579.0
2026-06-23 04:00:00	DIA	ETF	516.33	516.97	513.0	513.7	18362.0
2026-06-23 05:00:00	DIA	ETF	514.02	514.43	513.85	514.43	1599.0

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

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