PREVIEW / etf_daily / 2025-07-28

all etf daily files

  file:    by_date/etf_daily/2025/2025-07-28.parquet
  size:    159 KB
  rows:    4,224

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-28	SPY	ETF	637.48	638.04	635.54	636.94	55536737.0
2025-07-28	QQQ	ETF	567.74	569.04	566.87	568.14	31498739.0
2025-07-28	IWM	ETF	225.32	225.44	223.43	224.12	24941447.0
2025-07-28	DIA	ETF	448.66	449.48	447.375	448.34	2863065.0
2025-07-28	GLD	ETF	306.44	306.58	304.05	305.41	9271275.0
2025-07-28	TLT	ETF	85.99	86.2	85.83	85.87	26809070.0
2025-07-28	AAA	ETF	25.03	25.069	24.96	25.0	5188.0
2025-07-28	AAAU	ETF	32.86	32.88	32.6	32.76	2468259.0
2025-07-28	AADR	ETF	78.07	78.4	78.05	78.4	1619.0
2025-07-28	AAPB	ETF	21.75	21.91	21.5601	21.77	195509.0
2025-07-28	AAPD	ETF	16.89	16.945	16.805	16.88	833672.0
2025-07-28	AAPR	ETF	27.4916	27.53	27.46	27.495	5725.0
2025-07-28	AAPU	ETF	23.68	23.85	23.45	23.66	2404940.0
2025-07-28	AAPW	ETF	35.65	35.91	35.59	35.6	74603.0
2025-07-28	AAPX	ETF	20.42	20.57	20.25	20.43	118659.0
2025-07-28	AAPY	ETF	22.03	22.13	21.9786	22.0376	1930.0
2025-07-28	AAVM	ETF	26.83	26.83	26.77	26.7993	711.0
2025-07-28	AAXJ	ETF	85.17	85.31	84.915	85.02	314943.0
2025-07-28	ABCS	ETF	29.42	29.45	29.32	29.3444	3994.0
2025-07-28	ABEQ	ETF	34.7	34.7	34.45	34.47	76200.0
2025-07-28	ABFL	ETF	71.1479	71.23	71.06	71.2	15188.0
2025-07-28	ABLD	ETF	29.11	29.11	28.95	28.97	1860.0
2025-07-28	ABLG	ETF	30.4	30.4	30.305	30.305	1119.0
2025-07-28	ABNY	ETF	59.2	59.7	58.75	59.325	2087.0
2025-07-28	ABOT	ETF	39.4	39.4615	39.4	39.4615	341.0
2025-07-28	ABXB	ETF	19.538	19.538	19.538	19.538	10.0
2025-07-28	ACES	ETF	28.78	28.87	28.3	28.46	10327.0
2025-07-28	ACGR	ETF	61.8	61.9656	61.8	61.9656	127.0
2025-07-28	ACIO	ETF	42.11	42.14	41.9702	42.06	135063.0
2025-07-28	ACLC	ETF	73.92	74.21	73.92	74.0668	8072.0
2025-07-28	ACSI	ETF	64.1885	64.1885	64.1885	64.1885	102.0
2025-07-28	ACTV	ETF	32.7495	32.7495	32.585	32.6273	2351.0
2025-07-28	ACVF	ETF	48.35	48.35	48.17	48.2481	4894.0
2025-07-28	ACWI	ETF	131.62	131.63	131.045	131.29	1965044.0
2025-07-28	ACWV	ETF	118.05	118.05	117.21	117.28	82326.0
2025-07-28	ACWX	ETF	61.6	61.625	61.195	61.31	1235192.0
2025-07-28	ADBG	ETF	12.57	12.605	12.384	12.4217	27273.0
2025-07-28	ADFI	ETF	8.46	8.49	8.4401	8.465	12853.0
2025-07-28	ADIV	ETF	18.01	18.07	17.98	17.99	2842.0
2025-07-28	ADME	ETF	49.23	49.23	49.0	49.1165	6093.0
2025-07-28	ADPV	ETF	40.38	40.38	39.9	40.1115	11207.0
2025-07-28	ADVE	ETF	36.1638	36.1638	36.1638	36.1638	29.0
2025-07-28	AESR	ETF	19.5	19.515	19.44	19.4843	16516.0
2025-07-28	AETH	ETF	52.55	52.55	51.41	51.7488	6468.0
2025-07-28	AFIF	ETF	9.345	9.35	9.33	9.35	17963.0
2025-07-28	AFIX	ETF	24.77	24.78	24.77	24.78	4969.0
2025-07-28	AFK	ETF	21.55	21.55	21.1	21.1	28491.0
2025-07-28	AFLG	ETF	37.16	37.16	36.9201	36.98	51987.0
2025-07-28	AFMC	ETF	32.725	32.725	32.56	32.63	4551.0
2025-07-28	AFSC	ETF	29.14	29.14	29.0958	29.0958	104.0

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

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