PREVIEW / etf_1hour / 2025-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-12-23.parquet
  size:    723 KB
  rows:    27,617

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-23 04:00:00	SPY	ETF	684.85	685.55	684.84	685.46	51694.0
2025-12-23 05:00:00	SPY	ETF	685.49	685.57	685.05	685.21	15838.0
2025-12-23 06:00:00	SPY	ETF	685.2	685.26	684.9	684.98	29676.0
2025-12-23 07:00:00	SPY	ETF	684.93	685.08	684.37	684.77	27231.0
2025-12-23 08:00:00	SPY	ETF	684.98	685.56	683.32	683.57	449730.0
2025-12-23 09:00:00	SPY	ETF	683.55	686.25	683.37	685.41	5809101.0
2025-12-23 10:00:00	SPY	ETF	685.4101	686.485	684.36	686.32	7979174.0
2025-12-23 11:00:00	SPY	ETF	686.33	687.0088	686.255	686.89	5712617.0
2025-12-23 12:00:00	SPY	ETF	686.9	687.22	686.66	686.985	4936023.0
2025-12-23 13:00:00	SPY	ETF	686.99	687.7299	686.92	687.53	4938388.0
2025-12-23 14:00:00	SPY	ETF	687.53	687.93	687.495	687.835	4988424.0
2025-12-23 15:00:00	SPY	ETF	687.835	688.2	687.64	687.91	11833318.0
2025-12-23 16:00:00	SPY	ETF	687.92	688.05	687.57	687.7	2929022.0
2025-12-23 17:00:00	SPY	ETF	687.659	687.96	687.5413	687.68	196676.0
2025-12-23 18:00:00	SPY	ETF	687.68	687.75	687.44	687.63	76987.0
2025-12-23 19:00:00	SPY	ETF	687.6411	687.8	687.59	687.6757	18187.0
2025-12-23 04:00:00	QQQ	ETF	619.35	620.18	619.27	619.93	65287.0
2025-12-23 05:00:00	QQQ	ETF	619.99	620.1	619.5	619.76	89067.0
2025-12-23 06:00:00	QQQ	ETF	619.68	619.72	619.19	619.28	69277.0
2025-12-23 07:00:00	QQQ	ETF	619.33	619.52	618.59	619.18	61389.0
2025-12-23 08:00:00	QQQ	ETF	619.21	620.17	617.35	617.64	465413.0
2025-12-23 09:00:00	QQQ	ETF	617.63	620.715	617.39	619.3101	5987491.0
2025-12-23 10:00:00	QQQ	ETF	619.33	620.48	617.78	620.23	5492691.0
2025-12-23 11:00:00	QQQ	ETF	620.25	621.31	620.14	621.23	4089181.0
2025-12-23 12:00:00	QQQ	ETF	621.24	621.33	620.69	620.7876	2997192.0
2025-12-23 13:00:00	QQQ	ETF	620.78	621.405	620.7287	621.25	2876181.0
2025-12-23 14:00:00	QQQ	ETF	621.25	621.88	621.2182	621.8	2945411.0
2025-12-23 15:00:00	QQQ	ETF	621.8	622.41	621.76	622.21	5675722.0
2025-12-23 16:00:00	QQQ	ETF	622.22	622.47	622.04	622.24	1224071.0
2025-12-23 17:00:00	QQQ	ETF	622.2422	622.2422	622.0	622.11	59508.0
2025-12-23 18:00:00	QQQ	ETF	622.15	622.35	622.02	622.15	44388.0
2025-12-23 19:00:00	QQQ	ETF	622.17	622.5	622.17	622.35	24856.0
2025-12-23 04:00:00	IWM	ETF	253.45	253.69	253.39	253.67	14051.0
2025-12-23 05:00:00	IWM	ETF	253.64	253.74	253.48	253.54	8497.0
2025-12-23 06:00:00	IWM	ETF	253.54	253.58	253.16	253.16	40557.0
2025-12-23 07:00:00	IWM	ETF	253.16	253.18	252.969	253.07	21753.0
2025-12-23 08:00:00	IWM	ETF	252.97	253.68	252.12	252.18	234771.0
2025-12-23 09:00:00	IWM	ETF	252.15	253.22	251.93	252.22	3031051.0
2025-12-23 10:00:00	IWM	ETF	252.22	252.9	251.46	252.3	3452283.0
2025-12-23 11:00:00	IWM	ETF	252.295	252.485	251.64	252.32	2679653.0
2025-12-23 12:00:00	IWM	ETF	252.315	252.5901	251.91	251.99	2281339.0
2025-12-23 13:00:00	IWM	ETF	251.99	252.605	251.9693	252.18	1158777.0
2025-12-23 14:00:00	IWM	ETF	252.18	252.355	252.05	252.21	1092759.0
2025-12-23 15:00:00	IWM	ETF	252.21	252.635	252.0	252.07	2948447.0
2025-12-23 16:00:00	IWM	ETF	252.08	252.11	251.84	251.97	870963.0
2025-12-23 17:00:00	IWM	ETF	252.0	252.08	251.92	252.05	16500.0
2025-12-23 18:00:00	IWM	ETF	252.0	252.06	251.9	251.95	12600.0
2025-12-23 19:00:00	IWM	ETF	252.05	252.12	251.98	251.98	5268.0
2025-12-23 04:00:00	DIA	ETF	483.44	483.82	483.43	483.81	966.0
2025-12-23 05:00:00	DIA	ETF	483.83	483.86	483.53	483.53	924.0

> showing 50 of 27,617 rows — these rows as CSV

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