PREVIEW / etf_1hour / 2025-02-26

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-02-26.parquet
  size:    624 KB
  rows:    24,186

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-02-26 04:00:00	SPY	ETF	596.77	597.45	596.75	597.05	46853.0
2025-02-26 05:00:00	SPY	ETF	597.35	597.36	596.92	597.26	6925.0
2025-02-26 06:00:00	SPY	ETF	597.07	597.47	596.56	596.84	70866.0
2025-02-26 07:00:00	SPY	ETF	596.79	597.19	596.29	596.88	321086.0
2025-02-26 08:00:00	SPY	ETF	596.71	597.6	596.15	596.46	253036.0
2025-02-26 09:00:00	SPY	ETF	596.51	597.8	595.1	597.71	4035361.0
2025-02-26 10:00:00	SPY	ETF	597.71	599.28	597.2411	598.85	3610982.0
2025-02-26 11:00:00	SPY	ETF	598.87	599.58	597.82	598.01	2596925.0
2025-02-26 12:00:00	SPY	ETF	598.06	599.3791	595.1	595.605	3060347.0
2025-02-26 13:00:00	SPY	ETF	595.59	595.86	592.12	592.58	3767049.0
2025-02-26 14:00:00	SPY	ETF	592.55	594.64	591.8556	592.76	3863681.0
2025-02-26 15:00:00	SPY	ETF	592.8	595.29	592.46	594.43	6097558.0
2025-02-26 16:00:00	SPY	ETF	594.44	600.0	592.23	596.3	3407591.0
2025-02-26 17:00:00	SPY	ETF	596.2	596.7463	595.15	595.3	271160.0
2025-02-26 18:00:00	SPY	ETF	595.16	595.55	593.95	594.97	131103.0
2025-02-26 19:00:00	SPY	ETF	595.0714	595.4	593.66	593.66	78990.0
2025-02-26 04:00:00	QQQ	ETF	516.75	517.76	516.7	517.18	146362.0
2025-02-26 05:00:00	QQQ	ETF	517.13	517.71	517.13	517.57	41770.0
2025-02-26 06:00:00	QQQ	ETF	517.5	517.74	516.51	516.8	59536.0
2025-02-26 07:00:00	QQQ	ETF	516.74	517.22	516.1	516.79	216082.0
2025-02-26 08:00:00	QQQ	ETF	516.7	517.81	515.86	516.4	449882.0
2025-02-26 09:00:00	QQQ	ETF	516.41	517.37	514.39	517.09	2761338.0
2025-02-26 10:00:00	QQQ	ETF	517.11	518.79	516.2	518.31	3209128.0
2025-02-26 11:00:00	QQQ	ETF	518.32	519.6588	518.05	518.26	2327757.0
2025-02-26 12:00:00	QQQ	ETF	518.27	519.66	515.37	515.84	2429568.0
2025-02-26 13:00:00	QQQ	ETF	515.83	516.085	511.85	512.3	2879146.0
2025-02-26 14:00:00	QQQ	ETF	512.27	514.03	511.37	512.08	2776327.0
2025-02-26 15:00:00	QQQ	ETF	512.13	515.23	511.7	514.49	3235963.0
2025-02-26 16:00:00	QQQ	ETF	514.44	517.61	512.0	516.52	2208752.0
2025-02-26 17:00:00	QQQ	ETF	516.5	517.96	514.56	515.89	603837.0
2025-02-26 18:00:00	QQQ	ETF	515.7	516.07	513.82	514.8401	249036.0
2025-02-26 19:00:00	QQQ	ETF	514.87	515.27	512.86	513.09	222076.0
2025-02-26 04:00:00	IWM	ETF	216.32	216.42	215.97	216.06	47506.0
2025-02-26 05:00:00	IWM	ETF	216.08	216.1	215.81	216.06	29579.0
2025-02-26 06:00:00	IWM	ETF	216.02	216.66	216.01	216.11	39284.0
2025-02-26 07:00:00	IWM	ETF	216.169	216.4	216.0	216.15	51343.0
2025-02-26 08:00:00	IWM	ETF	216.13	216.64	215.98	216.19	152235.0
2025-02-26 09:00:00	IWM	ETF	216.2	218.135	215.6538	217.815	2381585.0
2025-02-26 10:00:00	IWM	ETF	217.82	218.41	217.2701	217.81	3000656.0
2025-02-26 11:00:00	IWM	ETF	217.82	218.16	217.29	217.33	1287064.0
2025-02-26 12:00:00	IWM	ETF	217.35	217.88	216.14	216.33	1875270.0
2025-02-26 13:00:00	IWM	ETF	216.32	216.665	214.89	215.25	2646252.0
2025-02-26 14:00:00	IWM	ETF	215.24	215.93	214.94	215.03	1734786.0
2025-02-26 15:00:00	IWM	ETF	215.04	215.88	214.84	215.7	3118321.0
2025-02-26 16:00:00	IWM	ETF	215.68	216.2	215.47	216.11	1116585.0
2025-02-26 17:00:00	IWM	ETF	216.07	216.68	216.07	216.38	38819.0
2025-02-26 18:00:00	IWM	ETF	216.25	216.26	215.83	216.07	103069.0
2025-02-26 19:00:00	IWM	ETF	216.34	216.34	215.75	215.75	14030.0
2025-02-26 04:00:00	DIA	ETF	437.33	437.37	436.97	437.3	5355.0
2025-02-26 05:00:00	DIA	ETF	437.16	437.26	437.16	437.26	405.0

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

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