PREVIEW / etf_daily / 2025-07-22

all etf daily files

  file:    by_date/etf_daily/2025/2025-07-22.parquet
  size:    160 KB
  rows:    4,198

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-22	SPY	ETF	629.1	629.73	626.19	628.86	60002220.0
2025-07-22	QQQ	ETF	564.3	564.35	558.61	561.25	43270647.0
2025-07-22	IWM	ETF	221.62	223.81	220.66	223.27	30814469.0
2025-07-22	DIA	ETF	442.86	445.45	442.84	444.96	3087169.0
2025-07-22	GLD	ETF	314.48	316.24	313.62	316.1	13682237.0
2025-07-22	TLT	ETF	86.17	86.77	86.11	86.52	35172670.0
2025-07-22	AAA	ETF	25.06	25.07	24.9801	25.0	4428.0
2025-07-22	AAAU	ETF	33.72	33.9099	33.63	33.895	3127079.0
2025-07-22	AADR	ETF	78.73	79.19	78.73	79.19	878.0
2025-07-22	AAPB	ETF	21.59	21.89	21.45	21.85	404619.0
2025-07-22	AAPD	ETF	16.93	16.995	16.805	16.83	2187371.0
2025-07-22	AAPR	ETF	27.3995	27.4	27.37	27.385	5743.0
2025-07-22	AAPU	ETF	23.54	23.847	23.31	23.79	3587862.0
2025-07-22	AAPW	ETF	36.05	36.31	35.84	36.31	48578.0
2025-07-22	AAPX	ETF	20.29	20.58	20.19	20.52	79108.0
2025-07-22	AAPY	ETF	21.93	22.0143	21.93	22.0143	757.0
2025-07-22	AAVM	ETF	26.85	26.92	26.8	26.8798	5779.0
2025-07-22	AAXJ	ETF	84.9	85.245	84.49	85.2	415288.0
2025-07-22	ABCS	ETF	29.1333	29.31	29.1333	29.3041	2712.0
2025-07-22	ABEQ	ETF	34.56	34.6837	34.56	34.6837	762.0
2025-07-22	ABFL	ETF	70.06	70.32	70.06	70.2315	8784.0
2025-07-22	ABLD	ETF	28.88	28.94	28.87	28.94	4836.0
2025-07-22	ABLG	ETF	30.45	30.5621	30.431	30.5621	2115.0
2025-07-22	ABNY	ETF	60.55	60.7685	59.75	60.55	3058.0
2025-07-22	ABOT	ETF	38.76	38.813	38.76	38.813	1477.0
2025-07-22	ABXB	ETF	19.57	19.5951	19.57	19.5951	2180.0
2025-07-22	ACES	ETF	28.58	29.47	28.47	29.31	59215.0
2025-07-22	ACGR	ETF	60.6883	60.6883	60.6883	60.6883	25.0
2025-07-22	ACIO	ETF	41.69	41.7575	41.64	41.74	81424.0
2025-07-22	ACLC	ETF	73.07	73.3381	73.07	73.3381	2208.0
2025-07-22	ACSI	ETF	63.9257	63.9257	63.9257	63.9257	262.0
2025-07-22	ACTV	ETF	32.145	32.2988	32.145	32.2988	2056.0
2025-07-22	ACVF	ETF	47.72	47.76	47.53	47.7542	3760.0
2025-07-22	ACWI	ETF	130.32	130.46	129.65	130.35	1961832.0
2025-07-22	ACWV	ETF	117.55	118.3617	117.52	118.24	102297.0
2025-07-22	ACWX	ETF	61.23	61.4799	61.04	61.44	568041.0
2025-07-22	ADBG	ETF	12.53	12.77	12.53	12.695	37168.0
2025-07-22	ADFI	ETF	8.47	8.5069	8.47	8.4949	13372.0
2025-07-22	ADIV	ETF	18.25	18.25	18.0199	18.09	13469.0
2025-07-22	ADME	ETF	48.46	48.6694	48.46	48.6578	6115.0
2025-07-22	ADPV	ETF	39.6101	39.84	39.08	39.766	16750.0
2025-07-22	ADVE	ETF	36.3305	36.3305	36.3305	36.3305	6.0
2025-07-22	AESR	ETF	19.39	19.42	19.34	19.4008	14286.0
2025-07-22	AETH	ETF	50.61	51.2741	49.72	50.18	11073.0
2025-07-22	AFIF	ETF	9.35	9.35	9.32	9.33	24166.0
2025-07-22	AFIX	ETF	24.9533	24.96	24.9533	24.955	3698.0
2025-07-22	AFK	ETF	21.0	21.67	20.9	21.5327	23127.0
2025-07-22	AFLG	ETF	36.65	36.7199	36.5468	36.7	171469.0
2025-07-22	AFMC	ETF	32.46	32.68	32.45	32.615	13535.0
2025-07-22	AFSC	ETF	29.0207	29.0207	29.0207	29.0207	0.0

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

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