PREVIEW / etf_1hour / 2026-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-29.parquet
  size:    716 KB
  rows:    28,330

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-29 04:00:00	SPY	ETF	736.02	737.0001	734.52	735.96	147547.0
2026-06-29 05:00:00	SPY	ETF	735.86	736.7	735.57	736.28	46632.0
2026-06-29 06:00:00	SPY	ETF	736.34	737.45	736.08	737.45	31987.0
2026-06-29 07:00:00	SPY	ETF	737.38	738.1	736.5	737.0655	232070.0
2026-06-29 08:00:00	SPY	ETF	737.03	737.61	736.31	737.171	230426.0
2026-06-29 09:00:00	SPY	ETF	737.271	739.895	735.3	736.8899	4953389.0
2026-06-29 10:00:00	SPY	ETF	736.87	738.32	732.09	737.86	7622774.0
2026-06-29 11:00:00	SPY	ETF	737.88	738.58	736.33	738.51	3267374.0
2026-06-29 12:00:00	SPY	ETF	738.54	739.13	737.97	738.68	2549702.0
2026-06-29 13:00:00	SPY	ETF	738.69	740.82	738.69	740.41	2651252.0
2026-06-29 14:00:00	SPY	ETF	740.4	741.19	740.12	740.685	3009939.0
2026-06-29 15:00:00	SPY	ETF	740.69	741.56	740.23	740.88	10840371.0
2026-06-29 16:00:00	SPY	ETF	740.85	741.2041	740.0	740.57	3091185.0
2026-06-29 17:00:00	SPY	ETF	740.5301	740.83	740.5	740.79	70057.0
2026-06-29 18:00:00	SPY	ETF	740.65	740.89	740.27	740.67	36427.0
2026-06-29 19:00:00	SPY	ETF	740.51	741.0	740.44	740.76	24959.0
2026-06-29 04:00:00	QQQ	ETF	714.52	716.04	710.4	714.56	397818.0
2026-06-29 05:00:00	QQQ	ETF	714.34	715.074	713.5	714.58	79582.0
2026-06-29 06:00:00	QQQ	ETF	714.64	716.44	714.64	716.35	70411.0
2026-06-29 07:00:00	QQQ	ETF	716.3	716.8	714.88	715.46	341991.0
2026-06-29 08:00:00	QQQ	ETF	715.29	716.16	705.991	715.32	290339.0
2026-06-29 09:00:00	QQQ	ETF	715.39	718.66	711.88	713.3899	4912399.0
2026-06-29 10:00:00	QQQ	ETF	713.46	715.96	705.172	715.93	7866642.0
2026-06-29 11:00:00	QQQ	ETF	715.93	719.06	714.54	718.949	4116494.0
2026-06-29 12:00:00	QQQ	ETF	718.92	721.12	718.78	720.7088	2701461.0
2026-06-29 13:00:00	QQQ	ETF	720.71	723.63	720.67	722.8202	2601601.0
2026-06-29 14:00:00	QQQ	ETF	722.8395	724.42	722.43	723.53	2314324.0
2026-06-29 15:00:00	QQQ	ETF	723.53	724.58	722.24	723.95	5341095.0
2026-06-29 16:00:00	QQQ	ETF	723.97	724.11	722.81	722.9	1740004.0
2026-06-29 17:00:00	QQQ	ETF	722.94	723.49	722.7039	723.16	67405.0
2026-06-29 18:00:00	QQQ	ETF	723.06	723.76	722.35	723.2002	155453.0
2026-06-29 19:00:00	QQQ	ETF	723.27	724.24	723.15	724.0	247010.0
2026-06-29 04:00:00	IWM	ETF	298.87	299.51	298.12	298.69	96765.0
2026-06-29 05:00:00	IWM	ETF	298.51	299.16	298.43	298.8	76736.0
2026-06-29 06:00:00	IWM	ETF	298.89	299.29	298.6	299.29	20578.0
2026-06-29 07:00:00	IWM	ETF	299.35	299.7	298.99	299.34	102255.0
2026-06-29 08:00:00	IWM	ETF	299.47	299.84	299.07	299.36	76987.0
2026-06-29 09:00:00	IWM	ETF	299.44	299.55	296.91	297.24	4214238.0
2026-06-29 10:00:00	IWM	ETF	297.26	297.6	294.68	297.11	4161122.0
2026-06-29 11:00:00	IWM	ETF	297.11	297.34	295.24	296.47	2280143.0
2026-06-29 12:00:00	IWM	ETF	296.47	297.305	296.33	297.05	1429181.0
2026-06-29 13:00:00	IWM	ETF	297.05	298.04	297.03	297.78	1646318.0
2026-06-29 14:00:00	IWM	ETF	297.78	298.425	297.61	298.27	1471207.0
2026-06-29 15:00:00	IWM	ETF	298.28	299.09	297.975	298.95	3395289.0
2026-06-29 16:00:00	IWM	ETF	298.97	299.18	298.41	298.58	1400329.0
2026-06-29 17:00:00	IWM	ETF	298.61	298.66	298.37	298.6	10070.0
2026-06-29 18:00:00	IWM	ETF	298.4604	298.6	298.31	298.47	49351.0
2026-06-29 19:00:00	IWM	ETF	298.5	298.74	298.4	298.54	13396.0
2026-06-29 04:00:00	DIA	ETF	519.33	520.53	519.27	520.02	10808.0
2026-06-29 05:00:00	DIA	ETF	519.68	520.13	519.43	519.75	4528.0

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

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