PREVIEW / etf_1hour / 2026-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-29.parquet
  size:    750 KB
  rows:    29,754

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-29 04:00:00	SPY	ETF	697.0	697.75	696.74	696.79	82190.0
2026-01-29 05:00:00	SPY	ETF	696.75	697.16	696.19	696.27	33399.0
2026-01-29 06:00:00	SPY	ETF	696.27	697.05	695.95	696.71	35773.0
2026-01-29 07:00:00	SPY	ETF	696.74	697.2	696.2	696.74	209143.0
2026-01-29 08:00:00	SPY	ETF	696.75	697.76	695.9012	697.2	417699.0
2026-01-29 09:00:00	SPY	ETF	697.21	697.21	691.47	691.56	10905077.0
2026-01-29 10:00:00	SPY	ETF	691.57	691.64	685.1935	686.05	18612390.0
2026-01-29 11:00:00	SPY	ETF	686.07	689.04	684.83	688.705	12500702.0
2026-01-29 12:00:00	SPY	ETF	688.71	691.675	688.64	688.89	8617628.0
2026-01-29 13:00:00	SPY	ETF	688.89	691.81	688.71	690.59	6978109.0
2026-01-29 14:00:00	SPY	ETF	690.59	692.225	690.225	691.13	7654000.0
2026-01-29 15:00:00	SPY	ETF	691.13	694.79	691.045	693.97	16177523.0
2026-01-29 16:00:00	SPY	ETF	693.97	695.2	693.47	693.92	3506859.0
2026-01-29 17:00:00	SPY	ETF	693.92	694.5	693.92	694.11	120174.0
2026-01-29 18:00:00	SPY	ETF	694.14	694.39	691.61	693.68	161685.0
2026-01-29 19:00:00	SPY	ETF	693.7094	693.95	692.42	692.6923	57564.0
2026-01-29 04:00:00	QQQ	ETF	635.44	636.02	634.52	634.55	98579.0
2026-01-29 05:00:00	QQQ	ETF	634.51	635.14	633.98	634.07	58203.0
2026-01-29 06:00:00	QQQ	ETF	634.06	634.44	633.7	634.23	111855.0
2026-01-29 07:00:00	QQQ	ETF	634.31	634.78	633.28	633.76	190958.0
2026-01-29 08:00:00	QQQ	ETF	634.48	636.1	632.746	634.15	433536.0
2026-01-29 09:00:00	QQQ	ETF	634.14	634.2	626.06	626.19	9313883.0
2026-01-29 10:00:00	QQQ	ETF	626.2	626.28	618.27	619.26	14038427.0
2026-01-29 11:00:00	QQQ	ETF	619.28	623.22	618.34	622.53	10433345.0
2026-01-29 12:00:00	QQQ	ETF	622.5	626.57	622.47	623.72	6952676.0
2026-01-29 13:00:00	QQQ	ETF	623.72	626.85	623.67	625.57	5832374.0
2026-01-29 14:00:00	QQQ	ETF	625.57	627.07	625.18	625.85	4081786.0
2026-01-29 15:00:00	QQQ	ETF	625.86	629.98	625.67	629.36	8172398.0
2026-01-29 16:00:00	QQQ	ETF	629.32	630.56	628.52	629.11	2460797.0
2026-01-29 17:00:00	QQQ	ETF	629.06	630.04	628.92	629.68	204478.0
2026-01-29 18:00:00	QQQ	ETF	629.66	629.9	626.75	628.91	240685.0
2026-01-29 19:00:00	QQQ	ETF	628.8	629.25	627.26	627.8101	112054.0
2026-01-29 04:00:00	IWM	ETF	263.53	264.31	263.53	263.61	41260.0
2026-01-29 05:00:00	IWM	ETF	263.6	264.0	263.42	263.46	40949.0
2026-01-29 06:00:00	IWM	ETF	263.46	264.59	263.38	264.36	53682.0
2026-01-29 07:00:00	IWM	ETF	264.27	264.41	263.83	264.14	37163.0
2026-01-29 08:00:00	IWM	ETF	264.33	264.4	262.83	264.21	232303.0
2026-01-29 09:00:00	IWM	ETF	264.27	265.06	262.98	263.021	4204330.0
2026-01-29 10:00:00	IWM	ETF	263.04	263.05	259.65	260.45	5696467.0
2026-01-29 11:00:00	IWM	ETF	260.46	262.01	259.41	261.795	5291144.0
2026-01-29 12:00:00	IWM	ETF	261.8	263.1	261.54	261.63	2896873.0
2026-01-29 13:00:00	IWM	ETF	261.63	262.7	261.2	261.83	2584946.0
2026-01-29 14:00:00	IWM	ETF	261.82	263.12	261.66	261.98	2779872.0
2026-01-29 15:00:00	IWM	ETF	261.98	263.495	261.98	263.37	4389905.0
2026-01-29 16:00:00	IWM	ETF	263.35	263.91	262.78	262.85	993806.0
2026-01-29 17:00:00	IWM	ETF	263.14	263.14	262.7371	262.94	16851.0
2026-01-29 18:00:00	IWM	ETF	262.91	262.91	261.6	262.8	37078.0
2026-01-29 19:00:00	IWM	ETF	262.74	262.74	262.17	262.34	37729.0
2026-01-29 04:00:00	DIA	ETF	490.51	490.98	490.51	490.98	421.0
2026-01-29 05:00:00	DIA	ETF	490.66	490.66	490.16	490.16	560.0

> showing 50 of 29,754 rows — these rows as CSV

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