PREVIEW / etf_1hour / 2025-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-25.parquet
  size:    648 KB
  rows:    24,539

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-25 04:00:00	SPY	ETF	635.01	635.37	634.71	635.17	44309.0
2025-07-25 05:00:00	SPY	ETF	635.18	635.38	634.94	635.3	15510.0
2025-07-25 06:00:00	SPY	ETF	635.26	635.56	635.15	635.44	13599.0
2025-07-25 07:00:00	SPY	ETF	635.48	635.48	635.0	635.16	39338.0
2025-07-25 08:00:00	SPY	ETF	635.28	636.4	634.92	635.28	199268.0
2025-07-25 09:00:00	SPY	ETF	635.27	635.6	634.78	635.24	4325183.0
2025-07-25 10:00:00	SPY	ETF	635.25	636.13	634.87	635.825	5639265.0
2025-07-25 11:00:00	SPY	ETF	635.81	636.095	635.61	635.93	3317385.0
2025-07-25 12:00:00	SPY	ETF	635.93	636.96	635.79	636.845	4855893.0
2025-07-25 13:00:00	SPY	ETF	636.845	637.36	636.67	637.1314	3413586.0
2025-07-25 14:00:00	SPY	ETF	637.132	637.54	636.97	637.195	3867567.0
2025-07-25 15:00:00	SPY	ETF	637.19	637.5799	636.625	637.03	10768472.0
2025-07-25 16:00:00	SPY	ETF	637.02	637.3846	636.6	637.25	2927436.0
2025-07-25 17:00:00	SPY	ETF	637.18	637.28	637.07	637.2699	75056.0
2025-07-25 18:00:00	SPY	ETF	637.3	637.35	637.2501	637.35	11638.0
2025-07-25 19:00:00	SPY	ETF	637.3298	637.5	637.31	637.4598	10253.0
2025-07-25 04:00:00	QQQ	ETF	565.08	565.43	564.79	565.3	18698.0
2025-07-25 05:00:00	QQQ	ETF	565.27	565.3	564.86	565.25	20967.0
2025-07-25 06:00:00	QQQ	ETF	565.26	565.68	565.19	565.59	16417.0
2025-07-25 07:00:00	QQQ	ETF	565.62	565.63	565.0	565.09	28392.0
2025-07-25 08:00:00	QQQ	ETF	565.33	566.55	564.587	565.2299	168791.0
2025-07-25 09:00:00	QQQ	ETF	565.21	566.11	564.27	565.652	3727017.0
2025-07-25 10:00:00	QQQ	ETF	565.68	566.37	565.53	566.02	3674796.0
2025-07-25 11:00:00	QQQ	ETF	566.02	566.54	565.73	566.3901	2242228.0
2025-07-25 12:00:00	QQQ	ETF	566.39	567.695	566.29	567.1	2813020.0
2025-07-25 13:00:00	QQQ	ETF	567.09	567.209	566.672	566.82	1467084.0
2025-07-25 14:00:00	QQQ	ETF	566.83	567.32	566.55	566.915	1546677.0
2025-07-25 15:00:00	QQQ	ETF	566.9	567.2004	566.06	566.39	3888452.0
2025-07-25 16:00:00	QQQ	ETF	566.38	566.99	565.96	566.97	1565607.0
2025-07-25 17:00:00	QQQ	ETF	566.88	566.8899	566.73	566.81	8524.0
2025-07-25 18:00:00	QQQ	ETF	566.86	567.0193	566.7946	566.8802	18626.0
2025-07-25 19:00:00	QQQ	ETF	566.91	567.06	566.9	567.04	15274.0
2025-07-25 04:00:00	IWM	ETF	224.08	224.12	223.76	224.03	15499.0
2025-07-25 05:00:00	IWM	ETF	223.92	224.05	223.81	223.97	11143.0
2025-07-25 06:00:00	IWM	ETF	224.0	224.31	223.98	224.15	11487.0
2025-07-25 07:00:00	IWM	ETF	224.13	224.13	223.92	224.0	16721.0
2025-07-25 08:00:00	IWM	ETF	223.87	224.63	223.72	224.4	144347.0
2025-07-25 09:00:00	IWM	ETF	224.37	224.71	222.695	223.28	3550195.0
2025-07-25 10:00:00	IWM	ETF	223.3	223.54	222.54	223.05	3508764.0
2025-07-25 11:00:00	IWM	ETF	223.06	223.435	222.89	223.42	2023197.0
2025-07-25 12:00:00	IWM	ETF	223.42	223.87	223.06	223.8033	2123888.0
2025-07-25 13:00:00	IWM	ETF	223.815	224.235	223.755	224.035	1503336.0
2025-07-25 14:00:00	IWM	ETF	224.04	224.405	223.98	224.26	1258972.0
2025-07-25 15:00:00	IWM	ETF	224.255	224.595	224.14	224.4	3037025.0
2025-07-25 16:00:00	IWM	ETF	224.38	224.45	224.21	224.42	660973.0
2025-07-25 17:00:00	IWM	ETF	224.43	224.43	224.27	224.29	2749.0
2025-07-25 18:00:00	IWM	ETF	224.31	224.37	224.29	224.36	10841.0
2025-07-25 19:00:00	IWM	ETF	224.29	224.4	224.29	224.31	1905.0
2025-07-25 04:00:00	DIA	ETF	447.48	447.81	447.48	447.81	1300.0
2025-07-25 05:00:00	DIA	ETF	447.66	447.66	447.61	447.61	400.0

> showing 50 of 24,539 rows — these rows as CSV

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