PREVIEW / etf_1hour / 2025-09-16

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-16.parquet
  size:    689 KB
  rows:    26,325

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-16 04:00:00	SPY	ETF	661.76	662.65	661.12	662.42	31779.0
2025-09-16 05:00:00	SPY	ETF	662.52	662.6	662.05	662.15	9311.0
2025-09-16 06:00:00	SPY	ETF	662.17	662.2	662.04	662.09	14278.0
2025-09-16 07:00:00	SPY	ETF	662.1	662.12	661.73	661.93	36692.0
2025-09-16 08:00:00	SPY	ETF	661.96	662.44	660.6742	661.4	225273.0
2025-09-16 09:00:00	SPY	ETF	661.42	661.78	660.03	660.28	6913193.0
2025-09-16 10:00:00	SPY	ETF	660.27	660.518	659.63	659.85	7357843.0
2025-09-16 11:00:00	SPY	ETF	659.86	660.115	659.21	659.665	5064826.0
2025-09-16 12:00:00	SPY	ETF	659.665	660.08	659.48	659.955	3131761.0
2025-09-16 13:00:00	SPY	ETF	659.96	660.44	659.905	660.2	3117440.0
2025-09-16 14:00:00	SPY	ETF	660.18	660.74	660.03	660.6	3617140.0
2025-09-16 15:00:00	SPY	ETF	660.6	660.73	659.68	659.93	11808461.0
2025-09-16 16:00:00	SPY	ETF	659.94	660.4259	659.8173	660.03	3276090.0
2025-09-16 17:00:00	SPY	ETF	660.05	660.1998	659.79	659.94	82921.0
2025-09-16 18:00:00	SPY	ETF	659.94	660.46	659.84	660.43	95800.0
2025-09-16 19:00:00	SPY	ETF	660.39	660.43	660.1899	660.3	11231.0
2025-09-16 04:00:00	QQQ	ETF	593.0	594.0	592.82	593.75	76316.0
2025-09-16 05:00:00	QQQ	ETF	593.87	593.96	593.27	593.48	22646.0
2025-09-16 06:00:00	QQQ	ETF	593.45	593.57	593.3	593.44	28367.0
2025-09-16 07:00:00	QQQ	ETF	593.43	593.46	592.7	592.97	85581.0
2025-09-16 08:00:00	QQQ	ETF	593.2	593.9496	591.237	592.82	223006.0
2025-09-16 09:00:00	QQQ	ETF	592.79	593.1	591.01	591.37	5159740.0
2025-09-16 10:00:00	QQQ	ETF	591.36	591.91	590.99	591.392	4277198.0
2025-09-16 11:00:00	QQQ	ETF	591.39	591.49	590.5611	590.73	2958871.0
2025-09-16 12:00:00	QQQ	ETF	590.71	591.3	590.49	591.0985	2299840.0
2025-09-16 13:00:00	QQQ	ETF	591.09	591.63	591.07	591.36	2118759.0
2025-09-16 14:00:00	QQQ	ETF	591.355	591.74	591.1	591.6957	2126922.0
2025-09-16 15:00:00	QQQ	ETF	591.7	592.07	591.01	591.17	5473962.0
2025-09-16 16:00:00	QQQ	ETF	591.17	591.6	591.11	591.27	998041.0
2025-09-16 17:00:00	QQQ	ETF	591.29	591.46	591.29	591.34	31701.0
2025-09-16 18:00:00	QQQ	ETF	591.32	591.75	591.21	591.66	29554.0
2025-09-16 19:00:00	QQQ	ETF	591.6682	591.73	591.49	591.59	11637.0
2025-09-16 04:00:00	IWM	ETF	239.05	239.4	239.03	239.24	24840.0
2025-09-16 05:00:00	IWM	ETF	239.25	239.25	238.93	238.96	17711.0
2025-09-16 06:00:00	IWM	ETF	238.95	238.96	238.78	238.82	28000.0
2025-09-16 07:00:00	IWM	ETF	238.83	238.9	238.6	238.75	32170.0
2025-09-16 08:00:00	IWM	ETF	238.83	239.36	238.3	238.66	124956.0
2025-09-16 09:00:00	IWM	ETF	238.68	238.93	237.27	237.63	4217311.0
2025-09-16 10:00:00	IWM	ETF	237.63	237.65	236.76	237.345	3505160.0
2025-09-16 11:00:00	IWM	ETF	237.35	237.51	236.77	237.5	3031104.0
2025-09-16 12:00:00	IWM	ETF	237.49	237.7307	237.09	237.645	2239900.0
2025-09-16 13:00:00	IWM	ETF	237.64	238.19	237.53	238.14	2231673.0
2025-09-16 14:00:00	IWM	ETF	238.13	238.27	237.6	238.155	2147280.0
2025-09-16 15:00:00	IWM	ETF	238.16	238.57	237.74	238.27	6277969.0
2025-09-16 16:00:00	IWM	ETF	238.28	238.8332	238.27	238.4699	1202611.0
2025-09-16 17:00:00	IWM	ETF	238.65	238.66	238.42	238.53	3832.0
2025-09-16 18:00:00	IWM	ETF	238.57	238.674	238.43	238.64	11188.0
2025-09-16 19:00:00	IWM	ETF	238.6	238.6	238.42	238.6	15891.0
2025-09-16 04:00:00	DIA	ETF	460.26	460.34	460.26	460.34	500.0
2025-09-16 05:00:00	DIA	ETF	460.05	460.05	459.91	460.01	900.0

> showing 50 of 26,325 rows — these rows as CSV

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