PREVIEW / etf_1hour / 2026-01-15

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-01-15.parquet
  size:    742 KB
  rows:    28,815

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-15 04:00:00	SPY	ETF	691.1	693.02	690.65	692.55	49055.0
2026-01-15 05:00:00	SPY	ETF	692.64	692.9	692.46	692.75	67597.0
2026-01-15 06:00:00	SPY	ETF	692.73	693.2	692.5	692.9	292588.0
2026-01-15 07:00:00	SPY	ETF	692.9	693.3	692.52	693.0	285894.0
2026-01-15 08:00:00	SPY	ETF	692.99	694.0	689.5	693.51	663512.0
2026-01-15 09:00:00	SPY	ETF	693.55	694.8	693.18	693.61	8849000.0
2026-01-15 10:00:00	SPY	ETF	693.61	694.9	692.99	694.45	11429428.0
2026-01-15 11:00:00	SPY	ETF	694.45	695.345	694.34	695.03	6265920.0
2026-01-15 12:00:00	SPY	ETF	695.0399	695.45	693.905	693.98	5369636.0
2026-01-15 13:00:00	SPY	ETF	693.98	695.25	693.88	694.7158	4603687.0
2026-01-15 14:00:00	SPY	ETF	694.71	694.71	692.58	692.78	8075189.0
2026-01-15 15:00:00	SPY	ETF	692.77	693.03	691.25	692.18	15877720.0
2026-01-15 16:00:00	SPY	ETF	692.19	692.33	691.85	692.1	3704618.0
2026-01-15 17:00:00	SPY	ETF	692.1	692.45	692.05	692.3766	75004.0
2026-01-15 18:00:00	SPY	ETF	692.24	692.8	692.01	692.7	186308.0
2026-01-15 19:00:00	SPY	ETF	692.65	692.98	692.5	692.9387	32610.0
2026-01-15 04:00:00	QQQ	ETF	622.14	624.47	622.04	623.95	231433.0
2026-01-15 05:00:00	QQQ	ETF	623.95	624.37	623.64	624.11	145340.0
2026-01-15 06:00:00	QQQ	ETF	624.16	625.08	624.14	624.7	334599.0
2026-01-15 07:00:00	QQQ	ETF	624.7	625.0	623.91	624.88	341604.0
2026-01-15 08:00:00	QQQ	ETF	623.1	626.42	618.4	625.8802	1227194.0
2026-01-15 09:00:00	QQQ	ETF	625.88	627.27	624.66	625.16	8282654.0
2026-01-15 10:00:00	QQQ	ETF	625.155	630.0	623.76	625.7	7703209.0
2026-01-15 11:00:00	QQQ	ETF	625.69	626.98	625.55	626.64	3958527.0
2026-01-15 12:00:00	QQQ	ETF	626.64	626.96	624.86	624.96	3382432.0
2026-01-15 13:00:00	QQQ	ETF	624.96	626.32	624.85	625.7371	2453129.0
2026-01-15 14:00:00	QQQ	ETF	625.71	625.72	622.36	622.62	6068930.0
2026-01-15 15:00:00	QQQ	ETF	622.62	622.96	620.75	621.66	8247430.0
2026-01-15 16:00:00	QQQ	ETF	621.68	621.87	621.09	621.42	1204655.0
2026-01-15 17:00:00	QQQ	ETF	621.41	622.1	621.33	621.83	80095.0
2026-01-15 18:00:00	QQQ	ETF	621.72	622.4871	621.38	622.24	129537.0
2026-01-15 19:00:00	QQQ	ETF	622.24	622.76	622.04	622.74	61646.0
2026-01-15 04:00:00	IWM	ETF	263.76	264.03	263.62	263.69	55395.0
2026-01-15 05:00:00	IWM	ETF	263.64	264.22	263.64	263.87	21537.0
2026-01-15 06:00:00	IWM	ETF	263.85	264.06	263.23	263.27	24903.0
2026-01-15 07:00:00	IWM	ETF	263.24	263.94	263.2	263.93	96993.0
2026-01-15 08:00:00	IWM	ETF	263.91	264.1	263.17	263.47	152934.0
2026-01-15 09:00:00	IWM	ETF	263.48	264.8	263.44	264.2442	3497522.0
2026-01-15 10:00:00	IWM	ETF	264.24	266.58	264.24	266.43	4333783.0
2026-01-15 11:00:00	IWM	ETF	266.43	267.045	266.27	266.33	3931698.0
2026-01-15 12:00:00	IWM	ETF	266.33	266.69	266.005	266.045	1894415.0
2026-01-15 13:00:00	IWM	ETF	266.015	266.77	266.015	266.6	1429640.0
2026-01-15 14:00:00	IWM	ETF	266.61	266.97	266.11	266.47	2382707.0
2026-01-15 15:00:00	IWM	ETF	266.47	266.48	265.34	265.51	4483856.0
2026-01-15 16:00:00	IWM	ETF	265.52	265.62	265.44	265.54	762113.0
2026-01-15 17:00:00	IWM	ETF	265.55	265.74	265.18	265.69	41233.0
2026-01-15 18:00:00	IWM	ETF	265.59	265.84	265.56	265.78	13542.0
2026-01-15 19:00:00	IWM	ETF	265.7505	265.9	265.63	265.9	43022.0
2026-01-15 04:00:00	DIA	ETF	491.75	492.18	491.74	491.95	2504.0
2026-01-15 05:00:00	DIA	ETF	491.87	492.07	491.82	492.06	1950.0

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

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