PREVIEW / etf_1hour / 2025-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-29.parquet
  size:    697 KB
  rows:    27,351

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-09-29 04:00:00	SPY	ETF	664.57	665.26	664.12	665.23	50334.0
2025-09-29 05:00:00	SPY	ETF	665.22	665.5	665.03	665.04	39689.0
2025-09-29 06:00:00	SPY	ETF	665.06	665.8	664.98	665.35	141716.0
2025-09-29 07:00:00	SPY	ETF	665.4	665.47	664.49	664.96	141892.0
2025-09-29 08:00:00	SPY	ETF	665.38	665.7	663.71	665.43	225656.0
2025-09-29 09:00:00	SPY	ETF	665.45	665.67	663.725	664.525	6784238.0
2025-09-29 10:00:00	SPY	ETF	664.53	665.28	663.99	664.46	7017144.0
2025-09-29 11:00:00	SPY	ETF	664.45	664.6573	662.84	663.31	6993104.0
2025-09-29 12:00:00	SPY	ETF	663.31	663.8	662.85	663.04	3750474.0
2025-09-29 13:00:00	SPY	ETF	663.05	663.09	662.19	662.94	5053735.0
2025-09-29 14:00:00	SPY	ETF	662.94	663.595	662.9	663.35	4985597.0
2025-09-29 15:00:00	SPY	ETF	663.345	663.76	661.86	663.61	14995664.0
2025-09-29 16:00:00	SPY	ETF	663.61	663.76	662.88	663.05	2570926.0
2025-09-29 17:00:00	SPY	ETF	663.04	663.1099	662.88	663.02	48403.0
2025-09-29 18:00:00	SPY	ETF	663.02	663.5492	662.94	663.5	47049.0
2025-09-29 19:00:00	SPY	ETF	663.5	663.66	663.27	663.34	40829.0
2025-09-29 20:00:00	SPY	ETF	663.32	663.32	663.32	663.32	200.0
2025-09-29 04:00:00	QQQ	ETF	599.2	600.2	599.0	600.15	81327.0
2025-09-29 05:00:00	QQQ	ETF	600.19	600.29	599.67	599.67	51395.0
2025-09-29 06:00:00	QQQ	ETF	599.68	600.35	599.54	600.06	55046.0
2025-09-29 07:00:00	QQQ	ETF	600.06	600.12	599.21	599.71	126210.0
2025-09-29 08:00:00	QQQ	ETF	600.1	600.49	595.524	600.2743	284774.0
2025-09-29 09:00:00	QQQ	ETF	600.29	601.57	599.04	601.26	5892664.0
2025-09-29 10:00:00	QQQ	ETF	601.26	602.05	600.68	600.945	5479655.0
2025-09-29 11:00:00	QQQ	ETF	600.94	601.278	598.64	599.07	4898594.0
2025-09-29 12:00:00	QQQ	ETF	599.06	599.53	598.45	598.74	3594105.0
2025-09-29 13:00:00	QQQ	ETF	598.74	599.09	597.91	598.98	3216998.0
2025-09-29 14:00:00	QQQ	ETF	598.99	599.56	598.73	598.92	2758930.0
2025-09-29 15:00:00	QQQ	ETF	598.91	599.06	597.41	598.75	7478404.0
2025-09-29 16:00:00	QQQ	ETF	598.76	598.95	598.01	598.16	1012068.0
2025-09-29 17:00:00	QQQ	ETF	598.1	598.17	598.05	598.15	22824.0
2025-09-29 18:00:00	QQQ	ETF	598.15	598.7	598.07	598.67	54745.0
2025-09-29 19:00:00	QQQ	ETF	598.62	598.8139	598.39	598.39	37264.0
2025-09-29 04:00:00	IWM	ETF	242.5	243.03	242.41	242.96	38515.0
2025-09-29 05:00:00	IWM	ETF	242.98	243.07	242.88	242.91	18792.0
2025-09-29 06:00:00	IWM	ETF	242.87	243.25	242.87	243.03	20844.0
2025-09-29 07:00:00	IWM	ETF	243.0	243.04	242.65	242.79	26656.0
2025-09-29 08:00:00	IWM	ETF	242.8	243.12	242.03	242.92	91992.0
2025-09-29 09:00:00	IWM	ETF	242.91	243.03	241.16	241.955	3239401.0
2025-09-29 10:00:00	IWM	ETF	241.95	242.26	241.315	241.37	3071984.0
2025-09-29 11:00:00	IWM	ETF	241.37	241.72	241.0	241.42	2519750.0
2025-09-29 12:00:00	IWM	ETF	241.42	241.685	241.1	241.32	1695575.0
2025-09-29 13:00:00	IWM	ETF	241.34	241.44	240.81	241.415	1926210.0
2025-09-29 14:00:00	IWM	ETF	241.42	241.77	241.33	241.59	1483328.0
2025-09-29 15:00:00	IWM	ETF	241.58	241.85	240.895	241.59	4610788.0
2025-09-29 16:00:00	IWM	ETF	241.62	241.64	241.07	241.27	1100461.0
2025-09-29 17:00:00	IWM	ETF	241.24	241.4	241.2028	241.3	10823.0
2025-09-29 18:00:00	IWM	ETF	241.4	241.54	241.23	241.54	13080.0
2025-09-29 19:00:00	IWM	ETF	241.48	241.6	241.39	241.39	6860.0
2025-09-29 04:00:00	DIA	ETF	464.04	464.04	463.82	463.92	500.0

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

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