PREVIEW / etf_1hour / 2026-04-24

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-24.parquet
  size:    690 KB
  rows:    27,711

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
2026-04-24 04:00:00	SPY	ETF	709.42	710.35	708.26	708.86	65144.0
2026-04-24 05:00:00	SPY	ETF	709.01	709.14	708.14	708.81	48694.0
2026-04-24 06:00:00	SPY	ETF	708.95	709.69	708.69	709.6	72018.0
2026-04-24 07:00:00	SPY	ETF	709.56	713.38	709.56	711.5899	476306.0
2026-04-24 08:00:00	SPY	ETF	711.64	712.21	708.58	710.71	491689.0
2026-04-24 09:00:00	SPY	ETF	710.78	711.5	709.01	709.94	4379382.0
2026-04-24 10:00:00	SPY	ETF	709.91	711.61	709.14	711.42	4678648.0
2026-04-24 11:00:00	SPY	ETF	711.44	714.14	711.19	713.77	4617419.0
2026-04-24 12:00:00	SPY	ETF	713.77	713.98	712.85	713.61	2737290.0
2026-04-24 13:00:00	SPY	ETF	713.6	714.46	712.72	713.65	2617092.0
2026-04-24 14:00:00	SPY	ETF	713.66	713.79	712.95	713.53	2568523.0
2026-04-24 15:00:00	SPY	ETF	713.53	714.47	713.44	713.98	7994332.0
2026-04-24 16:00:00	SPY	ETF	713.95	714.17	712.98	714.05	2678689.0
2026-04-24 17:00:00	SPY	ETF	714.0	714.23	713.84	713.99	155918.0
2026-04-24 18:00:00	SPY	ETF	713.9	714.3	713.9	714.2011	40830.0
2026-04-24 19:00:00	SPY	ETF	714.2101	714.41	714.01	714.01	23896.0
2026-04-24 04:00:00	QQQ	ETF	655.08	657.08	653.89	655.74	154836.0
2026-04-24 05:00:00	QQQ	ETF	655.77	656.33	655.0	655.92	111349.0
2026-04-24 06:00:00	QQQ	ETF	656.12	658.04	656.11	657.69	144382.0
2026-04-24 07:00:00	QQQ	ETF	657.55	662.18	657.53	660.06	797709.0
2026-04-24 08:00:00	QQQ	ETF	660.07	660.96	651.908	659.21	553440.0
2026-04-24 09:00:00	QQQ	ETF	659.26	659.82	656.5301	658.0201	4801426.0
2026-04-24 10:00:00	QQQ	ETF	658.02	660.55	657.234	660.385	5105255.0
2026-04-24 11:00:00	QQQ	ETF	660.4	663.435	660.31	662.94	5459852.0
2026-04-24 12:00:00	QQQ	ETF	662.91	663.74	662.06	663.26	2718236.0
2026-04-24 13:00:00	QQQ	ETF	663.3	664.51	662.225	663.81	2237337.0
2026-04-24 14:00:00	QQQ	ETF	663.8	664.06	662.67	663.27	2114967.0
2026-04-24 15:00:00	QQQ	ETF	663.27	664.38	663.2	663.93	6447501.0
2026-04-24 16:00:00	QQQ	ETF	663.92	664.13	663.19	663.99	2943301.0
2026-04-24 17:00:00	QQQ	ETF	664.0	664.0	663.41	663.55	54878.0
2026-04-24 18:00:00	QQQ	ETF	663.59	663.62	663.43	663.5	49333.0
2026-04-24 19:00:00	QQQ	ETF	663.53	663.75	663.43	663.46	32493.0
2026-04-24 04:00:00	IWM	ETF	275.45	275.66	274.31	274.92	41816.0
2026-04-24 05:00:00	IWM	ETF	274.92	275.25	274.65	275.13	28063.0
2026-04-24 06:00:00	IWM	ETF	275.23	275.74	275.23	275.68	31089.0
2026-04-24 07:00:00	IWM	ETF	275.69	277.84	275.65	276.81	366965.0
2026-04-24 08:00:00	IWM	ETF	276.87	277.2	275.93	276.27	521664.0
2026-04-24 09:00:00	IWM	ETF	276.34	277.29	274.23	275.09	2611503.0
2026-04-24 10:00:00	IWM	ETF	275.07	276.43	274.57	276.14	2473285.0
2026-04-24 11:00:00	IWM	ETF	276.18	278.13	275.98	277.915	2956065.0
2026-04-24 12:00:00	IWM	ETF	277.915	278.0	277.06	277.5001	1483161.0
2026-04-24 13:00:00	IWM	ETF	277.51	277.75	276.89	277.12	1178623.0
2026-04-24 14:00:00	IWM	ETF	277.125	277.27	276.78	277.09	1191512.0
2026-04-24 15:00:00	IWM	ETF	277.09	277.26	276.3	276.64	2959776.0
2026-04-24 16:00:00	IWM	ETF	276.64	276.86	276.4	276.66	1091966.0
2026-04-24 17:00:00	IWM	ETF	276.78	276.8	276.52	276.63	17740.0
2026-04-24 18:00:00	IWM	ETF	276.59	276.75	276.59	276.69	9891.0
2026-04-24 19:00:00	IWM	ETF	276.7	276.78	276.56	276.65	17136.0
2026-04-24 04:00:00	DIA	ETF	492.21	492.6	491.34	491.4	3714.0
2026-04-24 05:00:00	DIA	ETF	491.58	491.76	491.05	491.52	18010.0

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

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