PREVIEW / etf_1hour / 2026-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-06.parquet
  size:    758 KB
  rows:    29,007

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-06 04:00:00	SPY	ETF	686.95	687.69	686.88	687.25	39723.0
2026-01-06 05:00:00	SPY	ETF	687.27	687.47	687.13	687.35	16720.0
2026-01-06 06:00:00	SPY	ETF	687.35	687.55	687.19	687.35	19270.0
2026-01-06 07:00:00	SPY	ETF	687.29	688.19	687.22	688.06	58656.0
2026-01-06 08:00:00	SPY	ETF	687.07	689.07	686.44	687.71	236488.0
2026-01-06 09:00:00	SPY	ETF	687.64	690.16	687.28	690.075	8060623.0
2026-01-06 10:00:00	SPY	ETF	690.075	690.86	688.695	689.105	11628702.0
2026-01-06 11:00:00	SPY	ETF	689.1	689.526	688.3	689.43	7343002.0
2026-01-06 12:00:00	SPY	ETF	689.43	691.1	689.155	690.945	5877166.0
2026-01-06 13:00:00	SPY	ETF	690.95	691.725	690.55	691.72	4983028.0
2026-01-06 14:00:00	SPY	ETF	691.72	692.165	691.67	691.875	5499060.0
2026-01-06 15:00:00	SPY	ETF	691.875	692.315	691.8	691.8	12104946.0
2026-01-06 16:00:00	SPY	ETF	691.81	692.13	691.78	692.05	2622908.0
2026-01-06 17:00:00	SPY	ETF	692.059	692.1	687.86	692.0019	164466.0
2026-01-06 18:00:00	SPY	ETF	692.08	692.29	691.84	691.84	86507.0
2026-01-06 19:00:00	SPY	ETF	691.84	692.2212	691.82	692.0996	63114.0
2026-01-06 04:00:00	QQQ	ETF	617.7	618.54	617.38	618.06	100224.0
2026-01-06 05:00:00	QQQ	ETF	618.08	618.3	617.72	618.2	37656.0
2026-01-06 06:00:00	QQQ	ETF	618.23	618.6	618.15	618.31	42679.0
2026-01-06 07:00:00	QQQ	ETF	618.31	619.53	618.19	619.35	92549.0
2026-01-06 08:00:00	QQQ	ETF	618.1932	620.1	616.69	618.85	372217.0
2026-01-06 09:00:00	QQQ	ETF	618.79	622.19	618.22	621.9844	6216314.0
2026-01-06 10:00:00	QQQ	ETF	621.96	622.59	620.1	620.43	6746759.0
2026-01-06 11:00:00	QQQ	ETF	620.43	620.96	619.29	620.66	4856830.0
2026-01-06 12:00:00	QQQ	ETF	620.65	622.785	620.1499	622.16	3673339.0
2026-01-06 13:00:00	QQQ	ETF	622.18	623.24	621.815	623.22	3266282.0
2026-01-06 14:00:00	QQQ	ETF	623.22	623.61	622.96	623.29	2895460.0
2026-01-06 15:00:00	QQQ	ETF	623.29	624.0213	623.14	623.47	6037738.0
2026-01-06 16:00:00	QQQ	ETF	623.47	623.94	623.38	623.9	1122800.0
2026-01-06 17:00:00	QQQ	ETF	623.8296	624.05	619.29	623.84	68904.0
2026-01-06 18:00:00	QQQ	ETF	623.85	624.19	623.5827	623.73	52883.0
2026-01-06 19:00:00	QQQ	ETF	623.72	624.17	623.63	623.8883	46323.0
2026-01-06 04:00:00	IWM	ETF	252.0	252.28	251.86	251.96	34687.0
2026-01-06 05:00:00	IWM	ETF	251.94	252.25	251.93	252.11	18984.0
2026-01-06 06:00:00	IWM	ETF	252.11	252.2	252.01	252.06	23467.0
2026-01-06 07:00:00	IWM	ETF	252.09	252.42	252.09	252.35	46378.0
2026-01-06 08:00:00	IWM	ETF	252.0836	252.97	251.67	252.22	94986.0
2026-01-06 09:00:00	IWM	ETF	252.23	252.74	251.52	252.43	4987162.0
2026-01-06 10:00:00	IWM	ETF	252.42	253.64	252.21	252.76	5484711.0
2026-01-06 11:00:00	IWM	ETF	252.75	253.3	252.505	252.91	3374004.0
2026-01-06 12:00:00	IWM	ETF	252.91	253.715	252.85	253.62	2370269.0
2026-01-06 13:00:00	IWM	ETF	253.63	254.599	253.59	254.56	2681640.0
2026-01-06 14:00:00	IWM	ETF	254.54	255.47	254.45	255.42	3329747.0
2026-01-06 15:00:00	IWM	ETF	255.42	256.25	255.405	256.08	6265947.0
2026-01-06 16:00:00	IWM	ETF	256.08	256.15	256.0	256.12	845709.0
2026-01-06 17:00:00	IWM	ETF	256.1	256.17	255.86	255.98	32561.0
2026-01-06 18:00:00	IWM	ETF	255.99	256.25	255.94	256.03	32968.0
2026-01-06 19:00:00	IWM	ETF	255.92	256.21	255.92	256.18	15676.0
2026-01-06 04:00:00	DIA	ETF	488.78	489.0	488.57	488.61	11879.0
2026-01-06 05:00:00	DIA	ETF	488.84	489.05	488.84	489.02	855.0

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

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