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:endpoint = /api/etfs/XLP/holdings×sector = Consumer Defensive×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	continent