PREVIEW / etf_1hour / 2025-09-25

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-25.parquet
  size:    690 KB
  rows:    27,159

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-25 04:00:00	SPY	ETF	661.25	661.6	660.72	660.82	9092.0
2025-09-25 05:00:00	SPY	ETF	660.94	661.1	660.4	660.55	17742.0
2025-09-25 06:00:00	SPY	ETF	660.6	660.84	659.96	660.27	73118.0
2025-09-25 07:00:00	SPY	ETF	660.2	660.2	658.24	658.44	168626.0
2025-09-25 08:00:00	SPY	ETF	660.09	662.38	657.32	657.78	712087.0
2025-09-25 09:00:00	SPY	ETF	657.8	658.21	655.08	655.64	11068417.0
2025-09-25 10:00:00	SPY	ETF	655.64	659.15	655.55	658.79	10459869.0
2025-09-25 11:00:00	SPY	ETF	658.79	659.4056	657.19	658.945	7546910.0
2025-09-25 12:00:00	SPY	ETF	658.945	659.235	657.59	657.84	4753911.0
2025-09-25 13:00:00	SPY	ETF	657.83	658.36	655.51	655.59	5968165.0
2025-09-25 14:00:00	SPY	ETF	655.59	658.155	654.405	657.89	10717593.0
2025-09-25 15:00:00	SPY	ETF	657.88	658.26	657.04	657.95	9933709.0
2025-09-25 16:00:00	SPY	ETF	657.95	658.53	657.7	658.08	2093611.0
2025-09-25 17:00:00	SPY	ETF	658.07	658.0766	657.86	658.0	140084.0
2025-09-25 18:00:00	SPY	ETF	658.0	658.69	657.94	658.1504	78297.0
2025-09-25 19:00:00	SPY	ETF	658.1599	658.1738	657.81	657.83	123039.0
2025-09-25 04:00:00	QQQ	ETF	596.14	596.7	595.65	595.91	34295.0
2025-09-25 05:00:00	QQQ	ETF	595.88	596.04	594.98	595.26	86920.0
2025-09-25 06:00:00	QQQ	ETF	595.32	595.47	594.5	594.89	59549.0
2025-09-25 07:00:00	QQQ	ETF	594.93	594.98	592.5	592.61	175201.0
2025-09-25 08:00:00	QQQ	ETF	594.55	597.29	591.46	592.0	814154.0
2025-09-25 09:00:00	QQQ	ETF	591.93	592.43	588.5	589.23	10333087.0
2025-09-25 10:00:00	QQQ	ETF	589.23	594.139	589.07	593.6271	9422765.0
2025-09-25 11:00:00	QQQ	ETF	593.63	595.115	592.39	594.665	6570325.0
2025-09-25 12:00:00	QQQ	ETF	594.66	595.0	593.1	593.3844	4348114.0
2025-09-25 13:00:00	QQQ	ETF	593.38	593.85	590.6593	590.78	5640640.0
2025-09-25 14:00:00	QQQ	ETF	590.79	593.74	589.26	593.44	8291067.0
2025-09-25 15:00:00	QQQ	ETF	593.44	593.86	592.585	593.55	6717084.0
2025-09-25 16:00:00	QQQ	ETF	593.54	593.92	593.05	593.65	2376312.0
2025-09-25 17:00:00	QQQ	ETF	593.6	593.64	593.37	593.4601	19410.0
2025-09-25 18:00:00	QQQ	ETF	593.52	594.3	593.48	593.72	71333.0
2025-09-25 19:00:00	QQQ	ETF	593.67	593.73	593.1686	593.1686	51543.0
2025-09-25 04:00:00	IWM	ETF	241.98	242.06	241.54	241.69	22065.0
2025-09-25 05:00:00	IWM	ETF	241.71	241.82	241.4	241.53	16416.0
2025-09-25 06:00:00	IWM	ETF	241.55	241.64	241.15	241.24	22876.0
2025-09-25 07:00:00	IWM	ETF	241.25	241.25	239.79	239.87	121751.0
2025-09-25 08:00:00	IWM	ETF	241.15	242.48	238.71	238.84	483497.0
2025-09-25 09:00:00	IWM	ETF	238.82	239.36	237.55	238.51	6571434.0
2025-09-25 10:00:00	IWM	ETF	238.51	239.905	238.27	239.745	3899624.0
2025-09-25 11:00:00	IWM	ETF	239.74	239.99	238.63	239.85	2953460.0
2025-09-25 12:00:00	IWM	ETF	239.84	239.94	239.17	239.26	2083926.0
2025-09-25 13:00:00	IWM	ETF	239.24	239.71	238.29	238.33	2712750.0
2025-09-25 14:00:00	IWM	ETF	238.33	239.64	237.795	239.52	2980184.0
2025-09-25 15:00:00	IWM	ETF	239.52	239.55	238.75	239.3	4135504.0
2025-09-25 16:00:00	IWM	ETF	239.32	239.5	239.29	239.32	1208399.0
2025-09-25 17:00:00	IWM	ETF	239.29	239.39	239.2	239.2436	10459.0
2025-09-25 18:00:00	IWM	ETF	239.29	239.6099	239.27	239.42	41387.0
2025-09-25 19:00:00	IWM	ETF	239.29	239.38	239.11	239.1992	15640.0
2025-09-25 04:00:00	DIA	ETF	461.82	461.82	461.12	461.12	1800.0
2025-09-25 05:00:00	DIA	ETF	461.39	461.48	461.26	461.48	2500.0

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

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