PREVIEW / etf_daily / 2026-07-31

all etf daily files

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

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-31	SPY	ETF	744.68	748.895	737.68	747.03	62445899.0
2026-07-31	QQQ	ETF	692.11	695.77	680.0512	687.99	50540483.0
2026-07-31	IWM	ETF	293.56	293.95	287.83	291.2	28350651.0
2026-07-31	DIA	ETF	524.08	525.61	519.25	524.32	3981072.0
2026-07-31	GLD	ETF	370.84	372.01	368.815	371.54	6825924.0
2026-07-31	TLT	ETF	82.45	82.45	81.89	82.25	50359783.0
2026-07-31	AAA	ETF	25.0	25.0	24.88	24.915	2018.0
2026-07-31	AAAU	ETF	39.86	39.9899	39.64	39.93	959985.0
2026-07-31	AADR	ETF	83.14	83.16	82.71	82.9496	7946.0
2026-07-31	AAOG	ETF	2.6	2.7391	2.17	2.31	2628162.0
2026-07-31	AAOX	ETF	11.7	12.29	9.73	10.4	10531444.0
2026-07-31	AAPB	ETF	36.86	38.3	35.62	37.84	377625.0
2026-07-31	AAPD	ETF	11.39	11.5387	11.21	11.26	25386256.0
2026-07-31	AAPR	ETF	29.53	29.58	29.4601	29.5786	3778.0
2026-07-31	AAPU	ETF	37.88	39.49	36.6	39.02	5865000.0
2026-07-31	AAPW	ETF	37.66	39.1813	37.66	39.1813	52643.0
2026-07-31	AAPX	ETF	34.41	35.787	33.051	35.43	174481.0
2026-07-31	AAPY	ETF	25.4	25.7905	24.9259	25.7905	15040.0
2026-07-31	AAVM	ETF	33.32	33.64	33.32	33.5484	7876.0
2026-07-31	AAXJ	ETF	112.81	112.81	109.96	110.72	753242.0
2026-07-31	ABCS	ETF	35.23	35.33	35.23	35.3013	2412.0
2026-07-31	ABEQ	ETF	37.99	38.25	37.9837	38.2185	15588.0
2026-07-31	ABFL	ETF	81.84	81.84	80.99	81.31	16875.0
2026-07-31	ABLD	ETF	30.9	31.12	30.8999	30.9947	19574.0
2026-07-31	ABLG	ETF	30.671	30.671	30.475	30.475	546.0
2026-07-31	ACES	ETF	31.3	31.3	30.26	30.49	60733.0
2026-07-31	ACGR	ETF	67.49	67.7206	67.46	67.7206	553.0
2026-07-31	ACIO	ETF	45.95	46.04	45.51	45.93	118067.0
2026-07-31	ACLC	ETF	84.14	84.61	83.58	84.31	7520.0
2026-07-31	ACSG	ETF	47.88	47.88	47.6891	47.6891	250.0
2026-07-31	ACVF	ETF	54.2	54.2	53.93	54.0005	5294.0
2026-07-31	ACWI	ETF	156.25	156.59	154.49	156.43	3181448.0
2026-07-31	ACWV	ETF	124.02	124.57	123.5001	124.48	97730.0
2026-07-31	ACWX	ETF	75.67	75.7	74.6	75.25	1879229.0
2026-07-31	ACYN	ETF	20.71	20.73	20.6	20.69	1498219.0
2026-07-31	ADBG	ETF	4.08	4.3	3.985	4.28	5683921.0
2026-07-31	ADIV	ETF	19.53	19.638	19.222	19.5548	7191.0
2026-07-31	ADME	ETF	54.91	55.37	54.73	55.17	9629.0
2026-07-31	ADPV	ETF	45.07	45.07	44.7	44.73	11902.0
2026-07-31	ADVE	ETF	45.635	45.6998	45.635	45.6998	677.0
2026-07-31	AESR	ETF	19.83	19.83	19.3	19.48	37240.0
2026-07-31	AETH	ETF	30.43	30.43	30.385	30.385	409.0
2026-07-31	AFIF	ETF	9.45	9.45	9.361	9.38	215145.0
2026-07-31	AFIX	ETF	24.33	24.345	24.3101	24.3304	24644.0
2026-07-31	AFK	ETF	25.77	26.3	25.77	26.13	177580.0
2026-07-31	AFLG	ETF	43.95	44.095	43.535	43.99	67000.0
2026-07-31	AFMC	ETF	40.94	40.94	40.2413	40.58	36958.0
2026-07-31	AFSC	ETF	38.11	38.11	38.11	38.11	134.0
2026-07-31	AFSM	ETF	40.25	40.29	39.61	39.94	47385.0
2026-07-31	AGEM	ETF	47.96	48.2	47.46	47.5269	165276.0

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

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