PREVIEW / etf_1hour / 2025-12-19

all etf 1-hour files

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

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-19 04:00:00	SPY	ETF	676.49	677.27	676.39	677.1	35354.0
2025-12-19 05:00:00	SPY	ETF	677.12	677.18	676.45	676.6	20910.0
2025-12-19 06:00:00	SPY	ETF	676.47	676.64	675.69	676.12	31324.0
2025-12-19 07:00:00	SPY	ETF	676.13	676.5	674.83	674.96	155494.0
2025-12-19 08:00:00	SPY	ETF	676.83	677.2347	674.16	675.51	275200.0
2025-12-19 09:00:00	SPY	ETF	675.54	679.91	675.07	679.82	11014248.0
2025-12-19 10:00:00	SPY	ETF	679.81	680.52	678.45	678.98	13009974.0
2025-12-19 11:00:00	SPY	ETF	678.97	680.53	678.56	679.695	7946256.0
2025-12-19 12:00:00	SPY	ETF	679.7	681.058	679.63	680.655	6306607.0
2025-12-19 13:00:00	SPY	ETF	680.655	681.09	680.17	680.225	4322825.0
2025-12-19 14:00:00	SPY	ETF	680.22	681.0	680.22	680.59	5750269.0
2025-12-19 15:00:00	SPY	ETF	680.59	680.83	679.61	680.59	20260965.0
2025-12-19 16:00:00	SPY	ETF	680.59	681.19	680.37	681.03	5161963.0
2025-12-19 17:00:00	SPY	ETF	681.02	681.14	680.96	681.1399	155180.0
2025-12-19 18:00:00	SPY	ETF	681.14	681.4	681.0999	681.29	102286.0
2025-12-19 19:00:00	SPY	ETF	681.27	681.5	681.2312	681.4505	25069.0
2025-12-19 04:00:00	QQQ	ETF	612.23	612.8	611.04	612.56	91652.0
2025-12-19 05:00:00	QQQ	ETF	612.53	612.57	611.91	612.05	57028.0
2025-12-19 06:00:00	QQQ	ETF	612.01	612.12	611.0	611.52	83957.0
2025-12-19 07:00:00	QQQ	ETF	611.58	611.93	610.06	610.07	131859.0
2025-12-19 08:00:00	QQQ	ETF	611.68	612.76	609.85	611.0799	428618.0
2025-12-19 09:00:00	QQQ	ETF	611.1	616.96	610.51	616.6501	9277892.0
2025-12-19 10:00:00	QQQ	ETF	616.65	617.62	614.38	614.815	6558704.0
2025-12-19 11:00:00	QQQ	ETF	614.8	616.74	614.24	615.34	4063788.0
2025-12-19 12:00:00	QQQ	ETF	615.36	617.5	615.28	617.04	3924179.0
2025-12-19 13:00:00	QQQ	ETF	617.035	617.38	616.28	616.48	2385354.0
2025-12-19 14:00:00	QQQ	ETF	616.47	617.39	616.46	616.9	2087362.0
2025-12-19 15:00:00	QQQ	ETF	616.89	617.48	615.96	617.24	7258590.0
2025-12-19 16:00:00	QQQ	ETF	617.24	618.0	616.9	617.6	2848717.0
2025-12-19 17:00:00	QQQ	ETF	617.68	618.5	617.6	618.1	101061.0
2025-12-19 18:00:00	QQQ	ETF	618.1	618.49	618.05	618.42	30557.0
2025-12-19 19:00:00	QQQ	ETF	618.48	618.8	618.44	618.79	36702.0
2025-12-19 04:00:00	IWM	ETF	249.56	249.85	248.65	249.8	22348.0
2025-12-19 05:00:00	IWM	ETF	249.68	249.81	249.47	249.53	5968.0
2025-12-19 06:00:00	IWM	ETF	249.52	249.58	249.23	249.4	13778.0
2025-12-19 07:00:00	IWM	ETF	249.44	249.58	248.92	248.92	57430.0
2025-12-19 08:00:00	IWM	ETF	249.6	249.8	248.27	249.27	163642.0
2025-12-19 09:00:00	IWM	ETF	249.17	250.89	248.91	250.77	2815850.0
2025-12-19 10:00:00	IWM	ETF	250.74	251.0	250.02	250.26	2647513.0
2025-12-19 11:00:00	IWM	ETF	250.26	251.375	250.06	251.1401	2424844.0
2025-12-19 12:00:00	IWM	ETF	251.15	251.3999	250.79	250.79	1527046.0
2025-12-19 13:00:00	IWM	ETF	250.79	251.39	250.525	250.715	1212413.0
2025-12-19 14:00:00	IWM	ETF	250.71	250.91	250.4	250.425	1770570.0
2025-12-19 15:00:00	IWM	ETF	250.43	250.975	250.13	250.77	6644305.0
2025-12-19 16:00:00	IWM	ETF	250.79	251.09	250.6	251.08	2427060.0
2025-12-19 17:00:00	IWM	ETF	251.1	251.16	250.93	251.1	44654.0
2025-12-19 18:00:00	IWM	ETF	251.18	251.39	251.06	251.3104	4703.0
2025-12-19 19:00:00	IWM	ETF	251.31	251.38	251.2	251.27	4402.0
2025-12-19 04:00:00	DIA	ETF	479.87	480.22	479.86	480.22	3334.0
2025-12-19 05:00:00	DIA	ETF	480.25	480.33	480.07	480.07	945.0

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

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