PREVIEW / etf_1hour / 2026-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-06.parquet
  size:    713 KB
  rows:    28,094

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-07-06 04:00:00	SPY	ETF	747.5	748.81	746.25	748.47	56180.0
2026-07-06 05:00:00	SPY	ETF	748.47	748.76	748.0	748.75	32814.0
2026-07-06 06:00:00	SPY	ETF	748.72	748.85	748.21	748.46	28903.0
2026-07-06 07:00:00	SPY	ETF	748.501	748.7198	747.77	747.78	107304.0
2026-07-06 08:00:00	SPY	ETF	747.78	748.68	747.67	748.38	207119.0
2026-07-06 09:00:00	SPY	ETF	748.44	749.54	747.4	748.5	4446909.0
2026-07-06 10:00:00	SPY	ETF	748.54	750.275	747.97	750.275	4009857.0
2026-07-06 11:00:00	SPY	ETF	750.28	750.97	749.61	750.84	3974247.0
2026-07-06 12:00:00	SPY	ETF	750.83	751.12	750.37	750.46	2943062.0
2026-07-06 13:00:00	SPY	ETF	750.48	751.53	749.63	750.1299	2808059.0
2026-07-06 14:00:00	SPY	ETF	750.13	752.025	750.13	751.93	3227588.0
2026-07-06 15:00:00	SPY	ETF	751.94	752.41	750.77	751.3	11343939.0
2026-07-06 16:00:00	SPY	ETF	751.32	751.9	751.0465	751.67	2890079.0
2026-07-06 17:00:00	SPY	ETF	751.64	751.85	751.5647	751.8	52456.0
2026-07-06 18:00:00	SPY	ETF	751.8	752.15	751.35	751.48	57713.0
2026-07-06 19:00:00	SPY	ETF	751.55	751.85	750.52	750.66	39475.0
2026-07-06 04:00:00	QQQ	ETF	720.33	721.08	716.84	720.8	198028.0
2026-07-06 05:00:00	QQQ	ETF	720.65	721.14	719.74	720.94	54414.0
2026-07-06 06:00:00	QQQ	ETF	720.95	721.39	720.31	721.13	59475.0
2026-07-06 07:00:00	QQQ	ETF	721.1	721.79	720.13	720.98	168860.0
2026-07-06 08:00:00	QQQ	ETF	720.91	722.35	720.66	722.25	322394.0
2026-07-06 09:00:00	QQQ	ETF	722.22	723.99	718.45	722.18	4812790.0
2026-07-06 10:00:00	QQQ	ETF	722.27	725.4184	721.5	724.41	3744178.0
2026-07-06 11:00:00	QQQ	ETF	724.54	725.84	722.44	725.58	2553665.0
2026-07-06 12:00:00	QQQ	ETF	725.57	726.08	723.41	723.58	1444611.0
2026-07-06 13:00:00	QQQ	ETF	723.59	724.71	721.02	721.36	2445340.0
2026-07-06 14:00:00	QQQ	ETF	721.42	723.99	721.37	723.68	1647437.0
2026-07-06 15:00:00	QQQ	ETF	723.69	725.19	722.21	722.63	4572967.0
2026-07-06 16:00:00	QQQ	ETF	722.65	724.0	722.21	722.78	2044183.0
2026-07-06 17:00:00	QQQ	ETF	722.83	723.03	722.71	723.0	108544.0
2026-07-06 18:00:00	QQQ	ETF	722.96	723.21	721.2	721.5	145663.0
2026-07-06 19:00:00	QQQ	ETF	721.6	722.12	720.031	720.34	128388.0
2026-07-06 04:00:00	IWM	ETF	298.09	298.53	296.99	297.96	23479.0
2026-07-06 05:00:00	IWM	ETF	297.93	297.93	297.64	297.87	3562.0
2026-07-06 06:00:00	IWM	ETF	297.75	298.04	297.74	297.91	2554.0
2026-07-06 07:00:00	IWM	ETF	297.89	298.08	297.65	297.65	108230.0
2026-07-06 08:00:00	IWM	ETF	297.62	298.35	297.58	298.17	38627.0
2026-07-06 09:00:00	IWM	ETF	298.19	300.21	297.4	299.59	2619552.0
2026-07-06 10:00:00	IWM	ETF	299.61	299.83	298.54	299.815	2508917.0
2026-07-06 11:00:00	IWM	ETF	299.82	300.335	299.51	300.33	2159169.0
2026-07-06 12:00:00	IWM	ETF	300.3225	300.41	299.75	299.86	1736614.0
2026-07-06 13:00:00	IWM	ETF	299.86	300.29	299.25	299.625	2113047.0
2026-07-06 14:00:00	IWM	ETF	299.63	299.975	299.29	299.385	1002961.0
2026-07-06 15:00:00	IWM	ETF	299.4	299.59	298.71	298.88	2648760.0
2026-07-06 16:00:00	IWM	ETF	298.9	299.68	298.87	299.68	841514.0
2026-07-06 17:00:00	IWM	ETF	299.3195	299.89	299.3195	299.62	28145.0
2026-07-06 18:00:00	IWM	ETF	299.68	299.78	299.45	299.53	29130.0
2026-07-06 19:00:00	IWM	ETF	299.53	299.65	299.0	299.0859	17240.0
2026-07-06 04:00:00	DIA	ETF	529.05	529.19	527.62	528.45	4457.0
2026-07-06 05:00:00	DIA	ETF	528.37	528.39	527.97	528.22	1666.0

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

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