PREVIEW / etf_daily / 2026-07-23

all etf daily files

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

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-23	SPY	ETF	739.37	742.56	735.21	738.18	55437332.0
2026-07-23	QQQ	ETF	694.67	698.66	687.79	691.96	44028575.0
2026-07-23	IWM	ETF	290.87	293.01	290.17	292.09	27795137.0
2026-07-23	DIA	ETF	515.07	518.17	514.72	516.26	4305149.0
2026-07-23	GLD	ETF	372.36	373.0852	370.53	371.52	9820641.0
2026-07-23	TLT	ETF	82.99	83.25	82.96	83.17	29152762.0
2026-07-23	AAAU	ETF	40.0	40.09	39.82	39.93	1413420.0
2026-07-23	AADR	ETF	83.08	83.08	82.7	82.8513	970.0
2026-07-23	AAOG	ETF	3.36	4.015	3.36	3.57	1190782.0
2026-07-23	AAOX	ETF	15.02	18.07	14.93	15.95	5239743.0
2026-07-23	AAPB	ETF	41.905	41.93	41.09	41.5	18693.0
2026-07-23	AAPD	ETF	10.84	10.95	10.8204	10.88	6982891.0
2026-07-23	AAPR	ETF	29.4	29.46	29.39	29.4128	4034.0
2026-07-23	AAPU	ETF	42.89	43.17	42.12	42.69	796774.0
2026-07-23	AAPW	ETF	41.5975	42.04	40.47	41.4856	12582.0
2026-07-23	AAPX	ETF	38.59	38.815	38.135	38.51	17865.0
2026-07-23	AAPY	ETF	27.14	27.14	26.855	27.0557	4633.0
2026-07-23	AAVM	ETF	33.47	33.47	33.2997	33.2997	466.0
2026-07-23	AAXJ	ETF	111.98	113.03	111.18	112.25	258995.0
2026-07-23	ABCS	ETF	34.2	34.2	34.148	34.148	1803.0
2026-07-23	ABEQ	ETF	37.72	37.79	37.62	37.6521	17807.0
2026-07-23	ABFL	ETF	82.69	83.5729	82.69	83.1601	5185.0
2026-07-23	ABLD	ETF	30.87	30.87	30.81	30.8219	1840.0
2026-07-23	ABOT	ETF	39.12	39.12	38.785	38.785	119.0
2026-07-23	ACES	ETF	31.76	31.93	31.36	31.62	33674.0
2026-07-23	ACIO	ETF	45.67	45.87	45.56	45.71	203490.0
2026-07-23	ACLC	ETF	83.365	83.365	83.1534	83.1534	2361.0
2026-07-23	ACSG	ETF	48.27	48.27	47.97	48.0925	526.0
2026-07-23	ACSI	ETF	74.99	74.99	74.6866	74.6866	174.0
2026-07-23	ACVF	ETF	53.1	53.3201	53.1	53.2484	16566.0
2026-07-23	ACWI	ETF	154.37	155.185	153.68	154.34	1243756.0
2026-07-23	ACWV	ETF	120.83	121.08	120.6501	120.94	38617.0
2026-07-23	ACWX	ETF	74.2	74.635	73.925	74.31	2360881.0
2026-07-23	ACYN	ETF	20.58	20.6	20.54	20.58	1518304.0
2026-07-23	ADBG	ETF	3.455	3.455	3.1	3.14	4047855.0
2026-07-23	ADFI	ETF	8.37	8.41	8.37	8.3849	203764.0
2026-07-23	ADIV	ETF	19.13	19.18	19.13	19.1567	4422.0
2026-07-23	ADME	ETF	55.06	55.06	54.7	54.89	10580.0
2026-07-23	ADPV	ETF	46.7884	46.79	46.27	46.2718	6180.0
2026-07-23	AESR	ETF	19.91	19.91	19.75	19.8	52694.0
2026-07-23	AETH	ETF	31.1	31.1	30.4958	30.4958	352.0
2026-07-23	AFIF	ETF	9.36	9.38	9.36	9.38	233702.0
2026-07-23	AFIX	ETF	24.45	24.47	24.43	24.4396	24618.0
2026-07-23	AFK	ETF	25.5	25.75	25.272	25.49	72230.0
2026-07-23	AFLG	ETF	43.4	43.54	43.193	43.32	54948.0
2026-07-23	AFMC	ETF	40.56	40.56	40.215	40.4	21452.0
2026-07-23	AFSC	ETF	37.6405	37.6678	37.57	37.6678	333.0
2026-07-23	AFSM	ETF	39.84	39.84	39.62	39.77	16768.0
2026-07-23	AGEM	ETF	47.445	47.445	46.82	47.2074	5958.0
2026-07-23	AGG	ETF	97.32	97.4	97.27	97.34	6394374.0

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

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