ETF holdings

core.etf_holdings

Class E accrual. Cash rows are sentinel-tickered; see the ck_etf_holdings_cash_is_sentinel constraint.

18,322 rowsCSV — whole table, not this view

Sources in this table

uw_etf_holdings18,322 rowsexportable

active:country_code = US×ticker = AWK×sorted by as_of ↑×

as_of leads no index, so this sort reads every matching row and keeps only the top 50 in a heap (the page LIMIT), under a 5s statement timeout.

etftext	tickertext	vintage_datedate	weightnumeric	sharesnumeric	sectortext	country_nametext	country_codetext	continenttext	short_nametext	security_typetext	has_optionsboolean	cusiptext	isintext	sourcetext	endpointtext	request_paramsjsonb	as_of ↑date	vintage_tstimestamp with time zone	retrieved_attimestamp with time zone	vendor_tickertext
XLU	AWK	2026-07-31	1.917000	3224735.00	Utilities	UNITED STATES	US	North America	AMERICAN WATER WORKS COMPANY	stock	true	—	—	uw_etf_holdings	/api/etfs/XLU/holdings	{"limit":1000}	2026-09-06	2026-09-06 23:27	2026-09-06 23:27	AWK
XLU	AWK	2026-06-30	1.816457	3190522.00	Utilities	UNITED STATES	US	North America	AMERICAN WATER WORKS COMPANY	stock	true	—	—	uw_etf_holdings	/api/etfs/XLU/holdings	{"limit":1000}	2026-09-06	2026-09-06 23:27	2026-09-06 23:27	AWK
SPY	AWK	2026-09-03	0.041246	2385829.00	Utilities	UNITED STATES	US	North America	AMERICAN WATER WORKS COMPANY	stock	true	—	—	uw_etf_holdings	/api/etfs/SPY/holdings	{"limit":1000}	2026-09-06	2026-09-06 23:27	2026-09-06 23:27	AWK
SPY	AWK	2026-09-04	0.041339	2382326.00	Utilities	UNITED STATES	US	North America	AMERICAN WATER WORKS COMPANY	stock	true	—	—	uw_etf_holdings	/api/etfs/SPY/holdings	{"limit":1000}	2026-09-09	2026-09-09 16:30	2026-09-09 16:30	AWK
SPY	AWK	2026-09-08	0.041486	2386055.00	Utilities	UNITED STATES	US	North America	AMERICAN WATER WORKS COMPANY	stock	true	—	—	uw_etf_holdings	/api/etfs/SPY/holdings	{"limit":1000}	2026-09-10	2026-09-10 16:30	2026-09-10 16:30	AWK
SPY	AWK	2026-09-09	0.041671	2387411.00	Utilities	UNITED STATES	US	North America	AMERICAN WATER WORKS COMPANY	stock	true	—	—	uw_etf_holdings	/api/etfs/SPY/holdings	{"limit":1000}	2026-09-11	2026-09-11 16:30	2026-09-11 16:30	AWK
SPY	AWK	2026-09-10	0.041765	2399276.00	Utilities	UNITED STATES	US	North America	AMERICAN WATER WORKS COMPANY	stock	true	—	—	uw_etf_holdings	/api/etfs/SPY/holdings	{"limit":1000}	2026-09-14	2026-09-14 16:30	2026-09-14 16:30	AWK
SPY	AWK	2026-09-11	0.040771	2388993.00	Utilities	UNITED STATES	US	North America	AMERICAN WATER WORKS COMPANY	stock	true	—	—	uw_etf_holdings	/api/etfs/SPY/holdings	{"limit":1000}	2026-09-15	2026-09-15 16:30	2026-09-15 16:30	AWK
SPY	AWK	2026-09-14	0.041333	2381987.00	Utilities	UNITED STATES	US	North America	AMERICAN WATER WORKS COMPANY	stock	true	—	—	uw_etf_holdings	/api/etfs/SPY/holdings	{"limit":1000}	2026-09-16	2026-09-16 16:30	2026-09-16 16:30	AWK
SPY	AWK	2026-09-15	0.041245	2350460.00	Utilities	UNITED STATES	US	North America	AMERICAN WATER WORKS COMPANY	stock	true	—	—	uw_etf_holdings	/api/etfs/SPY/holdings	{"limit":1000}	2026-09-17	2026-09-17 16:30	2026-09-17 16:30	AWK
SPY	AWK	2026-09-16	0.041350	2335544.00	Utilities	UNITED STATES	US	North America	AMERICAN WATER WORKS COMPANY	stock	true	—	—	uw_etf_holdings	/api/etfs/SPY/holdings	{"limit":1000}	2026-09-18	2026-09-18 16:30	2026-09-18 16:30	AWK
SPY	AWK	2026-09-18	0.040966	2385735.00	Utilities	UNITED STATES	US	North America	AMERICAN WATER WORKS COMPANY	stock	true	—	—	uw_etf_holdings	/api/etfs/SPY/holdings	{"limit":1000}	2026-09-22	2026-09-22 12:27	2026-09-22 12:27	AWK