PREVIEW / etf_daily / 2025-06-23

all etf daily files

  file:    by_date/etf_daily/2025/2025-06-23.parquet
  size:    157 KB
  rows:    4,175

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-23	SPY	ETF	595.04	600.54	591.89	600.15	87358791.0
2025-06-23	QQQ	ETF	526.81	532.17	523.65	531.65	50666146.0
2025-06-23	IWM	ETF	208.48	211.78	206.81	211.77	35464239.0
2025-06-23	DIA	ETF	422.0	425.96	419.62	425.72	4305001.0
2025-06-23	GLD	ETF	310.34	312.67	310.31	311.08	12655916.0
2025-06-23	TLT	ETF	86.93	87.4407	86.77	86.77	36833630.0
2025-06-23	AAA	ETF	24.96	25.04	24.96	25.015	6699.0
2025-06-23	AAAU	ETF	33.28	33.53	33.27	33.355	2889127.0
2025-06-23	AADR	ETF	76.0039	76.33	75.51	75.89	1807.0
2025-06-23	AAPB	ETF	19.48	19.61	19.0	19.47	189325.0
2025-06-23	AAPD	ETF	17.96	18.17	17.88	17.95	1258462.0
2025-06-23	AAPR	ETF	26.98	27.0073	26.94	27.0073	1611.0
2025-06-23	AAPU	ETF	21.29	21.4684	20.7633	21.3	3590989.0
2025-06-23	AAPW	ETF	35.43	35.45	34.9604	35.4	16990.0
2025-06-23	AAPX	ETF	18.33	18.46	17.95	18.36	229402.0
2025-06-23	AAPY	ETF	21.01	21.38	20.92	21.04	12223.0
2025-06-23	AAVM	ETF	26.13	26.44	26.13	26.44	6350.0
2025-06-23	AAXJ	ETF	79.46	80.22	79.31	80.21	526026.0
2025-06-23	ABCS	ETF	28.0931	28.35	28.06	28.3398	5308.0
2025-06-23	ABEQ	ETF	34.39	34.43	34.27	34.43	8518.0
2025-06-23	ABFL	ETF	68.28	69.18	68.28	69.18	11430.0
2025-06-23	ABLD	ETF	28.56	28.5923	28.36	28.5923	11623.0
2025-06-23	ABLG	ETF	30.0	30.5788	29.85	30.5206	10430.0
2025-06-23	ABNY	ETF	59.3	59.3	57.05	58.7	10995.0
2025-06-23	ABOT	ETF	37.29	37.5453	37.29	37.5453	823.0
2025-06-23	ABXB	ETF	19.65	19.6608	19.65	19.6608	207.0
2025-06-23	ACES	ETF	24.86	25.29	24.811	24.97	76308.0
2025-06-23	ACGR	ETF	57.4988	57.4988	57.4988	57.4988	6.0
2025-06-23	ACIO	ETF	40.46	40.975	40.31	40.68	155685.0
2025-06-23	ACLC	ETF	69.862	70.27	69.82	70.27	5775.0
2025-06-23	ACSI	ETF	62.2135	62.2135	62.2135	62.2135	89.0
2025-06-23	ACT	ETF	36.24	37.35	36.24	37.33	546344.0
2025-06-23	ACTV	ETF	30.85	31.0797	30.85	31.0797	1454.0
2025-06-23	ACVF	ETF	45.46	45.9491	45.46	45.9491	2765.0
2025-06-23	ACVT	ETF	25.82	25.82	25.82	25.82	142.0
2025-06-23	ACWI	ETF	123.51	124.91	123.2	124.85	6716119.0
2025-06-23	ACWV	ETF	115.94	116.925	115.93	116.92	145667.0
2025-06-23	ACWX	ETF	58.62	59.28	58.47	59.28	933703.0
2025-06-23	ADBG	ETF	13.08	13.39	13.018	13.32	57583.0
2025-06-23	ADFI	ETF	8.45	8.461	8.4402	8.461	6490.0
2025-06-23	ADIV	ETF	17.245	17.2527	17.21	17.2527	1528.0
2025-06-23	ADME	ETF	46.8162	47.051	46.66	47.051	16382.0
2025-06-23	ADPV	ETF	35.5	35.6888	35.05	35.6888	5526.0
2025-06-23	ADVE	ETF	34.66	34.9815	34.66	34.9815	1276.0
2025-06-23	AESR	ETF	18.25	18.463	18.17	18.463	15213.0
2025-06-23	AETH	ETF	35.68	35.7299	35.5201	35.625	757.0
2025-06-23	AFIF	ETF	9.27	9.28	9.26	9.27	14639.0
2025-06-23	AFIX	ETF	24.8618	24.8618	24.8618	24.8618	370.0
2025-06-23	AFK	ETF	19.16	19.67	19.0	19.51	13501.0
2025-06-23	AFLG	ETF	35.27	35.53	35.08	35.53	31370.0

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

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