PREVIEW / etf_daily / 2026-01-20

all etf daily files

  file:    by_date/etf_daily/2026/2026-01-20.parquet
  size:    167 KB
  rows:    4,406

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2026-01-20	SPY	ETF	681.49	684.77	676.57	677.58	112066903.0
2026-01-20	QQQ	ETF	610.53	615.055	607.05	608.06	81988898.0
2026-01-20	IWM	ETF	261.14	265.0799	261.06	262.58	47894895.0
2026-01-20	DIA	ETF	486.17	489.06	484.245	484.88	7412844.0
2026-01-20	GLD	ETF	436.69	438.1399	434.1	437.23	21275046.0
2026-01-20	TLT	ETF	86.63	87.03	86.5407	86.65	66013068.0
2026-01-20	AAA	ETF	24.96	25.0099	24.94	25.0064	15175.0
2026-01-20	AAAU	ETF	46.87	47.0354	46.6	46.93	2678298.0
2026-01-20	AADR	ETF	91.0	92.4	91.0	92.05	2769.0
2026-01-20	AAPB	ETF	27.5	27.9185	25.5	26.31	207435.0
2026-01-20	AAPD	ETF	14.15	14.6305	14.021	14.45	4091754.0
2026-01-20	AAPR	ETF	28.48	28.48	28.4	28.4288	3913.0
2026-01-20	AAPU	ETF	28.84	29.335	26.73	27.48	3480955.0
2026-01-20	AAPW	ETF	36.12	36.82	34.89	35.43	28137.0
2026-01-20	AAPX	ETF	26.05	26.53	24.21	24.92	232713.0
2026-01-20	AAPY	ETF	22.95	23.04	22.4034	22.4034	5532.0
2026-01-20	AAVM	ETF	31.245	31.2468	31.12	31.12	4342.0
2026-01-20	AAXJ	ETF	97.77	98.3	97.45	97.55	1219250.0
2026-01-20	ABCS	ETF	31.03	31.03	30.7973	30.7973	3700.0
2026-01-20	ABEQ	ETF	36.8	36.9074	36.7	36.82	18555.0
2026-01-20	ABFL	ETF	71.82	72.26	71.495	71.58	30998.0
2026-01-20	ABLD	ETF	30.92	30.9293	30.72	30.7628	1741.0
2026-01-20	ABLG	ETF	31.8133	32.34	31.8133	31.8133	381.0
2026-01-20	ABNY	ETF	43.49	44.84	43.49	44.84	4683.0
2026-01-20	ABOT	ETF	36.3479	36.3479	36.3479	36.3479	92.0
2026-01-20	ABXB	ETF	19.6	19.6	19.582	19.582	116.0
2026-01-20	ACES	ETF	34.61	35.08	34.34	34.83	29087.0
2026-01-20	ACGR	ETF	64.13	64.13	63.6512	63.6512	245.0
2026-01-20	ACIO	ETF	43.58	43.71	43.34	43.42	91057.0
2026-01-20	ACLC	ETF	78.13	78.49	77.57	77.64	5551.0
2026-01-20	ACSI	ETF	66.4426	66.4426	66.4426	66.4426	31.0
2026-01-20	ACVF	ETF	49.69	49.875	49.34	49.3845	6950.0
2026-01-20	ACWI	ETF	142.84	143.66	142.21	142.36	4308438.0
2026-01-20	ACWV	ETF	119.12	119.58	118.87	119.03	102522.0
2026-01-20	ACWX	ETF	69.14	69.5	68.91	69.03	3151402.0
2026-01-20	ADBG	ETF	7.14	7.14	6.8328	6.94	993046.0
2026-01-20	ADFI	ETF	8.53	8.57	8.53	8.56	74908.0
2026-01-20	ADIV	ETF	18.45	18.46	18.41	18.42	3269.0
2026-01-20	ADME	ETF	51.48	51.5277	51.11	51.19	7485.0
2026-01-20	ADPV	ETF	44.84	45.5	44.46	45.05	73657.0
2026-01-20	ADVE	ETF	41.145	41.275	40.825	40.92	2156.0
2026-01-20	AESR	ETF	17.29	17.5099	17.29	17.35	99358.0
2026-01-20	AETH	ETF	35.0026	35.0026	34.48	34.6542	30743.0
2026-01-20	AFIF	ETF	9.42	9.45	9.42	9.438	59848.0
2026-01-20	AFIX	ETF	25.09	25.1	25.045	25.045	4119.0
2026-01-20	AFK	ETF	27.71	28.0099	27.5	28.0	106681.0
2026-01-20	AFLG	ETF	39.58	39.71	39.3157	39.337	59671.0
2026-01-20	AFMC	ETF	36.15	36.24	35.89	35.9238	13589.0
2026-01-20	AFSC	ETF	31.96	31.96	31.8392	31.8392	1120.0
2026-01-20	AFSM	ETF	33.98	34.459	33.98	34.252	4264.0

> showing 50 of 4,406 rows — these rows as CSV

> register free to download (covers the last year of daily data)