PREVIEW / etf_1hour / 2025-07-24

all etf 1-hour files

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

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-24 04:00:00	SPY	ETF	633.95	634.59	633.8	634.49	22159.0
2025-07-24 05:00:00	SPY	ETF	634.45	634.81	634.38	634.81	10179.0
2025-07-24 06:00:00	SPY	ETF	634.73	634.83	634.0	634.24	13207.0
2025-07-24 07:00:00	SPY	ETF	634.28	635.02	634.2	634.79	79230.0
2025-07-24 08:00:00	SPY	ETF	634.31	635.01	633.53	634.17	465656.0
2025-07-24 09:00:00	SPY	ETF	634.19	635.39	633.85	635.065	5811248.0
2025-07-24 10:00:00	SPY	ETF	635.11	635.62	634.07	635.51	6615278.0
2025-07-24 11:00:00	SPY	ETF	635.52	635.89	635.25	635.54	4872421.0
2025-07-24 12:00:00	SPY	ETF	635.53	635.58	634.28	634.885	5099257.0
2025-07-24 13:00:00	SPY	ETF	634.88	635.98	634.76	635.245	4252736.0
2025-07-24 14:00:00	SPY	ETF	635.25	636.15	634.69	635.2299	8578647.0
2025-07-24 15:00:00	SPY	ETF	635.22	635.755	634.25	634.43	12246409.0
2025-07-24 16:00:00	SPY	ETF	634.44	635.2392	634.25	634.92	2507211.0
2025-07-24 17:00:00	SPY	ETF	634.91	635.07	634.9	634.93	26722.0
2025-07-24 18:00:00	SPY	ETF	635.0	635.54	634.88	635.31	62934.0
2025-07-24 19:00:00	SPY	ETF	635.2504	635.49	635.06	635.44	22187.0
2025-07-24 04:00:00	QQQ	ETF	565.0	565.63	564.47	565.47	36006.0
2025-07-24 05:00:00	QQQ	ETF	565.54	565.65	565.35	565.55	13886.0
2025-07-24 06:00:00	QQQ	ETF	565.55	565.59	564.91	565.13	22491.0
2025-07-24 07:00:00	QQQ	ETF	565.1	565.829	564.96	565.4	79123.0
2025-07-24 08:00:00	QQQ	ETF	565.2	565.7486	564.01	564.76	405930.0
2025-07-24 09:00:00	QQQ	ETF	564.79	565.77	563.87	564.85	4367531.0
2025-07-24 10:00:00	QQQ	ETF	564.88	565.29	563.295	565.07	4159329.0
2025-07-24 11:00:00	QQQ	ETF	565.08	565.72	564.9748	565.42	2967381.0
2025-07-24 12:00:00	QQQ	ETF	565.395	565.43	564.27	565.01	2917406.0
2025-07-24 13:00:00	QQQ	ETF	565.0	566.23	564.91	565.32	2421106.0
2025-07-24 14:00:00	QQQ	ETF	565.3293	566.23	565.15	565.71	3220371.0
2025-07-24 15:00:00	QQQ	ETF	565.715	566.24	564.98	565.09	7151947.0
2025-07-24 16:00:00	QQQ	ETF	565.09	565.68	564.85	565.56	1022916.0
2025-07-24 17:00:00	QQQ	ETF	565.3732	565.5699	565.3732	565.4125	12445.0
2025-07-24 18:00:00	QQQ	ETF	565.51	566.02	565.36	565.72	67791.0
2025-07-24 19:00:00	QQQ	ETF	565.68	565.91	565.47	565.81	39793.0
2025-07-24 04:00:00	IWM	ETF	225.75	226.12	225.53	226.06	18454.0
2025-07-24 05:00:00	IWM	ETF	225.99	226.11	225.9	225.99	14773.0
2025-07-24 06:00:00	IWM	ETF	226.04	226.1	225.6	225.76	41533.0
2025-07-24 07:00:00	IWM	ETF	225.74	226.13	225.71	226.0	25925.0
2025-07-24 08:00:00	IWM	ETF	225.85	226.3	225.6	225.6797	135890.0
2025-07-24 09:00:00	IWM	ETF	225.68	225.8499	225.0279	225.41	3272185.0
2025-07-24 10:00:00	IWM	ETF	225.42	225.665	224.62	225.345	3382585.0
2025-07-24 11:00:00	IWM	ETF	225.34	225.49	224.48	224.65	2533569.0
2025-07-24 12:00:00	IWM	ETF	224.66	224.7399	223.875	224.06	2311079.0
2025-07-24 13:00:00	IWM	ETF	224.065	224.64	223.97	224.48	1506376.0
2025-07-24 14:00:00	IWM	ETF	224.48	224.6701	223.95	224.215	1850906.0
2025-07-24 15:00:00	IWM	ETF	224.215	224.435	223.48	223.58	4516792.0
2025-07-24 16:00:00	IWM	ETF	223.55	224.74	223.48	223.95	1317748.0
2025-07-24 17:00:00	IWM	ETF	223.86	223.91	223.77	223.78	19609.0
2025-07-24 18:00:00	IWM	ETF	223.9	224.2	223.86	224.0	97331.0
2025-07-24 19:00:00	IWM	ETF	224.03	224.27	223.956	224.2499	23268.0
2025-07-24 04:00:00	DIA	ETF	448.52	448.94	448.52	448.85	4403.0
2025-07-24 05:00:00	DIA	ETF	448.75	448.88	448.7	448.8	2525.0

> showing 50 of 25,194 rows — these rows as CSV

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