PREVIEW / etf_1hour / 2025-12-26

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-12-26.parquet
  size:    670 KB
  rows:    26,324

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
2025-12-26 04:00:00	SPY	ETF	690.05	690.39	689.99	690.3	14298.0
2025-12-26 05:00:00	SPY	ETF	690.35	690.54	690.25	690.34	11910.0
2025-12-26 06:00:00	SPY	ETF	690.37	690.41	689.89	690.1	13885.0
2025-12-26 07:00:00	SPY	ETF	690.12	690.5	690.0	690.41	27561.0
2025-12-26 08:00:00	SPY	ETF	690.125	690.8242	689.83	690.55	249101.0
2025-12-26 09:00:00	SPY	ETF	690.58	691.66	690.27	690.77	5368783.0
2025-12-26 10:00:00	SPY	ETF	690.77	691.0001	689.65	690.825	5750588.0
2025-12-26 11:00:00	SPY	ETF	690.825	690.96	689.77	689.99	3917362.0
2025-12-26 12:00:00	SPY	ETF	689.98	690.2	689.39	689.79	3571297.0
2025-12-26 13:00:00	SPY	ETF	689.79	690.29	689.27	690.21	2981076.0
2025-12-26 14:00:00	SPY	ETF	690.205	690.46	689.975	690.155	2989623.0
2025-12-26 15:00:00	SPY	ETF	690.15	690.5	690.005	690.25	8145215.0
2025-12-26 16:00:00	SPY	ETF	690.25	690.37	689.93	689.99	1416800.0
2025-12-26 17:00:00	SPY	ETF	690.0	690.0999	689.9678	690.01	16809.0
2025-12-26 18:00:00	SPY	ETF	690.012	690.2	690.01	690.09	9559.0
2025-12-26 19:00:00	SPY	ETF	690.1	690.1	689.9	689.91	12122.0
2025-12-26 04:00:00	QQQ	ETF	623.93	624.17	623.2	624.12	21433.0
2025-12-26 05:00:00	QQQ	ETF	624.16	624.55	624.14	624.25	19273.0
2025-12-26 06:00:00	QQQ	ETF	624.35	624.42	623.91	624.09	15474.0
2025-12-26 07:00:00	QQQ	ETF	624.13	624.6	623.97	624.49	30608.0
2025-12-26 08:00:00	QQQ	ETF	624.17	625.22	623.38	624.58	237382.0
2025-12-26 09:00:00	QQQ	ETF	624.6	625.515	623.86	624.235	3795986.0
2025-12-26 10:00:00	QQQ	ETF	624.22	624.87	623.14	624.7113	4314766.0
2025-12-26 11:00:00	QQQ	ETF	624.71	624.99	623.7	624.11	2607845.0
2025-12-26 12:00:00	QQQ	ETF	624.1	624.2802	623.5	624.045	2129974.0
2025-12-26 13:00:00	QQQ	ETF	624.05	624.53	623.62	624.5	2260281.0
2025-12-26 14:00:00	QQQ	ETF	624.5	624.67	624.085	624.485	1870541.0
2025-12-26 15:00:00	QQQ	ETF	624.47	624.5	623.67	623.84	5609012.0
2025-12-26 16:00:00	QQQ	ETF	623.86	624.05	623.5999	623.6742	1119503.0
2025-12-26 17:00:00	QQQ	ETF	623.58	623.6321	623.5	623.52	6496.0
2025-12-26 18:00:00	QQQ	ETF	623.52	623.6	623.4103	623.6	7130.0
2025-12-26 19:00:00	QQQ	ETF	623.62	623.6994	623.2	623.2	13656.0
2025-12-26 04:00:00	IWM	ETF	252.31	252.45	252.24	252.3	14610.0
2025-12-26 05:00:00	IWM	ETF	252.3	252.48	252.3	252.4	3910.0
2025-12-26 06:00:00	IWM	ETF	252.44	252.44	252.18	252.26	4252.0
2025-12-26 07:00:00	IWM	ETF	252.28	252.38	252.28	252.36	3277.0
2025-12-26 08:00:00	IWM	ETF	252.34	252.54	252.05	252.42	34270.0
2025-12-26 09:00:00	IWM	ETF	252.44	252.75	250.98	251.33	2166769.0
2025-12-26 10:00:00	IWM	ETF	251.34	251.41	250.395	251.15	2630685.0
2025-12-26 11:00:00	IWM	ETF	251.15	251.345	250.74	251.07	1143951.0
2025-12-26 12:00:00	IWM	ETF	251.08	251.19	250.67	251.02	1211388.0
2025-12-26 13:00:00	IWM	ETF	251.03	251.33	250.78	250.97	1250714.0
2025-12-26 14:00:00	IWM	ETF	250.97	251.26	250.68	250.92	1242550.0
2025-12-26 15:00:00	IWM	ETF	250.925	251.55	250.88	251.39	3242660.0
2025-12-26 16:00:00	IWM	ETF	251.42	251.6	251.34	251.59	713475.0
2025-12-26 17:00:00	IWM	ETF	251.52	251.53	251.31	251.31	9491.0
2025-12-26 18:00:00	IWM	ETF	251.34	251.37	251.3	251.31	1126.0
2025-12-26 19:00:00	IWM	ETF	251.25	251.28	251.06	251.06	4164.0
2025-12-26 04:00:00	DIA	ETF	486.75	486.75	486.64	486.64	220.0
2025-12-26 05:00:00	DIA	ETF	486.72	486.74	486.69	486.69	570.0

> showing 50 of 26,324 rows — these rows as CSV

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