PREVIEW / etf_1hour / 2025-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-12-22.parquet
  size:    725 KB
  rows:    28,526

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-22 04:00:00	SPY	ETF	681.5	683.02	681.5	682.93	24296.0
2025-12-22 05:00:00	SPY	ETF	682.87	683.02	682.81	682.93	17004.0
2025-12-22 06:00:00	SPY	ETF	682.95	683.16	682.81	682.93	27376.0
2025-12-22 07:00:00	SPY	ETF	682.92	683.31	682.75	683.269	144918.0
2025-12-22 08:00:00	SPY	ETF	682.97	683.71	682.02	683.67	289587.0
2025-12-22 09:00:00	SPY	ETF	683.66	684.53	682.94	683.97	7624480.0
2025-12-22 10:00:00	SPY	ETF	683.975	684.12	682.68	683.65	7537431.0
2025-12-22 11:00:00	SPY	ETF	683.64	684.975	683.64	684.95	5957363.0
2025-12-22 12:00:00	SPY	ETF	684.96	685.36	684.52	685.21	4929359.0
2025-12-22 13:00:00	SPY	ETF	685.21	685.22	684.35	684.505	4574263.0
2025-12-22 14:00:00	SPY	ETF	684.5	685.01	684.205	684.79	4893069.0
2025-12-22 15:00:00	SPY	ETF	684.79	685.1499	684.61	684.79	12742877.0
2025-12-22 16:00:00	SPY	ETF	684.795	685.09	684.72	684.92	3718600.0
2025-12-22 17:00:00	SPY	ETF	684.93	684.95	684.72	684.8	117987.0
2025-12-22 18:00:00	SPY	ETF	684.83	685.14	684.76	684.87	74119.0
2025-12-22 19:00:00	SPY	ETF	684.8901	685.06	684.8	685.0599	49922.0
2025-12-22 04:00:00	QQQ	ETF	618.87	619.98	618.87	619.7	73763.0
2025-12-22 05:00:00	QQQ	ETF	619.68	619.89	619.58	619.59	44858.0
2025-12-22 06:00:00	QQQ	ETF	619.57	619.85	619.45	619.45	45585.0
2025-12-22 07:00:00	QQQ	ETF	619.47	620.37	619.4	620.32	125456.0
2025-12-22 08:00:00	QQQ	ETF	620.33	620.78	617.512	620.74	358024.0
2025-12-22 09:00:00	QQQ	ETF	620.74	621.65	618.7525	620.58	6227246.0
2025-12-22 10:00:00	QQQ	ETF	620.57	620.74	617.77	618.8579	6185272.0
2025-12-22 11:00:00	QQQ	ETF	618.86	619.94	618.81	619.81	4903655.0
2025-12-22 12:00:00	QQQ	ETF	619.82	620.08	619.13	619.955	3686441.0
2025-12-22 13:00:00	QQQ	ETF	619.94	619.97	618.82	619.18	3746736.0
2025-12-22 14:00:00	QQQ	ETF	619.18	619.71	618.86	619.19	3274113.0
2025-12-22 15:00:00	QQQ	ETF	619.19	619.49	618.93	619.16	5501856.0
2025-12-22 16:00:00	QQQ	ETF	619.18	619.59	619.16	619.45	1046283.0
2025-12-22 17:00:00	QQQ	ETF	619.44	619.71	619.21	619.51	47422.0
2025-12-22 18:00:00	QQQ	ETF	619.53	619.969	619.52	619.7	42985.0
2025-12-22 19:00:00	QQQ	ETF	619.75	619.97	619.67	619.92	36388.0
2025-12-22 04:00:00	IWM	ETF	251.08	251.75	251.08	251.69	33082.0
2025-12-22 05:00:00	IWM	ETF	251.69	251.82	251.65	251.73	12822.0
2025-12-22 06:00:00	IWM	ETF	251.74	251.89	251.73	251.89	6096.0
2025-12-22 07:00:00	IWM	ETF	251.87	251.99	251.77	251.99	14053.0
2025-12-22 08:00:00	IWM	ETF	251.9389	252.43	251.09	252.43	86831.0
2025-12-22 09:00:00	IWM	ETF	252.39	253.535	252.2	253.445	5025202.0
2025-12-22 10:00:00	IWM	ETF	253.44	254.49	253.42	254.44	4203672.0
2025-12-22 11:00:00	IWM	ETF	254.44	255.115	254.27	254.965	3648678.0
2025-12-22 12:00:00	IWM	ETF	254.96	255.04	254.28	254.81	2897483.0
2025-12-22 13:00:00	IWM	ETF	254.81	254.81	253.98	254.07	2012332.0
2025-12-22 14:00:00	IWM	ETF	254.07	254.155	253.565	253.93	2091233.0
2025-12-22 15:00:00	IWM	ETF	253.94	254.06	253.235	253.59	4358906.0
2025-12-22 16:00:00	IWM	ETF	253.58	253.76	253.4	253.45	1300868.0
2025-12-22 17:00:00	IWM	ETF	253.57	253.58	253.4142	253.53	17727.0
2025-12-22 18:00:00	IWM	ETF	253.52	253.6	253.46	253.55	23317.0
2025-12-22 19:00:00	IWM	ETF	253.55	253.6	253.47	253.564	15968.0
2025-12-22 04:00:00	DIA	ETF	481.44	481.73	481.44	481.63	4550.0
2025-12-22 05:00:00	DIA	ETF	481.66	481.72	481.65	481.66	860.0

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

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