PREVIEW / etf_1hour / 2026-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-07.parquet
  size:    743 KB
  rows:    28,608

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-07 04:00:00	SPY	ETF	690.77	691.45	690.0	691.18	28346.0
2026-01-07 05:00:00	SPY	ETF	691.18	691.44	690.85	691.14	21594.0
2026-01-07 06:00:00	SPY	ETF	691.09	691.54	691.04	691.53	27986.0
2026-01-07 07:00:00	SPY	ETF	691.52	691.8	691.29	691.661	252739.0
2026-01-07 08:00:00	SPY	ETF	691.63	692.29	690.87	692.22	387788.0
2026-01-07 09:00:00	SPY	ETF	692.23	693.09	691.71	692.5666	6132710.0
2026-01-07 10:00:00	SPY	ETF	692.6	692.77	690.96	692.505	11068018.0
2026-01-07 11:00:00	SPY	ETF	692.51	693.56	691.92	693.505	6146071.0
2026-01-07 12:00:00	SPY	ETF	693.52	693.96	692.78	692.99	6032398.0
2026-01-07 13:00:00	SPY	ETF	692.99	693.145	692.04	692.825	6728089.0
2026-01-07 14:00:00	SPY	ETF	692.83	692.89	691.45	691.74	7061156.0
2026-01-07 15:00:00	SPY	ETF	691.75	691.815	689.32	689.59	17080749.0
2026-01-07 16:00:00	SPY	ETF	689.585	690.03	689.14	690.0	2340352.0
2026-01-07 17:00:00	SPY	ETF	690.01	692.17	689.82	689.95	62538.0
2026-01-07 18:00:00	SPY	ETF	689.97	690.23	689.7	689.75	60774.0
2026-01-07 19:00:00	SPY	ETF	689.77	690.15	689.58	690.11	24539.0
2026-01-07 04:00:00	QQQ	ETF	622.85	622.85	621.47	622.1	126673.0
2026-01-07 05:00:00	QQQ	ETF	622.08	622.3	621.5	621.76	58317.0
2026-01-07 06:00:00	QQQ	ETF	621.74	622.47	621.6	622.47	51514.0
2026-01-07 07:00:00	QQQ	ETF	622.48	622.82	622.17	622.45	137352.0
2026-01-07 08:00:00	QQQ	ETF	622.43	623.2	621.5	622.99	430285.0
2026-01-07 09:00:00	QQQ	ETF	623.01	625.15	622.35	624.6	5619256.0
2026-01-07 10:00:00	QQQ	ETF	624.63	625.91	623.52	625.78	6370446.0
2026-01-07 11:00:00	QQQ	ETF	625.79	627.34	625.1441	627.31	4645698.0
2026-01-07 12:00:00	QQQ	ETF	627.31	627.94	627.11	627.33	3606024.0
2026-01-07 13:00:00	QQQ	ETF	627.32	627.54	626.28	626.99	3611868.0
2026-01-07 14:00:00	QQQ	ETF	626.99	627.005	625.44	625.715	3846398.0
2026-01-07 15:00:00	QQQ	ETF	625.715	625.99	623.62	624.06	7972267.0
2026-01-07 16:00:00	QQQ	ETF	624.08	624.21	623.71	624.09	999820.0
2026-01-07 17:00:00	QQQ	ETF	624.1	624.18	624.0	624.03	80756.0
2026-01-07 18:00:00	QQQ	ETF	624.1	624.39	623.691	623.79	52431.0
2026-01-07 19:00:00	QQQ	ETF	623.75	624.25	623.43	624.25	45283.0
2026-01-07 04:00:00	IWM	ETF	256.47	256.63	256.09	256.22	41257.0
2026-01-07 05:00:00	IWM	ETF	256.11	256.32	255.94	255.99	14025.0
2026-01-07 06:00:00	IWM	ETF	255.96	256.22	255.87	256.07	6438.0
2026-01-07 07:00:00	IWM	ETF	256.09	256.11	255.64	255.86	48775.0
2026-01-07 08:00:00	IWM	ETF	255.84	256.82	255.61	256.38	197865.0
2026-01-07 09:00:00	IWM	ETF	256.39	256.795	255.26	255.43	3390118.0
2026-01-07 10:00:00	IWM	ETF	255.46	255.46	253.97	255.04	5298479.0
2026-01-07 11:00:00	IWM	ETF	255.05	256.12	254.6898	256.0	2937714.0
2026-01-07 12:00:00	IWM	ETF	256.015	256.23	255.06	255.12	2274300.0
2026-01-07 13:00:00	IWM	ETF	255.12	255.315	254.82	255.3	2589226.0
2026-01-07 14:00:00	IWM	ETF	255.31	255.895	254.98	255.875	2545806.0
2026-01-07 15:00:00	IWM	ETF	255.875	255.955	254.9201	255.47	4448756.0
2026-01-07 16:00:00	IWM	ETF	255.46	255.76	255.33	255.71	853974.0
2026-01-07 17:00:00	IWM	ETF	255.65	255.67	255.5	255.5011	21464.0
2026-01-07 18:00:00	IWM	ETF	255.62	255.72	255.15	255.2	42959.0
2026-01-07 19:00:00	IWM	ETF	255.19	255.37	255.08	255.37	24469.0
2026-01-07 04:00:00	DIA	ETF	495.13	495.3	494.94	494.94	2439.0
2026-01-07 05:00:00	DIA	ETF	494.87	494.9	494.68	494.9	1940.0

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

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