PREVIEW / etf_1hour / 2026-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-22.parquet
  size:    749 KB
  rows:    29,210

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-22 04:00:00	SPY	ETF	688.0	689.86	688.0	689.57	109677.0
2026-01-22 05:00:00	SPY	ETF	689.57	689.63	688.9	689.42	53961.0
2026-01-22 06:00:00	SPY	ETF	689.38	689.73	688.66	688.78	113251.0
2026-01-22 07:00:00	SPY	ETF	688.75	689.09	688.45	688.99	288814.0
2026-01-22 08:00:00	SPY	ETF	688.75	690.06	685.44	690.01	517702.0
2026-01-22 09:00:00	SPY	ETF	690.0	690.67	687.38	687.89	11695407.0
2026-01-22 10:00:00	SPY	ETF	687.89	689.49	686.92	688.63	9446354.0
2026-01-22 11:00:00	SPY	ETF	688.62	690.5	688.58	689.715	5224511.0
2026-01-22 12:00:00	SPY	ETF	689.71	691.08	689.405	690.955	4946629.0
2026-01-22 13:00:00	SPY	ETF	690.95	691.125	689.83	690.025	4265597.0
2026-01-22 14:00:00	SPY	ETF	690.01	690.96	688.74	688.77	7289286.0
2026-01-22 15:00:00	SPY	ETF	688.76	689.51	687.595	688.93	13444891.0
2026-01-22 16:00:00	SPY	ETF	688.93	689.17	687.911	688.3997	4396528.0
2026-01-22 17:00:00	SPY	ETF	688.3111	688.6	688.18	688.36	116921.0
2026-01-22 18:00:00	SPY	ETF	688.23	688.76	687.7502	688.43	71760.0
2026-01-22 19:00:00	SPY	ETF	688.42	689.329	688.15	689.329	32818.0
2026-01-22 04:00:00	QQQ	ETF	619.65	622.06	619.65	621.64	166736.0
2026-01-22 05:00:00	QQQ	ETF	621.73	621.77	620.98	621.49	127959.0
2026-01-22 06:00:00	QQQ	ETF	621.43	622.04	620.9	621.04	202227.0
2026-01-22 07:00:00	QQQ	ETF	621.05	621.55	620.71	621.45	168721.0
2026-01-22 08:00:00	QQQ	ETF	621.03	622.6169	616.58	622.54	788863.0
2026-01-22 09:00:00	QQQ	ETF	622.5329	622.6	618.15	618.81	7545177.0
2026-01-22 10:00:00	QQQ	ETF	618.82	620.71	617.78	619.44	6305823.0
2026-01-22 11:00:00	QQQ	ETF	619.43	621.67	619.38	620.9201	3891197.0
2026-01-22 12:00:00	QQQ	ETF	620.92	622.2	620.55	621.97	2850815.0
2026-01-22 13:00:00	QQQ	ETF	621.96	622.24	620.9	621.06	2732297.0
2026-01-22 14:00:00	QQQ	ETF	621.03	622.03	620.11	620.24	2859177.0
2026-01-22 15:00:00	QQQ	ETF	620.23	620.83	618.91	620.78	6756847.0
2026-01-22 16:00:00	QQQ	ETF	620.75	621.1	619.54	620.09	803169.0
2026-01-22 17:00:00	QQQ	ETF	619.98	620.4	619.66	619.8088	135956.0
2026-01-22 18:00:00	QQQ	ETF	619.74	619.9853	618.89	619.6718	89228.0
2026-01-22 19:00:00	QQQ	ETF	619.62	620.58	619.25	620.55	73536.0
2026-01-22 04:00:00	IWM	ETF	269.17	269.66	268.55	269.62	57807.0
2026-01-22 05:00:00	IWM	ETF	269.55	269.62	269.21	269.58	34058.0
2026-01-22 06:00:00	IWM	ETF	269.62	269.68	268.88	269.03	33851.0
2026-01-22 07:00:00	IWM	ETF	268.95	269.18	268.82	268.9	27371.0
2026-01-22 08:00:00	IWM	ETF	268.97	269.66	267.85	269.64	217268.0
2026-01-22 09:00:00	IWM	ETF	269.63	270.95	269.42	270.34	4051919.0
2026-01-22 10:00:00	IWM	ETF	270.34	271.57	269.66	271.27	3660831.0
2026-01-22 11:00:00	IWM	ETF	271.28	271.55	270.655	270.86	2060460.0
2026-01-22 12:00:00	IWM	ETF	270.85	271.595	270.67	271.325	1550706.0
2026-01-22 13:00:00	IWM	ETF	271.31	271.385	270.61	270.73	1654874.0
2026-01-22 14:00:00	IWM	ETF	270.73	270.945	269.94	269.96	1943794.0
2026-01-22 15:00:00	IWM	ETF	269.95	270.375	269.4601	269.81	4983882.0
2026-01-22 16:00:00	IWM	ETF	269.79	269.88	269.41	269.41	1614533.0
2026-01-22 17:00:00	IWM	ETF	269.58	269.7	269.44	269.5223	10271.0
2026-01-22 18:00:00	IWM	ETF	269.69	269.82	269.41	269.71	39369.0
2026-01-22 19:00:00	IWM	ETF	269.65	270.06	269.56	270.05	38288.0
2026-01-22 04:00:00	DIA	ETF	492.31	492.85	492.02	492.75	4235.0
2026-01-22 05:00:00	DIA	ETF	492.61	492.68	492.35	492.66	4575.0

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

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