PREVIEW / etf_daily / 2026-07-20

all etf daily files

  file:    by_date/etf_daily/2026/2026-07-20.parquet
  size:    158 KB
  rows:    4,170

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-07-20	SPY	ETF	747.06	748.73	741.5103	742.09	50422324.0
2026-07-20	QQQ	ETF	702.16	705.8	695.51	696.06	29687558.0
2026-07-20	IWM	ETF	295.01	295.99	292.18	292.31	20539883.0
2026-07-20	DIA	ETF	522.04	523.4	517.16	517.94	2336645.0
2026-07-20	GLD	ETF	367.79	368.7893	366.8	367.6	3922524.0
2026-07-20	TLT	ETF	84.31	84.34	83.815	83.89	24289038.0
2026-07-20	AAA	ETF	24.97	24.97	24.88	24.925	6705.0
2026-07-20	AAAU	ETF	39.51	39.62	39.415	39.51	1040873.0
2026-07-20	AADR	ETF	82.47	82.47	81.17	81.4203	1924.0
2026-07-20	AAOG	ETF	3.23	3.33	3.04	3.1	588745.0
2026-07-20	AAOX	ETF	14.5	15.0	13.6	13.86	3442158.0
2026-07-20	AAPB	ETF	44.76	44.79	42.135	42.8959	126571.0
2026-07-20	AAPD	ETF	10.52	10.8	10.49	10.705	16785813.0
2026-07-20	AAPR	ETF	29.5	29.54	29.48	29.495	3752.0
2026-07-20	AAPU	ETF	45.86	46.05	43.32	44.14	2081284.0
2026-07-20	AAPW	ETF	43.28	43.28	41.86	42.2991	15610.0
2026-07-20	AAPX	ETF	41.47	41.47	39.21	39.76	59825.0
2026-07-20	AAPY	ETF	28.16	28.16	27.59	27.7904	8084.0
2026-07-20	AAVM	ETF	33.16	33.16	33.0168	33.0168	2860.0
2026-07-20	AAXJ	ETF	110.79	111.4	110.16	110.25	590774.0
2026-07-20	ABCS	ETF	34.475	34.475	34.4031	34.4031	1211.0
2026-07-20	ABEQ	ETF	37.49	37.5223	37.4	37.4301	7673.0
2026-07-20	ABFL	ETF	82.82	83.0	82.2	82.2	13006.0
2026-07-20	ABLD	ETF	30.245	30.245	30.1228	30.1228	9541.0
2026-07-20	ABLG	ETF	30.66	30.66	30.5205	30.5205	1631.0
2026-07-20	ACES	ETF	32.5	32.64	31.82	31.82	13688.0
2026-07-20	ACGR	ETF	67.6	67.6001	67.2114	67.2114	270.0
2026-07-20	ACIO	ETF	45.99	46.14	45.8	45.82	101715.0
2026-07-20	ACLC	ETF	83.68	83.69	83.3821	83.3821	2116.0
2026-07-20	ACSI	ETF	76.06	76.06	75.6034	75.6034	804.0
2026-07-20	ACVF	ETF	53.42	53.58	53.1979	53.1979	4724.0
2026-07-20	ACWI	ETF	155.71	155.85	154.36	154.48	6395082.0
2026-07-20	ACWV	ETF	121.99	122.09	121.57	121.68	80059.0
2026-07-20	ACWX	ETF	74.35	74.43	73.65	73.74	3967597.0
2026-07-20	ACYN	ETF	20.65	20.6599	20.58	20.59	1576579.0
2026-07-20	ADBG	ETF	3.87	3.925	3.6201	3.86	7249132.0
2026-07-20	ADFI	ETF	8.42	8.42	8.4	8.405	7904.0
2026-07-20	ADIV	ETF	19.189	19.189	19.1004	19.1004	1649.0
2026-07-20	ADME	ETF	55.29	55.3099	54.99	55.06	9600.0
2026-07-20	ADPV	ETF	45.465	45.52	45.0874	45.0874	9010.0
2026-07-20	ADVE	ETF	45.1	45.1333	44.9851	44.9851	428.0
2026-07-20	AESR	ETF	19.65	19.85	19.62	19.62	17955.0
2026-07-20	AFIF	ETF	9.5	9.5	9.3826	9.4	1114284.0
2026-07-20	AFIX	ETF	24.66	24.66	24.61	24.615	13450.0
2026-07-20	AFK	ETF	25.27	25.4	25.075	25.21	51857.0
2026-07-20	AFLG	ETF	43.72	43.7796	43.435	43.47	87624.0
2026-07-20	AFMC	ETF	40.43	40.43	40.1	40.16	47877.0
2026-07-20	AFSC	ETF	37.8133	37.8133	37.8133	37.8133	72.0
2026-07-20	AFSM	ETF	39.925	39.9999	39.6519	39.6519	5428.0
2026-07-20	AGEM	ETF	46.605	46.69	46.299	46.299	3062.0

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

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