PREVIEW / etf_1hour / 2026-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-02-02.parquet
  size:    762 KB
  rows:    30,317

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-02-02 04:00:00	SPY	ETF	687.0	688.13	686.08	687.78	122809.0
2026-02-02 05:00:00	SPY	ETF	687.85	688.2	686.81	687.05	47721.0
2026-02-02 06:00:00	SPY	ETF	687.1	688.97	686.92	688.47	73526.0
2026-02-02 07:00:00	SPY	ETF	688.48	689.7	688.41	688.93	459718.0
2026-02-02 08:00:00	SPY	ETF	688.9	689.73	681.94	689.49	542539.0
2026-02-02 09:00:00	SPY	ETF	689.49	693.84	689.4	692.7	11154997.0
2026-02-02 10:00:00	SPY	ETF	692.62	695.75	692.31	694.73	12415565.0
2026-02-02 11:00:00	SPY	ETF	694.72	695.86	693.92	695.75	6440627.0
2026-02-02 12:00:00	SPY	ETF	695.75	696.93	695.64	696.405	4906484.0
2026-02-02 13:00:00	SPY	ETF	696.41	696.76	695.685	696.49	3883259.0
2026-02-02 14:00:00	SPY	ETF	696.49	696.88	695.345	695.52	6476215.0
2026-02-02 15:00:00	SPY	ETF	695.525	696.47	695.0103	695.46	18404552.0
2026-02-02 16:00:00	SPY	ETF	695.47	695.91	694.94	695.4799	3455771.0
2026-02-02 17:00:00	SPY	ETF	695.46	695.9	695.38	695.84	54176.0
2026-02-02 18:00:00	SPY	ETF	695.8	697.351	695.41	696.74	456188.0
2026-02-02 19:00:00	SPY	ETF	696.75	697.48	696.18	697.02	111482.0
2026-02-02 04:00:00	QQQ	ETF	617.22	617.22	614.18	616.57	274694.0
2026-02-02 05:00:00	QQQ	ETF	616.6	617.0	615.08	615.45	140595.0
2026-02-02 06:00:00	QQQ	ETF	615.45	617.44	615.28	616.55	124616.0
2026-02-02 07:00:00	QQQ	ETF	616.53	618.4	616.49	617.46	254191.0
2026-02-02 08:00:00	QQQ	ETF	616.49	621.404	610.05	618.37	732411.0
2026-02-02 09:00:00	QQQ	ETF	618.4	624.91	618.18	623.72	7026337.0
2026-02-02 10:00:00	QQQ	ETF	623.7	627.6	623.3501	625.87	7696688.0
2026-02-02 11:00:00	QQQ	ETF	625.86	627.41	624.99	627.18	5187837.0
2026-02-02 12:00:00	QQQ	ETF	627.17	628.31	627.04	627.89	3381248.0
2026-02-02 13:00:00	QQQ	ETF	627.9	628.49	627.27	628.32	2655123.0
2026-02-02 14:00:00	QQQ	ETF	628.32	628.405	625.92	626.04	3409674.0
2026-02-02 15:00:00	QQQ	ETF	626.03	627.33	625.4225	626.24	8396910.0
2026-02-02 16:00:00	QQQ	ETF	626.25	627.24	625.75	626.6	1482544.0
2026-02-02 17:00:00	QQQ	ETF	626.67	627.38	626.58	627.28	105910.0
2026-02-02 18:00:00	QQQ	ETF	627.27	629.12	626.58	628.45	161436.0
2026-02-02 19:00:00	QQQ	ETF	628.45	629.37	627.72	628.5375	123353.0
2026-02-02 04:00:00	IWM	ETF	257.25	257.5	256.52	257.19	42367.0
2026-02-02 05:00:00	IWM	ETF	257.21	257.64	257.21	257.5	46476.0
2026-02-02 06:00:00	IWM	ETF	257.5	258.45	257.46	258.17	107039.0
2026-02-02 07:00:00	IWM	ETF	258.29	258.89	258.25	258.51	160960.0
2026-02-02 08:00:00	IWM	ETF	258.78	259.25	254.94	259.14	192584.0
2026-02-02 09:00:00	IWM	ETF	259.12	261.32	258.35	260.055	4359631.0
2026-02-02 10:00:00	IWM	ETF	260.03	263.26	259.7	262.765	4701779.0
2026-02-02 11:00:00	IWM	ETF	262.74	262.92	261.875	262.495	2114071.0
2026-02-02 12:00:00	IWM	ETF	262.48	263.45	262.4	263.32	2232014.0
2026-02-02 13:00:00	IWM	ETF	263.33	263.77	262.62	263.34	3791150.0
2026-02-02 14:00:00	IWM	ETF	263.33	263.71	262.56	262.76	3015791.0
2026-02-02 15:00:00	IWM	ETF	262.76	263.17	261.72	262.15	5845799.0
2026-02-02 16:00:00	IWM	ETF	262.17	262.23	261.43	261.67	1599848.0
2026-02-02 17:00:00	IWM	ETF	261.69	262.05	261.68	261.98	54464.0
2026-02-02 18:00:00	IWM	ETF	261.91	262.48	261.76	262.3	32043.0
2026-02-02 19:00:00	IWM	ETF	262.27	262.74	262.08	262.49	95542.0
2026-02-02 04:00:00	DIA	ETF	486.48	487.57	484.14	487.56	4903.0
2026-02-02 05:00:00	DIA	ETF	487.78	487.88	487.47	487.47	3931.0

> showing 50 of 30,317 rows — these rows as CSV

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