PREVIEW / etf_1hour / 2025-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-12-15.parquet
  size:    719 KB
  rows:    27,959

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-15 04:00:00	SPY	ETF	684.15	684.92	683.87	684.84	41928.0
2025-12-15 05:00:00	SPY	ETF	684.75	685.18	684.68	685.07	30821.0
2025-12-15 06:00:00	SPY	ETF	685.05	685.26	684.86	685.14	52161.0
2025-12-15 07:00:00	SPY	ETF	685.11	685.23	684.45	685.03	378285.0
2025-12-15 08:00:00	SPY	ETF	685.04	685.46	681.73	685.36	420284.0
2025-12-15 09:00:00	SPY	ETF	685.36	685.87	682.3	682.43	9586991.0
2025-12-15 10:00:00	SPY	ETF	682.43	682.585	679.25	681.15	14380369.0
2025-12-15 11:00:00	SPY	ETF	681.14	683.06	680.14	680.88	9624396.0
2025-12-15 12:00:00	SPY	ETF	680.88	681.45	679.42	680.5044	6598582.0
2025-12-15 13:00:00	SPY	ETF	680.5	681.4	679.51	681.02	5618809.0
2025-12-15 14:00:00	SPY	ETF	681.02	681.78	680.44	681.69	6400550.0
2025-12-15 15:00:00	SPY	ETF	681.69	681.74	680.55	680.7	14806844.0
2025-12-15 16:00:00	SPY	ETF	680.71	681.1668	680.55	681.02	2855448.0
2025-12-15 17:00:00	SPY	ETF	680.97	681.23	680.7	681.01	343394.0
2025-12-15 18:00:00	SPY	ETF	681.1	681.4	679.93	680.4	92549.0
2025-12-15 19:00:00	SPY	ETF	680.37	680.5714	679.21	679.48	77576.0
2025-12-15 04:00:00	QQQ	ETF	617.0	617.0	614.65	616.45	89642.0
2025-12-15 05:00:00	QQQ	ETF	616.36	616.84	616.27	616.71	54659.0
2025-12-15 06:00:00	QQQ	ETF	616.71	617.24	616.52	617.18	61538.0
2025-12-15 07:00:00	QQQ	ETF	617.15	617.28	616.4	617.08	202793.0
2025-12-15 08:00:00	QQQ	ETF	617.1502	617.8	613.16	617.73	505404.0
2025-12-15 09:00:00	QQQ	ETF	617.7	618.42	613.65	613.94	6914414.0
2025-12-15 10:00:00	QQQ	ETF	613.93	614.17	609.32	612.16	9221065.0
2025-12-15 11:00:00	QQQ	ETF	612.16	614.91	611.38	612.41	5296969.0
2025-12-15 12:00:00	QQQ	ETF	612.42	612.98	610.51	611.6601	2974867.0
2025-12-15 13:00:00	QQQ	ETF	611.62	612.55	610.43	612.1599	2645431.0
2025-12-15 14:00:00	QQQ	ETF	612.14	612.87	611.03	612.12	2943559.0
2025-12-15 15:00:00	QQQ	ETF	612.1	612.23	610.4	610.49	5419480.0
2025-12-15 16:00:00	QQQ	ETF	610.49	611.05	610.32	610.84	1131821.0
2025-12-15 17:00:00	QQQ	ETF	610.9081	611.0	610.54	610.7	97251.0
2025-12-15 18:00:00	QQQ	ETF	610.77	611.41	609.43	609.7411	166274.0
2025-12-15 19:00:00	QQQ	ETF	609.91	610.01	608.36	608.51	251196.0
2025-12-15 04:00:00	IWM	ETF	255.2	255.79	255.0	255.71	29375.0
2025-12-15 05:00:00	IWM	ETF	255.71	255.84	255.49	255.68	16223.0
2025-12-15 06:00:00	IWM	ETF	255.7	255.75	255.55	255.67	38413.0
2025-12-15 07:00:00	IWM	ETF	255.64	256.13	255.47	255.97	58559.0
2025-12-15 08:00:00	IWM	ETF	255.95	256.15	254.83	256.07	123437.0
2025-12-15 09:00:00	IWM	ETF	255.95	256.26	253.52	253.56	3395595.0
2025-12-15 10:00:00	IWM	ETF	253.55	254.08	252.26	252.57	4674222.0
2025-12-15 11:00:00	IWM	ETF	252.56	253.3	251.805	252.24	3161036.0
2025-12-15 12:00:00	IWM	ETF	252.25	252.78	251.81	252.29	2840257.0
2025-12-15 13:00:00	IWM	ETF	252.28	252.76	251.77	252.575	2010645.0
2025-12-15 14:00:00	IWM	ETF	252.57	252.8401	252.27	252.81	2333172.0
2025-12-15 15:00:00	IWM	ETF	252.81	252.81	251.74	251.93	6730071.0
2025-12-15 16:00:00	IWM	ETF	251.93	252.13	251.76	251.85	945070.0
2025-12-15 17:00:00	IWM	ETF	251.86	252.09	251.81	251.88	23175.0
2025-12-15 18:00:00	IWM	ETF	251.9491	251.98	251.11	251.25	53155.0
2025-12-15 19:00:00	IWM	ETF	251.29	251.4	250.88	250.91	37643.0
2025-12-15 04:00:00	DIA	ETF	487.14	487.45	487.14	487.29	589.0
2025-12-15 05:00:00	DIA	ETF	487.59	487.75	487.59	487.75	1785.0

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

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