core.etf_holdings
Class E accrual. Cash rows are sentinel-tickered; see the ck_etf_holdings_cash_is_sentinel constraint.
uw_etf_holdings25,962 rowsexportableas_of leads no index, so this sort reads every matching row and keeps only the top 1,000 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 |
|---|
| 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 |
|---|
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| AFL |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| ACGL |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| PYPL |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| WT |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| WSFS |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| WSBC |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| WD |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| WAFD |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| WABC |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| VRTS |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| VLY |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| VCTR |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| UVSP |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| UVE |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| UPST |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| UMBF |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| UFCS |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| UBSI |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| TRUP |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| TRST |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| TRMK |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| TOWN |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| TMP |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| THFF |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| TFIN |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| TCBK |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| TCBI |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| TBBK |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| SYBT |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| STEP |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| STC |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| STBA |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| SRCE |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| SPNT |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| SNEX |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| SMBK |
| {"limit":1000} |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| SKWD |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| SIGI |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| SFNC |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| SFBS |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| SBSI |
| {"limit":1000} |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| SBCF |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| SAFT |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| RNST |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| RDN |
| 2026-09-23 |
| 2026-09-23 16:30 |
| 2026-09-23 16:30 |
| RBCAA |