PREVIEW / etf_1hour / 2026-07-10

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-10.parquet
  size:    703 KB
  rows:    27,729

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-10 04:00:00	SPY	ETF	750.06	751.27	749.83	750.37	40164.0
2026-07-10 05:00:00	SPY	ETF	750.34	751.13	749.65	751.0	17637.0
2026-07-10 06:00:00	SPY	ETF	751.01	751.89	751.01	751.89	63316.0
2026-07-10 07:00:00	SPY	ETF	751.8414	752.05	750.94	751.15	148421.0
2026-07-10 08:00:00	SPY	ETF	751.2	752.3	750.56	751.6478	213622.0
2026-07-10 09:00:00	SPY	ETF	751.66	753.235	751.54	752.915	2756679.0
2026-07-10 10:00:00	SPY	ETF	752.92	753.35	748.1	751.2199	5848615.0
2026-07-10 11:00:00	SPY	ETF	751.18	753.42	750.652	752.8175	2543202.0
2026-07-10 12:00:00	SPY	ETF	752.81	754.14	752.81	754.01	2827666.0
2026-07-10 13:00:00	SPY	ETF	754.01	754.41	753.48	753.99	1968738.0
2026-07-10 14:00:00	SPY	ETF	754.0	754.72	753.93	754.495	2934312.0
2026-07-10 15:00:00	SPY	ETF	754.495	755.42	754.455	754.9	7956222.0
2026-07-10 16:00:00	SPY	ETF	754.87	755.65	754.56	755.45	3063185.0
2026-07-10 17:00:00	SPY	ETF	755.42	755.6	754.97	754.99	120979.0
2026-07-10 18:00:00	SPY	ETF	755.02	755.09	754.72	755.04	53321.0
2026-07-10 19:00:00	SPY	ETF	755.04	755.29	754.81	754.81	49239.0
2026-07-10 04:00:00	QQQ	ETF	719.44	723.41	718.58	719.3	227580.0
2026-07-10 05:00:00	QQQ	ETF	719.25	720.58	717.925	720.39	84561.0
2026-07-10 06:00:00	QQQ	ETF	720.45	721.41	720.09	721.13	102691.0
2026-07-10 07:00:00	QQQ	ETF	721.11	722.0	720.11	720.25	206526.0
2026-07-10 08:00:00	QQQ	ETF	720.3	721.83	719.2591	719.94	323095.0
2026-07-10 09:00:00	QQQ	ETF	719.94	724.09	719.68	722.81	2959585.0
2026-07-10 10:00:00	QQQ	ETF	722.8	723.8994	717.0	720.3499	4461292.0
2026-07-10 11:00:00	QQQ	ETF	720.31	724.34	719.35	723.24	3104819.0
2026-07-10 12:00:00	QQQ	ETF	723.29	725.58	723.29	725.2018	2301044.0
2026-07-10 13:00:00	QQQ	ETF	725.24	726.26	724.53	725.5	1570715.0
2026-07-10 14:00:00	QQQ	ETF	725.54	726.27	725.15	725.48	1169481.0
2026-07-10 15:00:00	QQQ	ETF	725.49	726.39	725.26	725.54	2781419.0
2026-07-10 16:00:00	QQQ	ETF	725.54	726.32	725.4	726.25	808832.0
2026-07-10 17:00:00	QQQ	ETF	726.22	726.25	725.8334	725.8334	36532.0
2026-07-10 18:00:00	QQQ	ETF	725.99	725.99	725.72	725.97	17465.0
2026-07-10 19:00:00	QQQ	ETF	725.97	726.4	725.8	726.3	21883.0
2026-07-10 04:00:00	IWM	ETF	296.76	297.12	296.45	296.55	10441.0
2026-07-10 05:00:00	IWM	ETF	296.5	296.88	296.36	296.81	4069.0
2026-07-10 06:00:00	IWM	ETF	296.94	297.18	296.81	297.06	18834.0
2026-07-10 07:00:00	IWM	ETF	297.1465	297.41	296.93	297.06	63336.0
2026-07-10 08:00:00	IWM	ETF	297.19	298.27	296.98	297.66	114535.0
2026-07-10 09:00:00	IWM	ETF	297.69	298.21	295.62	296.29	2013741.0
2026-07-10 10:00:00	IWM	ETF	296.3	296.46	293.62	294.83	3412689.0
2026-07-10 11:00:00	IWM	ETF	294.84	295.62	294.55	295.24	1512920.0
2026-07-10 12:00:00	IWM	ETF	295.26	295.81	294.95	295.78	840963.0
2026-07-10 13:00:00	IWM	ETF	295.78	296.42	295.55	296.1576	820914.0
2026-07-10 14:00:00	IWM	ETF	296.15	296.47	295.77	295.895	783379.0
2026-07-10 15:00:00	IWM	ETF	295.885	296.26	295.75	295.97	2465435.0
2026-07-10 16:00:00	IWM	ETF	295.95	296.25	295.82	296.09	937748.0
2026-07-10 17:00:00	IWM	ETF	296.1	296.18	296.0074	296.08	12451.0
2026-07-10 18:00:00	IWM	ETF	296.05	296.0799	295.9	295.92	2375.0
2026-07-10 19:00:00	IWM	ETF	295.91	296.09	295.91	295.92	2100.0
2026-07-10 04:00:00	DIA	ETF	523.94	525.34	523.84	524.62	16438.0
2026-07-10 05:00:00	DIA	ETF	524.61	524.98	524.61	524.81	835.0

> showing 50 of 27,729 rows — these rows as CSV

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