PREVIEW / etf_daily / 2025-07-31

all etf daily files

  file:    by_date/etf_daily/2025/2025-07-31.parquet
  size:    162 KB
  rows:    4,237

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
2025-07-31	SPY	ETF	639.455	639.85	630.765	632.08	103439384.0
2025-07-31	QQQ	ETF	574.54	574.63	563.87	565.01	64613590.0
2025-07-31	IWM	ETF	220.455	222.02	218.88	219.39	42847736.0
2025-07-31	DIA	ETF	445.27	446.2	440.5	441.33	4218600.0
2025-07-31	GLD	ETF	304.59	304.61	302.86	302.96	8977418.0
2025-07-31	TLT	ETF	87.13	87.41	86.84	86.92	49811792.0
2025-07-31	AAA	ETF	25.0	25.01	24.9986	25.005	3582.0
2025-07-31	AAAU	ETF	32.66	32.66	32.4747	32.49	3165214.0
2025-07-31	AADR	ETF	78.44	78.58	78.1816	78.4158	23431.0
2025-07-31	AAPB	ETF	20.61	20.9	20.3815	20.68	1308758.0
2025-07-31	AAPD	ETF	17.34	17.43	17.21	17.41	1811831.0
2025-07-31	AAPR	ETF	27.5	27.5	27.44	27.4478	1803.0
2025-07-31	AAPU	ETF	22.47	22.7299	22.16	22.29	8141391.0
2025-07-31	AAPW	ETF	34.74	34.93	34.39	34.56	62329.0
2025-07-31	AAPX	ETF	19.41	19.61	19.135	19.28	448515.0
2025-07-31	AAPY	ETF	21.645	21.666	21.536	21.536	2639.0
2025-07-31	AAVM	ETF	26.8272	26.87	26.695	26.695	2503.0
2025-07-31	AAXJ	ETF	84.2	84.2	83.57	83.71	2429784.0
2025-07-31	ABCS	ETF	29.05	29.16	28.8242	28.8242	4041.0
2025-07-31	ABEQ	ETF	34.345	34.345	34.1522	34.1522	1686.0
2025-07-31	ABFL	ETF	70.4	70.4	69.616	69.616	14225.0
2025-07-31	ABLD	ETF	28.7301	28.7301	28.6894	28.6894	3435.0
2025-07-31	ABLG	ETF	29.64	29.64	29.4238	29.4238	4566.0
2025-07-31	ABNY	ETF	56.8	56.8	55.5	55.5	2032.0
2025-07-31	ABOT	ETF	38.9914	39.0568	38.5354	38.5354	807.0
2025-07-31	ABXB	ETF	19.48	19.48	19.48	19.48	26.0
2025-07-31	ACES	ETF	27.57	27.6455	27.12	27.19	8938.0
2025-07-31	ACGR	ETF	61.6237	61.6237	61.6237	61.6237	84.0
2025-07-31	ACIO	ETF	42.22	42.22	41.6875	41.735	137613.0
2025-07-31	ACLC	ETF	74.19	74.2755	73.53	73.5493	5492.0
2025-07-31	ACSI	ETF	64.0548	64.0548	64.0548	64.0548	254.0
2025-07-31	ACTV	ETF	32.425	32.59	32.06	32.1404	34188.0
2025-07-31	ACVF	ETF	48.27	48.27	47.6669	47.6669	3147.0
2025-07-31	ACVT	ETF	26.395	26.395	26.3449	26.3449	800.0
2025-07-31	ACWI	ETF	131.09	131.21	129.74	129.96	5988791.0
2025-07-31	ACWV	ETF	116.86	117.1699	116.13	116.29	394119.0
2025-07-31	ACWX	ETF	60.57	60.6165	60.16	60.26	1075466.0
2025-07-31	ADBG	ETF	11.97	11.97	11.45	11.6275	88241.0
2025-07-31	ADFI	ETF	8.505	8.53	8.49	8.5009	9325.0
2025-07-31	ADIV	ETF	17.83	17.83	17.71	17.71	7750.0
2025-07-31	ADME	ETF	49.38	49.38	48.75	48.87	7359.0
2025-07-31	ADPV	ETF	40.16	40.6699	40.02	40.08	16009.0
2025-07-31	ADVE	ETF	35.8902	35.8902	35.8902	35.8902	24.0
2025-07-31	AESR	ETF	19.52	19.5271	19.34	19.34	6309.0
2025-07-31	AETH	ETF	51.84	52.29	50.88	50.895	5855.0
2025-07-31	AFIF	ETF	9.3333	9.34	9.32	9.335	6423.0
2025-07-31	AFIX	ETF	24.87	24.87	24.84	24.855	4183.0
2025-07-31	AFK	ETF	21.2	21.245	20.89	20.94	13404.0
2025-07-31	AFLG	ETF	37.17	37.17	36.7054	36.79	29405.0
2025-07-31	AFMC	ETF	32.23	32.47	32.11	32.1119	20024.0

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

> unlock the full archive -- $79 one-time