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×endpoint = /api/etfs/SPY/holdings×

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

etftext	tickertext	vintage_datedate	weightnumeric	sharesnumeric	sectortext	country_nametext	country_codetext	continent