PREVIEW / etf_daily / 2025-06-30

all etf daily files

  file:    by_date/etf_daily/2025/2025-06-30.parquet
  size:    158 KB
  rows:    4,193

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-06-30	SPY	ETF	617.38	619.22	615.04	617.85	92483644.0
2025-06-30	QQQ	ETF	551.26	552.8	549.01	551.64	45548742.0
2025-06-30	IWM	ETF	216.68	216.71	215.39	215.79	25495015.0
2025-06-30	DIA	ETF	440.45	441.26	438.66	440.65	2825504.0
2025-06-30	GLD	ETF	302.385	304.92	301.95	304.83	8182835.0
2025-06-30	TLT	ETF	87.86	88.435	87.61	88.25	53692223.0
2025-06-30	AAA	ETF	24.84	24.99	24.84	24.9643	6404.0
2025-06-30	AAAU	ETF	32.41	32.69	32.3728	32.68	2005431.0
2025-06-30	AADR	ETF	79.03	79.3	78.355	78.98	6512.0
2025-06-30	AAPB	ETF	19.5	20.56	19.0109	20.12	740983.0
2025-06-30	AAPD	ETF	17.81	18.05	17.3446	17.54	1940758.0
2025-06-30	AAPR	ETF	27.23	27.265	27.21	27.265	2885.0
2025-06-30	AAPU	ETF	21.275	22.4089	20.715	21.94	10930740.0
2025-06-30	AAPW	ETF	35.23	36.24	34.6	35.94	15277.0
2025-06-30	AAPX	ETF	18.36	19.3399	17.9	18.96	535820.0
2025-06-30	AAPY	ETF	21.06	21.4526	20.92	21.4526	4569.0
2025-06-30	AAVM	ETF	27.14	27.18	27.12	27.18	828.0
2025-06-30	AAXJ	ETF	82.4	82.685	82.065	82.62	1203342.0
2025-06-30	ABCS	ETF	28.67	28.78	28.65	28.7584	3409.0
2025-06-30	ABEQ	ETF	34.07	34.2865	34.07	34.2865	16301.0
2025-06-30	ABFL	ETF	70.47	70.76	70.4	70.76	19044.0
2025-06-30	ABLD	ETF	28.35	28.5203	28.35	28.5203	5422.0
2025-06-30	ABLG	ETF	30.949	31.0564	30.92	31.0564	2752.0
2025-06-30	ABNY	ETF	57.5	58.25	57.35	57.4	2896.0
2025-06-30	ABOT	ETF	38.6513	38.6513	38.6513	38.6513	50.0
2025-06-30	ABXB	ETF	19.5373	19.565	19.5373	19.565	395.0
2025-06-30	ACES	ETF	25.71	25.95	25.5	25.8	12271.0
2025-06-30	ACGR	ETF	59.8554	59.8554	59.8554	59.8554	19.0
2025-06-30	ACIO	ETF	41.3	41.615	41.2715	41.4	209234.0
2025-06-30	ACLC	ETF	72.15	72.326	71.88	72.326	8594.0
2025-06-30	ACSI	ETF	63.0901	63.4339	63.0901	63.4339	926.0
2025-06-30	ACT	ETF	36.85	37.22	36.62	37.15	401335.0
2025-06-30	ACTV	ETF	31.57	31.6231	31.57	31.6231	573.0
2025-06-30	ACVF	ETF	47.0	47.1573	46.951	47.1573	4905.0
2025-06-30	ACWI	ETF	128.41	128.805	128.09	128.6	6019510.0
2025-06-30	ACWV	ETF	117.83	118.63	117.7419	118.57	100889.0
2025-06-30	ACWX	ETF	60.77	61.0	60.63	60.94	1056621.0
2025-06-30	ADBG	ETF	13.86	14.08	13.6803	13.86	24128.0
2025-06-30	ADFI	ETF	8.51	8.57	8.51	8.5274	9704.0
2025-06-30	ADIV	ETF	17.57	17.66	17.57	17.63	7336.0
2025-06-30	ADME	ETF	48.07	48.375	47.9625	48.2	20087.0
2025-06-30	ADPV	ETF	36.835	37.0	36.835	36.985	9617.0
2025-06-30	ADVE	ETF	35.8402	35.8402	35.8402	35.8402	404.0
2025-06-30	AESR	ETF	19.1	19.1	18.95	18.95	39037.0
2025-06-30	AETH	ETF	35.645	35.645	35.645	35.645	343.0
2025-06-30	AFIF	ETF	9.315	9.32	9.3	9.314	76419.0
2025-06-30	AFIX	ETF	24.93	24.9894	24.93	24.9894	166.0
2025-06-30	AFK	ETF	20.25	20.25	20.0	20.16	41627.0
2025-06-30	AFLG	ETF	36.29	36.34	36.11	36.31	71383.0
2025-06-30	AFMC	ETF	32.18	32.2	31.98	32.13	31135.0

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

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