PREVIEW / etf_daily / 2026-07-21

all etf daily files

  file:    by_date/etf_daily/2026/2026-07-21.parquet
  size:    157 KB
  rows:    4,168

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-21	SPY	ETF	746.29	749.04	744.18	748.28	34324262.0
2026-07-21	QQQ	ETF	706.57	710.05	702.8	708.97	33728341.0
2026-07-21	IWM	ETF	293.43	296.75	292.68	296.54	18190168.0
2026-07-21	DIA	ETF	519.63	523.01	518.12	521.51	3240689.0
2026-07-21	GLD	ETF	371.7	375.01	371.07	374.81	6070621.0
2026-07-21	TLT	ETF	83.735	83.77	83.43	83.66	14287531.0
2026-07-21	AAA	ETF	24.94	25.04	24.93	24.9947	8185.0
2026-07-21	AAAU	ETF	39.95	40.29	39.875	40.27	859483.0
2026-07-21	AADR	ETF	82.45	82.5	82.415	82.415	26746.0
2026-07-21	AAOG	ETF	3.41	4.1	3.355	4.07	1417865.0
2026-07-21	AAOX	ETF	15.08	18.4599	15.01	18.15	5958720.0
2026-07-21	AAPB	ETF	42.02	43.544	41.81	43.1645	73387.0
2026-07-21	AAPD	ETF	10.815	10.85	10.6114	10.67	9947052.0
2026-07-21	AAPR	ETF	29.48	29.515	29.48	29.515	3843.0
2026-07-21	AAPU	ETF	43.38	44.8799	42.92	44.38	1353178.0
2026-07-21	AAPW	ETF	41.9324	42.71	41.6322	42.4709	11776.0
2026-07-21	AAPX	ETF	38.99	40.445	38.85	40.21	39691.0
2026-07-21	AAPY	ETF	27.41	28.04	27.41	27.8919	4880.0
2026-07-21	AAVM	ETF	33.5447	33.5447	33.5447	33.5447	271.0
2026-07-21	AAXJ	ETF	113.31	113.91	112.61	113.62	306218.0
2026-07-21	ABCS	ETF	34.34	34.455	34.34	34.455	2825.0
2026-07-21	ABEQ	ETF	37.445	37.57	37.43	37.53	9103.0
2026-07-21	ABFL	ETF	83.18	83.42	82.9285	83.42	17684.0
2026-07-21	ABLD	ETF	30.36	30.56	30.36	30.5263	8745.0
2026-07-21	ACES	ETF	32.14	32.61	32.04	32.55	10269.0
2026-07-21	ACIO	ETF	45.97	46.22	45.9626	46.15	147805.0
2026-07-21	ACLC	ETF	83.97	84.233	83.97	84.233	1769.0
2026-07-21	ACSG	ETF	48.97	49.0681	48.97	49.0681	1307.0
2026-07-21	ACVF	ETF	53.65	53.6971	53.65	53.6971	1081.0
2026-07-21	ACWI	ETF	155.78	156.5	155.265	156.29	2328060.0
2026-07-21	ACWV	ETF	121.83	121.91	121.55	121.82	104514.0
2026-07-21	ACWX	ETF	74.78	75.175	74.4	75.08	1260876.0
2026-07-21	ACYN	ETF	20.65	20.69	20.63	20.67	1316217.0
2026-07-21	ADBG	ETF	3.46	3.75	3.45	3.62	5563478.0
2026-07-21	ADFI	ETF	8.395	8.4	8.38	8.395	5226.0
2026-07-21	ADIV	ETF	19.23	19.31	19.21	19.305	6927.0
2026-07-21	ADME	ETF	55.32	55.5	55.29	55.5	12480.0
2026-07-21	ADPV	ETF	45.6	46.4962	45.6	46.4962	7820.0
2026-07-21	ADVE	ETF	45.64	45.8717	45.64	45.8717	408.0
2026-07-21	AESR	ETF	19.88	20.05	19.88	20.04	25613.0
2026-07-21	AETH	ETF	31.48	31.525	31.29	31.3219	3877.0
2026-07-21	AFIF	ETF	9.395	9.41	9.3815	9.405	143350.0
2026-07-21	AFIX	ETF	24.57	24.57	24.57	24.57	4026.0
2026-07-21	AFK	ETF	25.24	25.7	25.24	25.5547	42095.0
2026-07-21	AFLG	ETF	43.79	43.84	43.61	43.84	77025.0
2026-07-21	AFMC	ETF	40.42	40.66	40.2	40.61	100632.0
2026-07-21	AFSC	ETF	38.2713	38.2713	38.2713	38.2713	94.0
2026-07-21	AFSM	ETF	39.83	40.38	39.83	40.3583	132486.0
2026-07-21	AGEM	ETF	47.39	47.88	47.36	47.7341	5221.0
2026-07-21	AGG	ETF	97.85	97.8959	97.715	97.74	9518207.0

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

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