PREVIEW / etf_1hour / 2026-01-02

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-02.parquet
  size:    737 KB
  rows:    28,679

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-01-02 04:00:00	SPY	ETF	683.9	686.69	683.9	686.64	157666.0
2026-01-02 05:00:00	SPY	ETF	686.66	686.7	686.01	686.45	68501.0
2026-01-02 06:00:00	SPY	ETF	686.48	686.67	686.07	686.24	100928.0
2026-01-02 07:00:00	SPY	ETF	686.18	686.23	685.69	686.039	271078.0
2026-01-02 08:00:00	SPY	ETF	686.16	686.7036	684.94	685.74	431533.0
2026-01-02 09:00:00	SPY	ETF	685.72	686.84	684.12	686.19	9485578.0
2026-01-02 10:00:00	SPY	ETF	686.21	686.87	681.1	681.455	16859907.0
2026-01-02 11:00:00	SPY	ETF	681.46	682.65	680.28	681.158	9811676.0
2026-01-02 12:00:00	SPY	ETF	681.15	682.8009	680.64	681.18	5395430.0
2026-01-02 13:00:00	SPY	ETF	681.18	681.7886	679.82	680.525	4819458.0
2026-01-02 14:00:00	SPY	ETF	680.525	683.95	680.35	683.13	10085117.0
2026-01-02 15:00:00	SPY	ETF	683.13	683.7	682.07	683.17	13893871.0
2026-01-02 16:00:00	SPY	ETF	683.17	683.64	682.89	683.12	3053615.0
2026-01-02 17:00:00	SPY	ETF	683.16	683.16	682.6	682.63	20612.0
2026-01-02 18:00:00	SPY	ETF	682.75	682.899	682.59	682.7	35871.0
2026-01-02 19:00:00	SPY	ETF	682.7556	682.97	682.6997	682.9699	30394.0
2026-01-02 04:00:00	QQQ	ETF	619.0	621.33	619.0	621.2	143409.0
2026-01-02 05:00:00	QQQ	ETF	621.23	621.3	620.6	621.14	91005.0
2026-01-02 06:00:00	QQQ	ETF	621.14	621.41	620.78	621.06	65098.0
2026-01-02 07:00:00	QQQ	ETF	621.05	621.05	619.93	620.48	171276.0
2026-01-02 08:00:00	QQQ	ETF	620.85	621.32	618.31	620.2398	374634.0
2026-01-02 09:00:00	QQQ	ETF	620.19	622.85	618.9	621.19	7836580.0
2026-01-02 10:00:00	QQQ	ETF	621.18	622.27	612.31	612.665	13427400.0
2026-01-02 11:00:00	QQQ	ETF	612.68	613.93	610.75	611.95	8824562.0
2026-01-02 12:00:00	QQQ	ETF	611.92	613.425	611.26	611.56	3954788.0
2026-01-02 13:00:00	QQQ	ETF	611.52	612.495	610.15	610.84	3298294.0
2026-01-02 14:00:00	QQQ	ETF	610.8377	614.7	610.71	613.36	5241092.0
2026-01-02 15:00:00	QQQ	ETF	613.35	614.55	612.5	613.09	6294269.0
2026-01-02 16:00:00	QQQ	ETF	613.09	613.7401	612.91	613.25	1048191.0
2026-01-02 17:00:00	QQQ	ETF	613.25	613.28	613.05	613.25	26161.0
2026-01-02 18:00:00	QQQ	ETF	613.28	613.48	613.15	613.4795	21209.0
2026-01-02 19:00:00	QQQ	ETF	613.47	613.7	613.4	613.69	16549.0
2026-01-02 04:00:00	IWM	ETF	247.7	248.28	247.52	248.24	36375.0
2026-01-02 05:00:00	IWM	ETF	248.22	248.37	248.0	248.26	24287.0
2026-01-02 06:00:00	IWM	ETF	248.32	248.38	248.09	248.28	12782.0
2026-01-02 07:00:00	IWM	ETF	248.29	248.3	247.88	247.96	84903.0
2026-01-02 08:00:00	IWM	ETF	248.26	248.38	247.28	247.63	179872.0
2026-01-02 09:00:00	IWM	ETF	247.63	248.075	245.86	247.67	5091473.0
2026-01-02 10:00:00	IWM	ETF	247.67	248.0	245.865	247.21	5927856.0
2026-01-02 11:00:00	IWM	ETF	247.22	248.01	246.85	247.33	4276946.0
2026-01-02 12:00:00	IWM	ETF	247.31	248.385	246.99	247.65	3999803.0
2026-01-02 13:00:00	IWM	ETF	247.64	247.695	246.71	247.14	2835910.0
2026-01-02 14:00:00	IWM	ETF	247.15	249.02	247.15	248.84	3448411.0
2026-01-02 15:00:00	IWM	ETF	248.85	249.09	248.25	248.8	5459777.0
2026-01-02 16:00:00	IWM	ETF	248.79	248.91	248.57	248.66	906025.0
2026-01-02 17:00:00	IWM	ETF	248.71	248.71	248.57	248.66	2960.0
2026-01-02 18:00:00	IWM	ETF	248.6	248.63	248.45	248.62	21692.0
2026-01-02 19:00:00	IWM	ETF	248.61	248.78	248.61	248.77	11123.0
2026-01-02 04:00:00	DIA	ETF	481.84	482.55	481.83	482.55	4626.0
2026-01-02 05:00:00	DIA	ETF	482.51	482.64	482.43	482.64	2382.0

> showing 50 of 28,679 rows — these rows as CSV

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