PREVIEW / etf_1hour / 2026-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-26.parquet
  size:    698 KB
  rows:    28,139

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-26 04:00:00	SPY	ETF	732.62	732.62	727.44	729.71	287408.0
2026-06-26 05:00:00	SPY	ETF	729.43	730.38	728.8	729.4	149980.0
2026-06-26 06:00:00	SPY	ETF	729.12	729.695	728.48	729.41	78606.0
2026-06-26 07:00:00	SPY	ETF	729.47	730.25	728.63	729.35	203638.0
2026-06-26 08:00:00	SPY	ETF	729.34	731.18	727.75	729.27	392148.0
2026-06-26 09:00:00	SPY	ETF	729.3	731.31	726.86	730.895	9361540.0
2026-06-26 10:00:00	SPY	ETF	730.87	734.2425	730.63	732.45	10348606.0
2026-06-26 11:00:00	SPY	ETF	732.46	736.53	731.62	735.4	8973724.0
2026-06-26 12:00:00	SPY	ETF	735.4	735.52	732.74	734.47	6270104.0
2026-06-26 13:00:00	SPY	ETF	734.48	735.86	733.47	733.66	5445870.0
2026-06-26 14:00:00	SPY	ETF	733.69	734.59	731.28	731.62	10313336.0
2026-06-26 15:00:00	SPY	ETF	731.63	733.86	716.58	729.09	26248646.0
2026-06-26 16:00:00	SPY	ETF	729.21	732.9088	728.23	730.57	14851284.0
2026-06-26 17:00:00	SPY	ETF	730.66	732.55	730.15	731.33	2363540.0
2026-06-26 18:00:00	SPY	ETF	731.44	731.76	731.05	731.33	164888.0
2026-06-26 19:00:00	SPY	ETF	731.3294	731.4	730.98	731.2006	68320.0
2026-06-26 04:00:00	QQQ	ETF	711.07	711.9	704.55	707.99	685306.0
2026-06-26 05:00:00	QQQ	ETF	707.66	709.07	706.76	707.48	315404.0
2026-06-26 06:00:00	QQQ	ETF	707.26	707.89	706.08	707.07	281158.0
2026-06-26 07:00:00	QQQ	ETF	707.17	708.71	705.86	706.8901	465790.0
2026-06-26 08:00:00	QQQ	ETF	706.66	715.843	705.68	706.0205	690200.0
2026-06-26 09:00:00	QQQ	ETF	706.12	709.65	702.81	709.12	9822518.0
2026-06-26 10:00:00	QQQ	ETF	709.14	714.33	708.62	710.51	11122362.0
2026-06-26 11:00:00	QQQ	ETF	710.56	715.555	708.22	713.21	7411746.0
2026-06-26 12:00:00	QQQ	ETF	713.25	713.84	710.27	713.045	4382274.0
2026-06-26 13:00:00	QQQ	ETF	713.07	715.1699	711.23	711.4	4002278.0
2026-06-26 14:00:00	QQQ	ETF	711.47	712.33	707.71	708.37	4959422.0
2026-06-26 15:00:00	QQQ	ETF	708.43	712.02	705.1	705.84	10846634.0
2026-06-26 16:00:00	QQQ	ETF	705.83	708.31	704.64	705.3	5583810.0
2026-06-26 17:00:00	QQQ	ETF	705.34	705.51	704.68	705.31	425150.0
2026-06-26 18:00:00	QQQ	ETF	705.33	706.52	705.31	706.3	159400.0
2026-06-26 19:00:00	QQQ	ETF	706.32	707.0	705.42	706.0	130194.0
2026-06-26 04:00:00	IWM	ETF	298.94	299.18	296.89	297.34	113544.0
2026-06-26 05:00:00	IWM	ETF	297.19	297.33	296.65	297.03	90056.0
2026-06-26 06:00:00	IWM	ETF	296.69	297.04	296.38	296.8	27666.0
2026-06-26 07:00:00	IWM	ETF	296.93	297.41	296.8	297.09	260232.0
2026-06-26 08:00:00	IWM	ETF	297.1701	297.92	296.5772	296.89	228062.0
2026-06-26 09:00:00	IWM	ETF	296.94	298.23	295.73	298.06	4662624.0
2026-06-26 10:00:00	IWM	ETF	298.14	299.5	297.885	298.16	4861592.0
2026-06-26 11:00:00	IWM	ETF	298.17	300.03	297.64	299.51	3668234.0
2026-06-26 12:00:00	IWM	ETF	299.53	299.55	297.63	298.41	4328204.0
2026-06-26 13:00:00	IWM	ETF	298.42	299.05	297.445	297.745	3343024.0
2026-06-26 14:00:00	IWM	ETF	297.76	298.19	296.481	296.58	4517248.0
2026-06-26 15:00:00	IWM	ETF	296.57	298.77	296.4	297.61	17986464.0
2026-06-26 16:00:00	IWM	ETF	297.66	299.83	297.66	298.27	14988426.0
2026-06-26 17:00:00	IWM	ETF	298.7	299.34	298.17	299.04	818726.0
2026-06-26 18:00:00	IWM	ETF	299.14	299.3	298.92	299.0	44362.0
2026-06-26 19:00:00	IWM	ETF	299.09	299.19	298.8	299.15	24420.0
2026-06-26 04:00:00	DIA	ETF	518.06	520.38	517.62	518.97	13798.0
2026-06-26 05:00:00	DIA	ETF	518.72	519.28	518.55	519.27	8750.0

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

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