PREVIEW / etf_1hour / 2026-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-24.parquet
  size:    703 KB
  rows:    28,314

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-24 04:00:00	SPY	ETF	735.94	736.27	734.0	735.2	63663.0
2026-06-24 05:00:00	SPY	ETF	735.3418	735.65	734.44	735.15	16747.0
2026-06-24 06:00:00	SPY	ETF	734.8	736.25	734.77	735.3	65390.0
2026-06-24 07:00:00	SPY	ETF	735.325	737.0	734.82	736.6	207350.0
2026-06-24 08:00:00	SPY	ETF	736.8	737.12	735.25	735.53	203868.0
2026-06-24 09:00:00	SPY	ETF	735.56	737.7	734.3	735.935	5856508.0
2026-06-24 10:00:00	SPY	ETF	735.94	739.71	734.11	739.66	4014927.0
2026-06-24 11:00:00	SPY	ETF	739.68	739.945	737.83	738.34	3676403.0
2026-06-24 12:00:00	SPY	ETF	738.34	738.87	735.39	735.69	2563668.0
2026-06-24 13:00:00	SPY	ETF	735.7	736.46	731.28	731.87	4418724.0
2026-06-24 14:00:00	SPY	ETF	731.86	734.66	731.23	731.93	4789576.0
2026-06-24 15:00:00	SPY	ETF	731.93	733.35	730.84	733.12	10675264.0
2026-06-24 16:00:00	SPY	ETF	733.04	738.35	732.45	737.85	4932844.0
2026-06-24 17:00:00	SPY	ETF	737.86	738.01	737.05	737.89	141192.0
2026-06-24 18:00:00	SPY	ETF	738.0	738.73	736.7	736.7	272410.0
2026-06-24 19:00:00	SPY	ETF	736.7	737.74	736.45	737.2	291545.0
2026-06-24 04:00:00	QQQ	ETF	716.79	719.43	714.01	717.95	234714.0
2026-06-24 05:00:00	QQQ	ETF	718.19	718.5	716.48	717.75	55222.0
2026-06-24 06:00:00	QQQ	ETF	717.71	718.75	717.05	717.38	82118.0
2026-06-24 07:00:00	QQQ	ETF	717.39	719.1	716.0	718.93	238933.0
2026-06-24 08:00:00	QQQ	ETF	718.97	719.28	716.43	716.71	228807.0
2026-06-24 09:00:00	QQQ	ETF	716.71	718.4999	711.78	714.75	4905794.0
2026-06-24 10:00:00	QQQ	ETF	714.78	719.6	710.88	719.55	4720508.0
2026-06-24 11:00:00	QQQ	ETF	719.57	719.93	714.96	716.3	3198890.0
2026-06-24 12:00:00	QQQ	ETF	716.34	717.5	712.52	712.78	2340961.0
2026-06-24 13:00:00	QQQ	ETF	712.79	714.06	706.9662	707.46	4324612.0
2026-06-24 14:00:00	QQQ	ETF	707.47	711.6428	705.93	706.43	4176834.0
2026-06-24 15:00:00	QQQ	ETF	706.43	710.98	704.45	710.57	6927934.0
2026-06-24 16:00:00	QQQ	ETF	710.62	725.769	709.79	724.44	3259694.0
2026-06-24 17:00:00	QQQ	ETF	724.35	725.0	721.2	723.9	475987.0
2026-06-24 18:00:00	QQQ	ETF	724.0	725.99	723.28	723.3882	308690.0
2026-06-24 19:00:00	QQQ	ETF	723.45	725.3	723.26	724.54	157852.0
2026-06-24 04:00:00	IWM	ETF	295.32	296.25	295.12	295.65	52652.0
2026-06-24 05:00:00	IWM	ETF	295.65	295.87	295.27	295.57	17057.0
2026-06-24 06:00:00	IWM	ETF	295.38	296.23	295.38	295.74	43238.0
2026-06-24 07:00:00	IWM	ETF	295.75	297.0	295.68	296.75	110950.0
2026-06-24 08:00:00	IWM	ETF	296.73	296.75	295.88	296.01	68146.0
2026-06-24 09:00:00	IWM	ETF	296.04	297.6767	294.69	297.25	2909820.0
2026-06-24 10:00:00	IWM	ETF	297.26	299.14	295.6475	299.09	3248254.0
2026-06-24 11:00:00	IWM	ETF	299.1	299.69	298.695	299.01	2825018.0
2026-06-24 12:00:00	IWM	ETF	299.03	299.49	297.9	298.06	1949711.0
2026-06-24 13:00:00	IWM	ETF	298.08	298.38	295.73	295.98	3038298.0
2026-06-24 14:00:00	IWM	ETF	295.975	297.495	295.68	295.99	2262434.0
2026-06-24 15:00:00	IWM	ETF	296.0	296.79	295.09	296.72	4442501.0
2026-06-24 16:00:00	IWM	ETF	296.71	297.86	296.45	297.77	1018877.0
2026-06-24 17:00:00	IWM	ETF	297.72	297.8879	297.34	297.87	21263.0
2026-06-24 18:00:00	IWM	ETF	297.72	298.07	297.42	297.7	75865.0
2026-06-24 19:00:00	IWM	ETF	297.7	298.38	297.67	297.99	51088.0
2026-06-24 04:00:00	DIA	ETF	516.29	516.74	515.58	516.13	37480.0
2026-06-24 05:00:00	DIA	ETF	516.06	516.06	515.71	515.71	200.0

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

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