PREVIEW / etf_1hour / 2025-12-04

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-12-04.parquet
  size:    704 KB
  rows:    27,075

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-04 04:00:00	SPY	ETF	683.66	684.68	683.28	684.52	22975.0
2025-12-04 05:00:00	SPY	ETF	684.55	684.62	683.88	684.03	23545.0
2025-12-04 06:00:00	SPY	ETF	683.89	684.27	683.75	684.26	27326.0
2025-12-04 07:00:00	SPY	ETF	684.24	684.8	684.19	684.53	62048.0
2025-12-04 08:00:00	SPY	ETF	684.48	684.79	683.21	684.16	224102.0
2025-12-04 09:00:00	SPY	ETF	684.12	685.72	682.75	683.045	6472307.0
2025-12-04 10:00:00	SPY	ETF	683.06	684.56	682.17	683.29	7137244.0
2025-12-04 11:00:00	SPY	ETF	683.28	684.56	682.21	684.42	5607441.0
2025-12-04 12:00:00	SPY	ETF	684.4	684.58	683.37	684.305	3970551.0
2025-12-04 13:00:00	SPY	ETF	684.29	684.77	683.465	684.12	3958081.0
2025-12-04 14:00:00	SPY	ETF	684.11	684.23	681.34	683.23	7876315.0
2025-12-04 15:00:00	SPY	ETF	683.24	684.58	682.31	684.4	10233760.0
2025-12-04 16:00:00	SPY	ETF	684.42	684.54	684.07	684.33	2629087.0
2025-12-04 17:00:00	SPY	ETF	684.28	684.28	684.05	684.11	37715.0
2025-12-04 18:00:00	SPY	ETF	684.18	684.66	683.87	684.09	47324.0
2025-12-04 19:00:00	SPY	ETF	684.06	684.8103	683.97	684.75	81738.0
2025-12-04 04:00:00	QQQ	ETF	623.08	624.44	622.54	624.34	80315.0
2025-12-04 05:00:00	QQQ	ETF	624.3	624.41	623.24	623.29	77154.0
2025-12-04 06:00:00	QQQ	ETF	623.25	623.6	622.89	623.58	50090.0
2025-12-04 07:00:00	QQQ	ETF	623.57	624.02	623.5	623.66	53458.0
2025-12-04 08:00:00	QQQ	ETF	623.84	624.44	622.31	622.98	335075.0
2025-12-04 09:00:00	QQQ	ETF	623.0	625.43	620.79	621.21	7551861.0
2025-12-04 10:00:00	QQQ	ETF	621.16	623.19	620.32	621.5	7311585.0
2025-12-04 11:00:00	QQQ	ETF	621.5	623.435	619.96	623.23	5882298.0
2025-12-04 12:00:00	QQQ	ETF	623.23	623.47	621.91	622.67	3370658.0
2025-12-04 13:00:00	QQQ	ETF	622.66	623.02	621.63	622.34	2780762.0
2025-12-04 14:00:00	QQQ	ETF	622.33	622.5299	619.54	621.96	5720739.0
2025-12-04 15:00:00	QQQ	ETF	621.95	623.01	621.04	622.86	5763151.0
2025-12-04 16:00:00	QQQ	ETF	622.88	623.12	622.62	622.9999	1734724.0
2025-12-04 17:00:00	QQQ	ETF	623.0	623.0	622.67	622.8	25834.0
2025-12-04 18:00:00	QQQ	ETF	622.78	623.31	622.45	622.67	62806.0
2025-12-04 19:00:00	QQQ	ETF	622.7302	623.51	622.52	623.48	46653.0
2025-12-04 04:00:00	IWM	ETF	249.4	249.76	249.37	249.76	6601.0
2025-12-04 05:00:00	IWM	ETF	249.69	249.72	249.53	249.53	5725.0
2025-12-04 06:00:00	IWM	ETF	249.51	249.6	249.14	249.33	19683.0
2025-12-04 07:00:00	IWM	ETF	249.48	249.68	249.4	249.46	18892.0
2025-12-04 08:00:00	IWM	ETF	249.24	250.01	248.67	248.8	114415.0
2025-12-04 09:00:00	IWM	ETF	248.8	249.79	248.54	248.69	3407956.0
2025-12-04 10:00:00	IWM	ETF	248.7	251.19	248.665	251.11	5243853.0
2025-12-04 11:00:00	IWM	ETF	251.11	251.85	250.76	251.8	5141907.0
2025-12-04 12:00:00	IWM	ETF	251.8	252.345	251.38	252.3	3415544.0
2025-12-04 13:00:00	IWM	ETF	252.29	252.66	252.06	252.39	3184163.0
2025-12-04 14:00:00	IWM	ETF	252.39	252.5	251.05	252.0	4662401.0
2025-12-04 15:00:00	IWM	ETF	251.99	251.99	251.46	251.82	6155903.0
2025-12-04 16:00:00	IWM	ETF	251.82	251.89	251.58	251.58	964623.0
2025-12-04 17:00:00	IWM	ETF	251.57	251.58	251.25	251.42	85885.0
2025-12-04 18:00:00	IWM	ETF	251.42	251.6	251.4	251.55	40532.0
2025-12-04 19:00:00	IWM	ETF	251.5854	251.83	251.5384	251.76	17509.0
2025-12-04 04:00:00	DIA	ETF	479.6	480.15	479.6	480.15	1990.0
2025-12-04 05:00:00	DIA	ETF	480.11	480.16	479.69	479.77	1495.0

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

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