PREVIEW / etf_1hour / 2025-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-12-31.parquet
  size:    705 KB
  rows:    27,328

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-31 04:00:00	SPY	ETF	685.14	685.53	685.0	685.24	18519.0
2025-12-31 05:00:00	SPY	ETF	685.12	685.55	685.04	685.38	19414.0
2025-12-31 06:00:00	SPY	ETF	685.45	685.89	685.4	685.89	57597.0
2025-12-31 07:00:00	SPY	ETF	685.88	686.41	685.68	686.32	69227.0
2025-12-31 08:00:00	SPY	ETF	685.77	687.77	685.0	687.52	284993.0
2025-12-31 09:00:00	SPY	ETF	687.52	687.74	685.28	685.96	6654564.0
2025-12-31 10:00:00	SPY	ETF	685.96	686.06	684.18	684.33	7443440.0
2025-12-31 11:00:00	SPY	ETF	684.32	685.43	684.3	685.35	4804235.0
2025-12-31 12:00:00	SPY	ETF	685.355	685.43	684.61	684.805	3455041.0
2025-12-31 13:00:00	SPY	ETF	684.8	686.05	684.72	685.84	4009224.0
2025-12-31 14:00:00	SPY	ETF	685.83	686.24	684.04	684.14	6706877.0
2025-12-31 15:00:00	SPY	ETF	684.14	684.2	681.71	681.84	18505970.0
2025-12-31 16:00:00	SPY	ETF	681.84	682.5	681.8091	682.08	4713592.0
2025-12-31 17:00:00	SPY	ETF	682.11	682.69	682.01	682.6515	71319.0
2025-12-31 18:00:00	SPY	ETF	682.65	682.9	682.65	682.67	51795.0
2025-12-31 19:00:00	SPY	ETF	682.68	682.84	682.5	682.5	24499.0
2025-12-31 04:00:00	QQQ	ETF	618.23	618.23	616.69	617.02	45379.0
2025-12-31 05:00:00	QQQ	ETF	617.0	617.56	616.88	617.41	27863.0
2025-12-31 06:00:00	QQQ	ETF	617.49	618.05	617.36	618.05	17506.0
2025-12-31 07:00:00	QQQ	ETF	617.99	618.54	617.84	618.5	63949.0
2025-12-31 08:00:00	QQQ	ETF	617.99	620.5	616.77	620.2	286805.0
2025-12-31 09:00:00	QQQ	ETF	620.22	620.57	617.3312	617.92	4613214.0
2025-12-31 10:00:00	QQQ	ETF	617.93	618.2	616.45	616.745	4455623.0
2025-12-31 11:00:00	QQQ	ETF	616.73	617.97	616.69	617.9154	3061802.0
2025-12-31 12:00:00	QQQ	ETF	617.91	617.94	617.04	617.35	2413159.0
2025-12-31 13:00:00	QQQ	ETF	617.35	618.48	617.15	618.13	2397465.0
2025-12-31 14:00:00	QQQ	ETF	618.12	618.6	616.19	616.29	3474685.0
2025-12-31 15:00:00	QQQ	ETF	616.28	616.37	614.05	614.28	8846201.0
2025-12-31 16:00:00	QQQ	ETF	614.26	614.67	613.73	613.78	1273895.0
2025-12-31 17:00:00	QQQ	ETF	613.879	614.31	613.84	614.3	52925.0
2025-12-31 18:00:00	QQQ	ETF	614.27	614.35	614.23	614.33	26284.0
2025-12-31 19:00:00	QQQ	ETF	614.33	614.36	614.2	614.26	20591.0
2025-12-31 04:00:00	IWM	ETF	247.29	247.41	246.81	247.36	65434.0
2025-12-31 05:00:00	IWM	ETF	247.41	247.53	247.28	247.43	17066.0
2025-12-31 06:00:00	IWM	ETF	247.4	247.55	247.4	247.51	5636.0
2025-12-31 07:00:00	IWM	ETF	247.45	247.93	247.45	247.87	47403.0
2025-12-31 08:00:00	IWM	ETF	247.46	248.35	246.95	248.3	140930.0
2025-12-31 09:00:00	IWM	ETF	248.23	248.34	247.24	247.775	3376572.0
2025-12-31 10:00:00	IWM	ETF	247.775	247.79	246.7544	247.005	3773121.0
2025-12-31 11:00:00	IWM	ETF	247.0	247.35	246.875	247.095	2531340.0
2025-12-31 12:00:00	IWM	ETF	247.105	247.38	246.905	247.005	1709085.0
2025-12-31 13:00:00	IWM	ETF	247.005	247.35	246.975	247.3	1438380.0
2025-12-31 14:00:00	IWM	ETF	247.3	247.47	246.515	246.59	2063160.0
2025-12-31 15:00:00	IWM	ETF	246.61	246.63	246.01	246.19	8424521.0
2025-12-31 16:00:00	IWM	ETF	246.19	246.55	246.11	246.26	3775779.0
2025-12-31 17:00:00	IWM	ETF	246.3	246.47	246.22	246.43	12144.0
2025-12-31 18:00:00	IWM	ETF	246.47	246.61	246.41	246.41	10163.0
2025-12-31 19:00:00	IWM	ETF	246.53	246.6754	246.35	246.6754	4112.0
2025-12-31 04:00:00	DIA	ETF	482.97	483.15	482.97	483.15	4149.0
2025-12-31 05:00:00	DIA	ETF	482.84	482.97	482.84	482.97	510.0

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

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