PREVIEW / etf_daily / 2025-07-29

all etf daily files

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

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-29	SPY	ETF	638.35	638.67	634.335	635.26	60614061.0
2025-07-29	QQQ	ETF	570.76	572.11	566.53	567.26	45463317.0
2025-07-29	IWM	ETF	225.61	225.69	222.055	222.69	28681756.0
2025-07-29	DIA	ETF	448.63	448.85	445.65	446.48	3144483.0
2025-07-29	GLD	ETF	305.8	307.03	304.985	306.25	5739760.0
2025-07-29	TLT	ETF	86.23	87.34	86.2	87.32	47820442.0
2025-07-29	AAA	ETF	25.08	25.089	24.98	25.0297	5190.0
2025-07-29	AAAU	ETF	32.79	32.915	32.7033	32.83	3871300.0
2025-07-29	AADR	ETF	78.42	79.144	78.42	79.144	2145.0
2025-07-29	AAPB	ETF	21.77	21.885	21.09	21.19	301400.0
2025-07-29	AAPD	ETF	16.86	17.12	16.81	17.1035	1377498.0
2025-07-29	AAPR	ETF	27.51	27.53	27.47	27.49	3866.0
2025-07-29	AAPU	ETF	23.72	23.825	22.96	23.07	4350466.0
2025-07-29	AAPW	ETF	35.64	35.9	35.24	35.34	32823.0
2025-07-29	AAPX	ETF	20.44	20.55	19.82	19.92	265053.0
2025-07-29	AAPY	ETF	22.12	22.12	21.8183	21.8183	1669.0
2025-07-29	AAVM	ETF	26.8	26.91	26.76	26.805	2241.0
2025-07-29	AAXJ	ETF	85.24	85.38	84.955	85.0	685954.0
2025-07-29	ABCS	ETF	29.405	29.41	29.2	29.2596	3961.0
2025-07-29	ABEQ	ETF	34.44	34.56	34.43	34.52	8288.0
2025-07-29	ABFL	ETF	70.5	70.5	70.41	70.4783	17076.0
2025-07-29	ABLD	ETF	29.06	29.1081	29.06	29.1081	1898.0
2025-07-29	ABLG	ETF	30.34	30.4	30.34	30.3572	501.0
2025-07-29	ABNY	ETF	59.5	59.5	57.15	57.423	2211.0
2025-07-29	ABOT	ETF	39.1244	39.1244	39.1244	39.1244	234.0
2025-07-29	ABXB	ETF	19.545	19.545	19.545	19.545	18.0
2025-07-29	ACES	ETF	28.43	28.43	27.76	27.7939	6144.0
2025-07-29	ACGR	ETF	61.7891	61.7891	61.7891	61.7891	5.0
2025-07-29	ACIO	ETF	42.05	42.0967	41.9401	41.96	128762.0
2025-07-29	ACLC	ETF	74.21	74.21	73.8581	73.8581	1802.0
2025-07-29	ACSI	ETF	64.0	64.0	63.9321	63.9321	570.0
2025-07-29	ACTV	ETF	32.64	32.64	32.3883	32.3883	50467.0
2025-07-29	ACVF	ETF	48.35	48.37	48.1	48.1677	2204.0
2025-07-29	ACWI	ETF	131.45	131.57	130.88	131.05	2138014.0
2025-07-29	ACWV	ETF	117.36	117.83	117.3	117.61	108979.0
2025-07-29	ACWX	ETF	61.31	61.38	61.16	61.24	685913.0
2025-07-29	ADBG	ETF	12.47	12.88	12.46	12.5301	78750.0
2025-07-29	ADFI	ETF	8.4632	8.52	8.4632	8.505	7243.0
2025-07-29	ADIV	ETF	18.07	18.08	17.98	17.98	8024.0
2025-07-29	ADME	ETF	49.16	49.215	48.98	49.029	5391.0
2025-07-29	ADPV	ETF	40.215	40.22	39.5	39.5233	16719.0
2025-07-29	ADVE	ETF	36.13	36.176	36.13	36.176	113.0
2025-07-29	AESR	ETF	19.39	19.3973	19.34	19.3506	17843.0
2025-07-29	AETH	ETF	52.91	53.17	51.045	51.4632	18485.0
2025-07-29	AFIF	ETF	9.3493	9.36	9.3301	9.345	14897.0
2025-07-29	AFIX	ETF	24.82	24.91	24.82	24.91	3018.0
2025-07-29	AFK	ETF	21.1	21.3853	21.1	21.28	14417.0
2025-07-29	AFLG	ETF	37.14	37.14	36.875	36.92	113844.0
2025-07-29	AFMC	ETF	32.77	32.77	32.57	32.6088	5584.0
2025-07-29	AFSC	ETF	29.23	29.23	28.93	28.93	4554.0

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

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