PREVIEW / etf_1hour / 2025-02-18

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-02-18.parquet
  size:    646 KB
  rows:    24,901

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-18 04:00:00	SPY	ETF	610.77	611.87	610.77	611.33	32167.0
2025-02-18 05:00:00	SPY	ETF	611.2	611.72	611.11	611.72	3427.0
2025-02-18 06:00:00	SPY	ETF	611.76	611.88	611.67	611.79	19112.0
2025-02-18 07:00:00	SPY	ETF	611.74	612.11	611.64	611.95	46749.0
2025-02-18 08:00:00	SPY	ETF	611.7	612.31	611.0	612.23	70315.0
2025-02-18 09:00:00	SPY	ETF	612.24	612.24	609.95	610.11	2397854.0
2025-02-18 10:00:00	SPY	ETF	610.1538	610.62	609.33	610.61	2506735.0
2025-02-18 11:00:00	SPY	ETF	610.605	610.855	609.76	610.25	1500961.0
2025-02-18 12:00:00	SPY	ETF	610.24	610.545	609.78	610.35	1135576.0
2025-02-18 13:00:00	SPY	ETF	610.34	610.6587	609.4519	609.66	1457384.0
2025-02-18 14:00:00	SPY	ETF	609.655	610.04	608.38	609.85	3115745.0
2025-02-18 15:00:00	SPY	ETF	609.87	611.38	609.63	611.35	4769027.0
2025-02-18 16:00:00	SPY	ETF	611.37	611.5	610.93	611.0	1919482.0
2025-02-18 17:00:00	SPY	ETF	611.0	611.08	610.92	610.98	41517.0
2025-02-18 18:00:00	SPY	ETF	610.98	611.57	610.98	611.5	31215.0
2025-02-18 19:00:00	SPY	ETF	611.41	611.95	611.38	611.95	41081.0
2025-02-18 04:00:00	QQQ	ETF	540.0	540.95	540.0	540.13	61909.0
2025-02-18 05:00:00	QQQ	ETF	540.15	540.43	539.92	540.43	20285.0
2025-02-18 06:00:00	QQQ	ETF	540.4	540.48	540.08	540.29	17215.0
2025-02-18 07:00:00	QQQ	ETF	540.27	540.84	540.03	540.45	94910.0
2025-02-18 08:00:00	QQQ	ETF	540.05	541.28	537.747	541.07	204543.0
2025-02-18 09:00:00	QQQ	ETF	541.1	541.24	537.54	538.39	2252116.0
2025-02-18 10:00:00	QQQ	ETF	538.4	538.54	536.57	538.04	2200136.0
2025-02-18 11:00:00	QQQ	ETF	538.03	538.73	537.52	538.04	1312560.0
2025-02-18 12:00:00	QQQ	ETF	538.01	538.4	537.44	538.23	838403.0
2025-02-18 13:00:00	QQQ	ETF	538.15	538.4882	536.87	537.34	936635.0
2025-02-18 14:00:00	QQQ	ETF	537.35	538.01	536.04	537.81	1510234.0
2025-02-18 15:00:00	QQQ	ETF	537.82	539.32	537.4	539.32	2920729.0
2025-02-18 16:00:00	QQQ	ETF	539.3	539.56	538.1556	538.89	1421231.0
2025-02-18 17:00:00	QQQ	ETF	538.9698	539.04	538.77	538.92	59843.0
2025-02-18 18:00:00	QQQ	ETF	538.92	539.55	538.92	539.5	73619.0
2025-02-18 19:00:00	QQQ	ETF	539.511	540.1592	539.49	540.1592	70189.0
2025-02-18 04:00:00	IWM	ETF	225.97	226.35	225.97	226.15	26757.0
2025-02-18 05:00:00	IWM	ETF	226.22	226.44	226.13	226.41	8409.0
2025-02-18 06:00:00	IWM	ETF	226.48	226.61	226.43	226.5	4800.0
2025-02-18 07:00:00	IWM	ETF	226.53	226.8	226.53	226.7	41618.0
2025-02-18 08:00:00	IWM	ETF	226.5403	227.07	226.11	226.93	130714.0
2025-02-18 09:00:00	IWM	ETF	226.87	226.93	226.03	226.41	1841606.0
2025-02-18 10:00:00	IWM	ETF	226.42	227.6699	226.0	227.62	1835465.0
2025-02-18 11:00:00	IWM	ETF	227.6	227.61	226.79	226.98	1047461.0
2025-02-18 12:00:00	IWM	ETF	226.945	227.29	226.89	226.9845	709793.0
2025-02-18 13:00:00	IWM	ETF	226.98	227.1	226.4199	226.625	1186420.0
2025-02-18 14:00:00	IWM	ETF	226.62	226.76	225.51	226.67	1515205.0
2025-02-18 15:00:00	IWM	ETF	226.68	227.245	226.59	227.22	2515237.0
2025-02-18 16:00:00	IWM	ETF	227.21	227.7	227.1	227.12	645083.0
2025-02-18 17:00:00	IWM	ETF	227.12	227.24	227.04	227.04	8001.0
2025-02-18 18:00:00	IWM	ETF	227.19	227.3	227.06	227.15	15629.0
2025-02-18 19:00:00	IWM	ETF	227.2	227.49	227.19	227.48	11661.0
2025-02-18 04:00:00	DIA	ETF	446.52	446.67	445.98	446.01	12512.0
2025-02-18 05:00:00	DIA	ETF	445.89	446.32	445.88	446.27	2039.0

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

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