ETF holdings

core.etf_holdings

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

Sources in this table

active:country_code = US×etf = SPY×

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

etftext	tickertext	vintage_datedate	weightnumeric	sharesnumeric	sectortext	country_nametext	country_codetext	continenttext	short_name