PREVIEW / etf_daily / 2025-08-21

all etf daily files

  file:    by_date/etf_daily/2025/2025-08-21.parquet
  size:    161 KB
  rows:    4,252

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-08-21	SPY	ETF	636.28	637.97	633.81	635.55	54783728.0
2025-08-21	QQQ	ETF	564.35	566.49	560.98	563.28	46436899.0
2025-08-21	IWM	ETF	224.41	226.32	223.78	225.97	24577191.0
2025-08-21	DIA	ETF	447.72	449.07	445.88	447.95	3777412.0
2025-08-21	GLD	ETF	307.86	308.15	307.0314	307.29	4806442.0
2025-08-21	TLT	ETF	86.56	86.675	86.105	86.41	28641786.0
2025-08-21	AAA	ETF	24.9818	25.14	24.9818	25.0152	23051.0
2025-08-21	AAAU	ETF	33.02	33.0465	32.935	32.955	760315.0
2025-08-21	AADR	ETF	81.6	82.08	81.6	82.08	362.0
2025-08-21	AAPB	ETF	24.04	24.08	23.55	23.79	221925.0
2025-08-21	AAPD	ETF	15.92	16.075	15.885	15.99	563522.0
2025-08-21	AAPR	ETF	27.56	27.56	27.56	27.56	18.0
2025-08-21	AAPU	ETF	26.12	26.22	25.6	25.85	1326305.0
2025-08-21	AAPW	ETF	37.0	37.08	36.69	36.8912	17819.0
2025-08-21	AAPX	ETF	22.54	22.6	22.06	22.29	95018.0
2025-08-21	AAPY	ETF	22.43	22.46	22.32	22.3665	2611.0
2025-08-21	AAVM	ETF	27.64	27.64	27.54	27.56	1585.0
2025-08-21	AAXJ	ETF	85.47	85.71	85.34	85.59	258642.0
2025-08-21	ABCS	ETF	29.61	29.7374	29.61	29.7111	2600.0
2025-08-21	ABEQ	ETF	35.06	35.13	34.99	35.09	22481.0
2025-08-21	ABFL	ETF	68.24	68.58	68.24	68.41	16945.0
2025-08-21	ABLD	ETF	28.53	28.6999	28.53	28.6621	4251.0
2025-08-21	ABLG	ETF	29.8277	29.8277	29.8277	29.8277	16.0
2025-08-21	ABNY	ETF	50.7	51.725	50.7	51.6	4194.0
2025-08-21	ABOT	ETF	37.9648	37.9648	37.9648	37.9648	3.0
2025-08-21	ABXB	ETF	19.597	19.597	19.597	19.597	8.0
2025-08-21	ACES	ETF	28.32	28.32	27.9401	28.14	3703.0
2025-08-21	ACGR	ETF	61.4746	61.4746	61.4746	61.4746	5.0
2025-08-21	ACIO	ETF	42.17	42.2014	41.99	42.065	111967.0
2025-08-21	ACLC	ETF	74.23	74.23	73.88	73.96	3357.0
2025-08-21	ACSI	ETF	65.0894	65.0894	65.0894	65.0894	123.0
2025-08-21	ACTV	ETF	32.53	32.5317	32.38	32.4561	4034.0
2025-08-21	ACVF	ETF	48.09	48.09	47.41	48.0025	3860.0
2025-08-21	ACWI	ETF	132.03	132.48	131.76	132.04	3149954.0
2025-08-21	ACWV	ETF	120.14	120.34	119.93	120.08	130096.0
2025-08-21	ACWX	ETF	62.7	62.765	62.54	62.68	789313.0
2025-08-21	ADBG	ETF	11.19	11.234	10.8	11.2052	79148.0
2025-08-21	ADFI	ETF	8.5	8.5	8.4201	8.48	19121.0
2025-08-21	ADIV	ETF	18.1261	18.16	18.11	18.1492	13261.0
2025-08-21	ADME	ETF	48.905	49.06	48.85	49.01	9209.0
2025-08-21	ADPV	ETF	39.085	39.4899	39.08	39.35	16173.0
2025-08-21	ADVE	ETF	36.7281	36.7281	36.7281	36.7281	52.0
2025-08-21	AESR	ETF	19.37	19.42	19.313	19.3817	30575.0
2025-08-21	AETH	ETF	52.43	52.63	51.71	51.7417	3107.0
2025-08-21	AFIF	ETF	9.355	9.38	9.355	9.37	392624.0
2025-08-21	AFIX	ETF	24.97	24.9752	24.95	24.9752	1630.0
2025-08-21	AFK	ETF	21.52	21.9045	21.3839	21.64	21509.0
2025-08-21	AFLG	ETF	37.23	37.3	37.07	37.18	47569.0
2025-08-21	AFMC	ETF	32.85	32.93	32.775	32.88	9764.0
2025-08-21	AFSC	ETF	29.185	29.211	29.185	29.211	220.0

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

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