PREVIEW / etf_1hour / 2026-01-23

all etf 1-hour files

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

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-23 04:00:00	SPY	ETF	690.39	690.39	687.23	687.6	106553.0
2026-01-23 05:00:00	SPY	ETF	687.57	687.75	687.28	687.6	35204.0
2026-01-23 06:00:00	SPY	ETF	687.65	689.02	687.6	688.0	138023.0
2026-01-23 07:00:00	SPY	ETF	687.99	688.86	687.77	688.67	158265.0
2026-01-23 08:00:00	SPY	ETF	688.8199	690.93	687.23	687.42	537601.0
2026-01-23 09:00:00	SPY	ETF	687.47	688.81	687.121	688.77	6758982.0
2026-01-23 10:00:00	SPY	ETF	688.83	690.71	688.31	690.48	7925828.0
2026-01-23 11:00:00	SPY	ETF	690.47	690.96	689.42	689.7481	6131689.0
2026-01-23 12:00:00	SPY	ETF	689.75	690.35	687.73	687.99	6246933.0
2026-01-23 13:00:00	SPY	ETF	687.98	689.28	687.86	688.97	4796004.0
2026-01-23 14:00:00	SPY	ETF	688.97	690.1995	688.91	689.53	5927277.0
2026-01-23 15:00:00	SPY	ETF	689.52	689.61	688.51	689.185	10776042.0
2026-01-23 16:00:00	SPY	ETF	689.18	689.2542	687.9	688.01	3220777.0
2026-01-23 17:00:00	SPY	ETF	688.05	688.5	687.85	688.15	101519.0
2026-01-23 18:00:00	SPY	ETF	688.15	688.39	688.15	688.3	13204.0
2026-01-23 19:00:00	SPY	ETF	688.29	688.45	687.9	687.99	27907.0
2026-01-23 04:00:00	QQQ	ETF	622.04	622.04	618.09	618.56	136609.0
2026-01-23 05:00:00	QQQ	ETF	618.51	618.88	618.37	618.85	55080.0
2026-01-23 06:00:00	QQQ	ETF	618.9	620.89	618.78	619.6	224621.0
2026-01-23 07:00:00	QQQ	ETF	619.66	620.3	619.17	620.19	126829.0
2026-01-23 08:00:00	QQQ	ETF	619.68	622.67	618.21	618.84	503026.0
2026-01-23 09:00:00	QQQ	ETF	618.86	621.13	618.49	621.13	5733405.0
2026-01-23 10:00:00	QQQ	ETF	621.08	624.97	621.08	624.945	7557451.0
2026-01-23 11:00:00	QQQ	ETF	624.95	625.3999	623.38	624.04	5446567.0
2026-01-23 12:00:00	QQQ	ETF	624.05	624.49	621.535	621.78	4134520.0
2026-01-23 13:00:00	QQQ	ETF	621.78	623.488	621.67	622.56	3470328.0
2026-01-23 14:00:00	QQQ	ETF	622.57	623.74	622.41	623.11	2752575.0
2026-01-23 15:00:00	QQQ	ETF	623.09	623.26	621.74	622.78	6446725.0
2026-01-23 16:00:00	QQQ	ETF	622.79	623.1	621.3	621.42	1253487.0
2026-01-23 17:00:00	QQQ	ETF	621.55	621.79	621.23	621.38	108954.0
2026-01-23 18:00:00	QQQ	ETF	621.4194	621.7018	621.36	621.5211	24184.0
2026-01-23 19:00:00	QQQ	ETF	621.56	621.75	621.5	621.59	22429.0
2026-01-23 04:00:00	IWM	ETF	269.7	269.95	269.28	269.59	40062.0
2026-01-23 05:00:00	IWM	ETF	269.48	269.54	269.26	269.45	11240.0
2026-01-23 06:00:00	IWM	ETF	269.5	269.76	269.29	269.33	43932.0
2026-01-23 07:00:00	IWM	ETF	269.32	269.79	269.16	269.75	58963.0
2026-01-23 08:00:00	IWM	ETF	269.26	270.49	268.72	268.75	213834.0
2026-01-23 09:00:00	IWM	ETF	268.781	269.05	267.55	268.1	3453263.0
2026-01-23 10:00:00	IWM	ETF	268.13	268.21	266.51	267.085	5283013.0
2026-01-23 11:00:00	IWM	ETF	267.08	267.42	266.08	266.14	3331181.0
2026-01-23 12:00:00	IWM	ETF	266.14	266.47	264.57	264.7651	4475821.0
2026-01-23 13:00:00	IWM	ETF	264.76	265.44	264.5477	264.995	3163398.0
2026-01-23 14:00:00	IWM	ETF	265.0	265.7	264.88	265.045	2453537.0
2026-01-23 15:00:00	IWM	ETF	265.04	265.265	264.46	264.82	6696911.0
2026-01-23 16:00:00	IWM	ETF	264.82	264.82	263.92	263.98	1204157.0
2026-01-23 17:00:00	IWM	ETF	264.059	264.21	263.8	263.8	48169.0
2026-01-23 18:00:00	IWM	ETF	263.8	263.92	263.79	263.81	21507.0
2026-01-23 19:00:00	IWM	ETF	263.85	263.96	263.69	263.85	5911.0
2026-01-23 04:00:00	DIA	ETF	493.27	493.56	492.84	492.87	2840.0
2026-01-23 05:00:00	DIA	ETF	492.67	492.67	492.5	492.5	87.0

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

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