PREVIEW / etf_1hour / 2025-07-03

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-03.parquet
  size:    470 KB
  rows:    17,085

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
2025-07-03 04:00:00	SPY	ETF	621.22	621.37	620.69	620.69	28267.0
2025-07-03 05:00:00	SPY	ETF	620.68	621.2	620.68	620.78	17736.0
2025-07-03 06:00:00	SPY	ETF	620.84	621.0	620.51	620.97	14297.0
2025-07-03 07:00:00	SPY	ETF	620.96	621.27	620.88	621.25	112929.0
2025-07-03 08:00:00	SPY	ETF	621.12	622.82	620.81	621.66	926788.0
2025-07-03 09:00:00	SPY	ETF	621.68	624.545	621.68	624.07	6826302.0
2025-07-03 10:00:00	SPY	ETF	624.06	625.47	624.04	625.3	7067375.0
2025-07-03 11:00:00	SPY	ETF	625.31	626.08	625.17	625.9	6114555.0
2025-07-03 12:00:00	SPY	ETF	625.902	626.28	624.87	625.35	11439676.0
2025-07-03 13:00:00	SPY	ETF	625.35	625.72	624.5	624.94	2286324.0
2025-07-03 14:00:00	SPY	ETF	624.95	625.0	624.79	624.8	302548.0
2025-07-03 15:00:00	SPY	ETF	624.79	625.34	624.79	625.13	1114075.0
2025-07-03 16:00:00	SPY	ETF	625.12	625.12	624.8207	625.01	62115.0
2025-07-03 04:00:00	QQQ	ETF	552.05	552.27	551.38	551.38	28811.0
2025-07-03 05:00:00	QQQ	ETF	551.22	551.79	551.2	551.22	29445.0
2025-07-03 06:00:00	QQQ	ETF	551.26	551.39	550.8	551.35	31216.0
2025-07-03 07:00:00	QQQ	ETF	551.34	551.68	551.29	551.54	52026.0
2025-07-03 08:00:00	QQQ	ETF	551.49	553.25	550.98	552.26	418937.0
2025-07-03 09:00:00	QQQ	ETF	552.28	554.94	552.28	554.75	4535501.0
2025-07-03 10:00:00	QQQ	ETF	554.74	556.37	554.74	555.9107	4634481.0
2025-07-03 11:00:00	QQQ	ETF	555.92	557.2	555.905	556.78	3054492.0
2025-07-03 12:00:00	QQQ	ETF	556.7891	557.05	555.48	556.16	4001429.0
2025-07-03 13:00:00	QQQ	ETF	556.2	556.5932	555.6	555.78	1138670.0
2025-07-03 14:00:00	QQQ	ETF	555.79	555.92	555.73	555.75	112431.0
2025-07-03 15:00:00	QQQ	ETF	555.79	555.93	555.7	555.83	54968.0
2025-07-03 16:00:00	QQQ	ETF	555.89	555.91	555.72	555.81	55449.0
2025-07-03 04:00:00	IWM	ETF	222.0	222.3	221.85	222.0	41373.0
2025-07-03 05:00:00	IWM	ETF	222.0	222.68	221.97	222.43	43960.0
2025-07-03 06:00:00	IWM	ETF	222.45	222.6	222.3	222.48	32302.0
2025-07-03 07:00:00	IWM	ETF	222.47	222.99	222.41	222.85	103735.0
2025-07-03 08:00:00	IWM	ETF	222.55	224.51	221.72	221.8	763584.0
2025-07-03 09:00:00	IWM	ETF	221.8	223.0	221.73	222.318	3828563.0
2025-07-03 10:00:00	IWM	ETF	222.35	223.27	222.265	222.96	4181042.0
2025-07-03 11:00:00	IWM	ETF	222.96	223.33	222.49	222.91	2689509.0
2025-07-03 12:00:00	IWM	ETF	222.91	223.28	222.61	223.09	4226214.0
2025-07-03 13:00:00	IWM	ETF	223.08	223.33	222.61	222.74	939675.0
2025-07-03 14:00:00	IWM	ETF	222.77	223.03	222.74	222.99	59068.0
2025-07-03 15:00:00	IWM	ETF	222.99	223.19	222.8	223.09	321685.0
2025-07-03 16:00:00	IWM	ETF	223.09	223.15	222.83	222.9714	7714.0
2025-07-03 06:00:00	DIA	ETF	445.0	445.0	445.0	445.0	290.0
2025-07-03 07:00:00	DIA	ETF	445.33	445.37	445.15	445.19	3797.0
2025-07-03 08:00:00	DIA	ETF	445.3799	446.42	445.2312	445.36	17672.0
2025-07-03 09:00:00	DIA	ETF	445.4899	447.63	445.4	447.1446	901517.0
2025-07-03 10:00:00	DIA	ETF	447.25	448.7969	447.13	448.36	446460.0
2025-07-03 11:00:00	DIA	ETF	448.38	448.74	447.78	448.4	242652.0
2025-07-03 12:00:00	DIA	ETF	448.39	448.86	447.96	448.06	481012.0
2025-07-03 13:00:00	DIA	ETF	448.06	448.36	447.88	447.88	61544.0
2025-07-03 14:00:00	DIA	ETF	448.07	448.3622	448.07	448.3622	2110.0
2025-07-03 15:00:00	DIA	ETF	448.18	448.68	448.18	448.2	2189.0
2025-07-03 16:00:00	DIA	ETF	448.2	448.33	448.2	448.33	583.0

> showing 50 of 17,085 rows — these rows as CSV

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