PREVIEW / etf_1hour / 2025-12-03

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-12-03.parquet
  size:    720 KB
  rows:    27,487

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-03 04:00:00	SPY	ETF	683.15	683.16	682.35	682.86	25651.0
2025-12-03 05:00:00	SPY	ETF	682.83	683.09	682.26	682.58	15127.0
2025-12-03 06:00:00	SPY	ETF	682.49	683.0	682.34	682.73	14061.0
2025-12-03 07:00:00	SPY	ETF	682.67	683.68	682.32	683.48	110426.0
2025-12-03 08:00:00	SPY	ETF	683.15	683.84	682.27	683.1864	286884.0
2025-12-03 09:00:00	SPY	ETF	683.18	683.3	679.2	680.87	7395983.0
2025-12-03 10:00:00	SPY	ETF	680.94	682.94	680.74	682.3163	7313673.0
2025-12-03 11:00:00	SPY	ETF	682.31	683.55	681.61	682.21	5078294.0
2025-12-03 12:00:00	SPY	ETF	682.21	684.1	682.1	683.89	4055179.0
2025-12-03 13:00:00	SPY	ETF	683.895	684.5	683.475	683.915	3282134.0
2025-12-03 14:00:00	SPY	ETF	683.91	684.74	683.85	684.625	3896061.0
2025-12-03 15:00:00	SPY	ETF	684.63	684.91	683.55	683.81	11682573.0
2025-12-03 16:00:00	SPY	ETF	683.815	684.1	683.75	684.06	2660057.0
2025-12-03 17:00:00	SPY	ETF	684.0	684.06	683.88	684.02	86232.0
2025-12-03 18:00:00	SPY	ETF	684.02	684.14	683.7	683.92	34936.0
2025-12-03 19:00:00	SPY	ETF	683.9	684.2497	683.42	683.57	38629.0
2025-12-03 04:00:00	QQQ	ETF	623.57	623.57	622.5	623.11	86155.0
2025-12-03 05:00:00	QQQ	ETF	623.09	623.37	622.32	622.76	36927.0
2025-12-03 06:00:00	QQQ	ETF	622.76	623.24	622.43	622.96	29886.0
2025-12-03 07:00:00	QQQ	ETF	622.93	623.72	622.54	623.51	103266.0
2025-12-03 08:00:00	QQQ	ETF	623.5	624.03	621.534	623.34	505948.0
2025-12-03 09:00:00	QQQ	ETF	623.33	623.42	617.8	619.67	7876326.0
2025-12-03 10:00:00	QQQ	ETF	619.74	622.28	619.38	621.265	8685738.0
2025-12-03 11:00:00	QQQ	ETF	621.26	622.655	620.26	621.2	5340825.0
2025-12-03 12:00:00	QQQ	ETF	621.21	623.04	621.08	622.77	3693724.0
2025-12-03 13:00:00	QQQ	ETF	622.76	623.47	622.35	622.87	3277837.0
2025-12-03 14:00:00	QQQ	ETF	622.85	623.91	622.785	623.85	2860357.0
2025-12-03 15:00:00	QQQ	ETF	623.85	624.22	623.11	623.53	6115453.0
2025-12-03 16:00:00	QQQ	ETF	623.53	623.6	623.0	623.22	1205649.0
2025-12-03 17:00:00	QQQ	ETF	623.25	623.28	623.04	623.12	46743.0
2025-12-03 18:00:00	QQQ	ETF	623.24	623.5	623.0	623.29	70435.0
2025-12-03 19:00:00	QQQ	ETF	623.3	623.68	622.75	622.93	74314.0
2025-12-03 04:00:00	IWM	ETF	246.15	246.28	245.84	246.02	17552.0
2025-12-03 05:00:00	IWM	ETF	246.02	246.11	245.65	245.8	9040.0
2025-12-03 06:00:00	IWM	ETF	245.78	246.22	245.75	246.11	10502.0
2025-12-03 07:00:00	IWM	ETF	246.08	246.57	245.99	246.41	24924.0
2025-12-03 08:00:00	IWM	ETF	245.87	246.5562	245.66	246.34	72368.0
2025-12-03 09:00:00	IWM	ETF	246.35	247.2	245.04	246.29	4394410.0
2025-12-03 10:00:00	IWM	ETF	246.34	247.945	246.26	247.63	4695061.0
2025-12-03 11:00:00	IWM	ETF	247.62	248.325	247.51	247.59	3017740.0
2025-12-03 12:00:00	IWM	ETF	247.59	249.105	247.58	249.0	3116655.0
2025-12-03 13:00:00	IWM	ETF	249.01	249.185	248.68	248.7655	2357246.0
2025-12-03 14:00:00	IWM	ETF	248.76	249.49	248.735	249.46	1981592.0
2025-12-03 15:00:00	IWM	ETF	249.45	249.835	249.24	249.63	4393550.0
2025-12-03 16:00:00	IWM	ETF	249.63	250.0	249.54	249.59	2238165.0
2025-12-03 17:00:00	IWM	ETF	249.66	249.7	249.51	249.7	14567.0
2025-12-03 18:00:00	IWM	ETF	249.63	249.74	249.54	249.63	32045.0
2025-12-03 19:00:00	IWM	ETF	249.72	249.84	249.44	249.54	21447.0
2025-12-03 04:00:00	DIA	ETF	476.44	476.44	476.08	476.31	1988.0
2025-12-03 05:00:00	DIA	ETF	476.36	476.38	475.91	475.91	914.0

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

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