PREVIEW / etf_1hour / 2025-02-20

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-02-20.parquet
  size:    619 KB
  rows:    23,773

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-20 04:00:00	SPY	ETF	611.45	612.0	611.42	611.98	9305.0
2025-02-20 05:00:00	SPY	ETF	611.95	612.15	611.88	611.89	4498.0
2025-02-20 06:00:00	SPY	ETF	611.82	611.88	611.04	611.09	73882.0
2025-02-20 07:00:00	SPY	ETF	611.15	611.559	610.89	611.53	101781.0
2025-02-20 08:00:00	SPY	ETF	611.39	611.56	610.92	611.12	159197.0
2025-02-20 09:00:00	SPY	ETF	611.41	611.75	608.31	608.3825	2998579.0
2025-02-20 10:00:00	SPY	ETF	608.4	609.52	607.02	607.35	4427856.0
2025-02-20 11:00:00	SPY	ETF	607.35	608.45	607.1	607.46	2400585.0
2025-02-20 12:00:00	SPY	ETF	607.45	609.0999	607.28	608.03	1865176.0
2025-02-20 13:00:00	SPY	ETF	608.03	608.76	607.64	608.6	1751114.0
2025-02-20 14:00:00	SPY	ETF	608.6	610.1	608.5	609.86	2461083.0
2025-02-20 15:00:00	SPY	ETF	609.865	610.7	609.26	610.39	5505492.0
2025-02-20 16:00:00	SPY	ETF	610.39	610.5	609.77	610.0	2086117.0
2025-02-20 17:00:00	SPY	ETF	610.07	610.07	609.83	609.9	18535.0
2025-02-20 18:00:00	SPY	ETF	609.9	610.6	609.9	610.43	36482.0
2025-02-20 19:00:00	SPY	ETF	610.35	610.53	610.23	610.37	14496.0
2025-02-20 20:00:00	SPY	ETF	610.39	610.39	610.39	610.39	300.0
2025-02-20 04:00:00	QQQ	ETF	538.05	538.56	537.93	538.54	22679.0
2025-02-20 05:00:00	QQQ	ETF	538.65	538.9	538.59	538.65	15694.0
2025-02-20 06:00:00	QQQ	ETF	538.62	538.7	537.93	538.17	34567.0
2025-02-20 07:00:00	QQQ	ETF	538.19	538.74	537.9	538.74	73358.0
2025-02-20 08:00:00	QQQ	ETF	538.0	538.83	537.15	538.56	166920.0
2025-02-20 09:00:00	QQQ	ETF	538.62	539.1	533.65	533.895	2875285.0
2025-02-20 10:00:00	QQQ	ETF	533.85	536.22	532.46	533.41	4134303.0
2025-02-20 11:00:00	QQQ	ETF	533.4599	535.4802	533.27	534.38	1914651.0
2025-02-20 12:00:00	QQQ	ETF	534.36	536.01	534.25	534.6452	1209401.0
2025-02-20 13:00:00	QQQ	ETF	534.62	535.518	534.3503	535.3001	1083378.0
2025-02-20 14:00:00	QQQ	ETF	535.29	536.72	535.015	536.45	1908270.0
2025-02-20 15:00:00	QQQ	ETF	536.48	537.25	535.68	537.19	3101066.0
2025-02-20 16:00:00	QQQ	ETF	537.17	537.26	536.6	536.95	1249316.0
2025-02-20 17:00:00	QQQ	ETF	536.8958	537.23	536.75	536.86	409097.0
2025-02-20 18:00:00	QQQ	ETF	536.75	537.79	536.75	537.5108	63539.0
2025-02-20 19:00:00	QQQ	ETF	537.4	537.6	537.2	537.39	57096.0
2025-02-20 04:00:00	IWM	ETF	225.74	225.94	225.66	225.94	16759.0
2025-02-20 05:00:00	IWM	ETF	225.99	226.05	225.93	225.95	5554.0
2025-02-20 06:00:00	IWM	ETF	225.96	226.01	225.72	225.73	16843.0
2025-02-20 07:00:00	IWM	ETF	225.86	226.25	225.76	226.14	44109.0
2025-02-20 08:00:00	IWM	ETF	226.14	226.19	225.42	226.0	200521.0
2025-02-20 09:00:00	IWM	ETF	226.03	226.19	223.87	223.9	2118943.0
2025-02-20 10:00:00	IWM	ETF	223.91	224.295	223.05	223.16	2303397.0
2025-02-20 11:00:00	IWM	ETF	223.168	223.58	223.01	223.21	1384607.0
2025-02-20 12:00:00	IWM	ETF	223.22	224.09	223.2	223.6932	1213410.0
2025-02-20 13:00:00	IWM	ETF	223.68	224.01	223.44	223.965	1144665.0
2025-02-20 14:00:00	IWM	ETF	223.96	224.52	223.9	224.41	1598465.0
2025-02-20 15:00:00	IWM	ETF	224.43	224.96	224.15	224.29	2818385.0
2025-02-20 16:00:00	IWM	ETF	224.26	224.32	223.93	224.02	891261.0
2025-02-20 17:00:00	IWM	ETF	224.0	224.03	223.94	224.0	8567.0
2025-02-20 18:00:00	IWM	ETF	224.0	224.26	224.0	224.12	24007.0
2025-02-20 19:00:00	IWM	ETF	224.13	224.2	224.02	224.09	14592.0
2025-02-20 04:00:00	DIA	ETF	445.98	445.98	445.98	445.98	200.0

> showing 50 of 23,773 rows — these rows as CSV

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