PREVIEW / etf_1hour / 2026-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-30.parquet
  size:    712 KB
  rows:    28,265

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-30 04:00:00	SPY	ETF	742.0	742.74	740.74	741.5	82823.0
2026-06-30 05:00:00	SPY	ETF	741.47	742.05	741.14	741.98	9966.0
2026-06-30 06:00:00	SPY	ETF	741.89	742.66	741.74	742.65	15269.0
2026-06-30 07:00:00	SPY	ETF	742.5278	743.0	742.2	742.34	120264.0
2026-06-30 08:00:00	SPY	ETF	742.3	742.4	740.4925	741.0	257972.0
2026-06-30 09:00:00	SPY	ETF	741.0	743.96	740.56	743.92	4394597.0
2026-06-30 10:00:00	SPY	ETF	743.91	745.38	742.86	743.3199	3885591.0
2026-06-30 11:00:00	SPY	ETF	743.32	746.0	743.24	745.79	2904749.0
2026-06-30 12:00:00	SPY	ETF	745.8	747.04	745.76	746.77	3059566.0
2026-06-30 13:00:00	SPY	ETF	746.78	747.14	746.15	746.49	2394578.0
2026-06-30 14:00:00	SPY	ETF	746.49	747.44	746.32	747.13	3010218.0
2026-06-30 15:00:00	SPY	ETF	747.13	748.02	746.3	746.32	12465851.0
2026-06-30 16:00:00	SPY	ETF	746.36	747.1341	745.56	745.86	3921694.0
2026-06-30 17:00:00	SPY	ETF	745.86	746.18	745.79	745.97	118650.0
2026-06-30 18:00:00	SPY	ETF	745.95	746.68	745.88	746.0	117340.0
2026-06-30 19:00:00	SPY	ETF	746.01	746.4	745.89	746.3	37693.0
2026-06-30 04:00:00	QQQ	ETF	724.96	728.26	723.54	724.69	231030.0
2026-06-30 05:00:00	QQQ	ETF	724.79	725.32	724.0	725.05	34621.0
2026-06-30 06:00:00	QQQ	ETF	725.07	726.72	724.76	726.51	56943.0
2026-06-30 07:00:00	QQQ	ETF	726.43	727.27	725.87	726.41	209205.0
2026-06-30 08:00:00	QQQ	ETF	726.4	726.52	723.21	723.38	458322.0
2026-06-30 09:00:00	QQQ	ETF	723.51	731.94	723.0	731.8701	4637401.0
2026-06-30 10:00:00	QQQ	ETF	731.89	733.775	729.72	730.47	4513044.0
2026-06-30 11:00:00	QQQ	ETF	730.5	734.7198	730.37	734.229	2759103.0
2026-06-30 12:00:00	QQQ	ETF	734.22	736.35	734.03	735.82	1779952.0
2026-06-30 13:00:00	QQQ	ETF	735.85	736.68	735.5705	735.78	2008666.0
2026-06-30 14:00:00	QQQ	ETF	735.81	736.99	735.175	736.49	2144984.0
2026-06-30 15:00:00	QQQ	ETF	736.48	737.62	735.76	735.76	8698614.0
2026-06-30 16:00:00	QQQ	ETF	735.77	736.44	735.1701	735.41	3015940.0
2026-06-30 17:00:00	QQQ	ETF	735.5182	736.43	735.33	735.65	206059.0
2026-06-30 18:00:00	QQQ	ETF	735.59	736.35	735.3	735.67	219925.0
2026-06-30 19:00:00	QQQ	ETF	735.75	736.5	735.75	736.29	63599.0
2026-06-30 04:00:00	IWM	ETF	299.07	299.5	298.51	298.9	17763.0
2026-06-30 05:00:00	IWM	ETF	299.0	299.38	298.79	299.34	7670.0
2026-06-30 06:00:00	IWM	ETF	299.2975	299.65	299.25	299.63	14559.0
2026-06-30 07:00:00	IWM	ETF	299.54	299.61	299.01	299.08	46826.0
2026-06-30 08:00:00	IWM	ETF	299.05	299.05	298.16	298.46	71730.0
2026-06-30 09:00:00	IWM	ETF	298.54	299.15	297.44	298.88	2828797.0
2026-06-30 10:00:00	IWM	ETF	298.83	300.15	298.37	298.81	2548874.0
2026-06-30 11:00:00	IWM	ETF	298.82	300.045	298.805	299.45	1357644.0
2026-06-30 12:00:00	IWM	ETF	299.445	300.47	299.41	300.33	1460527.0
2026-06-30 13:00:00	IWM	ETF	300.32	300.86	300.185	300.54	1146039.0
2026-06-30 14:00:00	IWM	ETF	300.55	300.76	300.17	300.485	1944631.0
2026-06-30 15:00:00	IWM	ETF	300.48	300.98	300.22	300.42	4547037.0
2026-06-30 16:00:00	IWM	ETF	300.45	300.52	299.9	299.99	1940060.0
2026-06-30 17:00:00	IWM	ETF	300.09	300.34	299.72	299.85	622976.0
2026-06-30 18:00:00	IWM	ETF	299.87	300.13	299.81	299.93	36350.0
2026-06-30 19:00:00	IWM	ETF	299.9	300.05	299.85	299.9387	56878.0
2026-06-30 04:00:00	DIA	ETF	522.45	522.7	521.42	522.03	31872.0
2026-06-30 05:00:00	DIA	ETF	522.3	523.0	522.25	522.89	6626.0

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

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