PREVIEW / etf_daily / 2025-08-04

all etf daily files

  file:    by_date/etf_daily/2025/2025-08-04.parquet
  size:    161 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-08-04	SPY	ETF	625.67	631.215	625.58	631.17	73199052.0
2025-08-04	QQQ	ETF	559.05	564.315	558.95	564.1	47669751.0
2025-08-04	IWM	ETF	216.55	219.74	216.08	219.73	34969181.0
2025-08-04	DIA	ETF	437.88	441.9	437.59	441.81	5064242.0
2025-08-04	GLD	ETF	310.8	311.74	310.37	310.91	7637656.0
2025-08-04	TLT	ETF	87.955	88.15	87.65	88.06	36419664.0
2025-08-04	AAA	ETF	24.9895	25.02	24.9344	24.95	7336.0
2025-08-04	AAAU	ETF	33.34	33.4262	33.28	33.335	1849952.0
2025-08-04	AADR	ETF	78.77	79.11	78.77	78.9294	1268.0
2025-08-04	AAPB	ETF	19.75	20.45	19.28	19.61	751173.0
2025-08-04	AAPD	ETF	17.68	17.9099	17.37	17.76	1397916.0
2025-08-04	AAPR	ETF	27.47	27.47	27.4405	27.467	30404.0
2025-08-04	AAPU	ETF	21.56	22.24	20.96	21.3	6612542.0
2025-08-04	AAPW	ETF	33.6	34.23	33.04	33.3393	64639.0
2025-08-04	AAPX	ETF	18.54	19.175	18.09	18.37	352287.0
2025-08-04	AAPY	ETF	21.28	21.6	21.2766	21.2766	2653.0
2025-08-04	AAVM	ETF	27.02	27.02	27.02	27.02	154.0
2025-08-04	AAXJ	ETF	83.94	84.01	83.59	83.8	255657.0
2025-08-04	ABCS	ETF	28.6454	28.79	28.64	28.7742	2439.0
2025-08-04	ABEQ	ETF	34.09	34.4	34.09	34.4	5661.0
2025-08-04	ABFL	ETF	68.61	69.3394	68.61	69.3394	17301.0
2025-08-04	ABLD	ETF	28.71	28.8	28.71	28.7947	4182.0
2025-08-04	ABLG	ETF	29.06	29.5094	29.06	29.5094	1637.0
2025-08-04	ABNY	ETF	54.4	55.35	54.2	55.35	4436.0
2025-08-04	ABOT	ETF	38.34	38.5004	38.34	38.5004	229.0
2025-08-04	ABXB	ETF	19.585	19.585	19.585	19.585	206.0
2025-08-04	ACES	ETF	26.82	26.99	26.75	26.9	60607.0
2025-08-04	ACGR	ETF	61.605	61.605	61.605	61.605	132.0
2025-08-04	ACIO	ETF	41.34	41.75	41.34	41.65	79870.0
2025-08-04	ACLC	ETF	73.141	73.4254	73.141	73.4254	2733.0
2025-08-04	ACSI	ETF	63.51	63.7348	63.51	63.7348	306.0
2025-08-04	ACTV	ETF	32.17	32.25	32.12	32.1905	1418.0
2025-08-04	ACVF	ETF	47.46	47.8697	47.46	47.8697	11333.0
2025-08-04	ACWI	ETF	129.21	130.19	129.21	130.17	5920965.0
2025-08-04	ACWV	ETF	117.22	117.92	117.22	117.9	66911.0
2025-08-04	ACWX	ETF	60.61	60.79	60.59	60.77	633818.0
2025-08-04	ADBG	ETF	11.095	11.1	10.38	10.4311	202081.0
2025-08-04	ADFI	ETF	8.53	8.61	8.53	8.565	17582.0
2025-08-04	ADIV	ETF	17.89	18.01	17.7701	17.865	223762.0
2025-08-04	ADME	ETF	48.635	48.79	48.635	48.79	11701.0
2025-08-04	ADPV	ETF	39.65	40.3669	39.65	40.3	6549.0
2025-08-04	ADVE	ETF	36.06	36.1	36.0	36.0793	963.0
2025-08-04	AESR	ETF	19.07	19.295	19.07	19.28	13985.0
2025-08-04	AETH	ETF	48.86	50.3399	48.86	50.067	2165.0
2025-08-04	AFIF	ETF	9.3537	9.37	9.3537	9.365	12688.0
2025-08-04	AFIX	ETF	25.095	25.095	25.095	25.095	68.0
2025-08-04	AFK	ETF	21.05	21.4799	21.0	21.24	39794.0
2025-08-04	AFLG	ETF	36.61	36.893	36.61	36.893	53754.0
2025-08-04	AFMC	ETF	32.045	32.32	32.045	32.32	16182.0
2025-08-04	AFSC	ETF	28.35	28.715	28.35	28.715	466.0

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

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