core.etf_holdings
Class E accrual. Cash rows are sentinel-tickered; see the ck_etf_holdings_cash_is_sentinel constraint.
uw_etf_holdings18,322 rowsexportableas_of leads no index, so this sort reads every matching row and keeps only the top 450 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 |
|---|
| 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-06 23:27 |
| AMD |
| 2026-09-06 23:27 |
| AMAT |
| 2026-09-06 23:27 |
| AMAT |
| 2026-09-06 23:27 |
| AKAM |
| 2026-09-06 23:27 |
| AKAM |
| 2026-09-06 23:27 |
| ADSK |
| 2026-09-06 23:27 |
| ADSK |
| 2026-09-06 23:27 |
| ADI |
| 2026-09-06 23:27 |
| ADI |
| 2026-09-06 23:27 |
| ADBE |
| 2026-09-06 23:27 |
| ADBE |
| 2026-09-06 23:27 |
| ACN |
| 2026-09-06 23:27 |
| ACN |
| 2026-09-06 23:27 |
| AAPL |
| 2026-09-06 23:27 |
| AAPL |
| 2026-09-06 23:27 |
| XYL |
| 2026-09-06 23:27 |
| WM |
| 2026-09-06 23:27 |
| 2026-09-06 23:27 |
| WAB |
| 2026-09-06 23:27 |
| VRT |
| 2026-09-06 23:27 |
| VRSK |
| 2026-09-06 23:27 |
| URI |
| 2026-09-06 23:27 |
| UPS |
| 2026-09-06 23:27 |
| UNP |
| 2026-09-06 23:27 |
| UBER |
| 2026-09-06 23:27 |
| UAL |
| 2026-09-06 23:27 |
| TXT |
| 2026-09-06 23:27 |
| TT |
| 2026-09-06 23:27 |
| TDG |
| 2026-09-06 23:27 |
| SWK |
| 2026-09-06 23:27 |
| SNA |
| 2026-09-06 23:27 |
| RTX |
| 2026-09-06 23:27 |
| RSG |
| 2026-09-06 23:27 |
| ROL |
| 2026-09-06 23:27 |
| ROK |
| 2026-09-06 23:27 |
| PWR |
| 2026-09-06 23:27 |
| PNR |
| 2026-09-06 23:27 |
| PH |
| 2026-09-06 23:27 |
| PCAR |
| 2026-09-06 23:27 |
| PAYX |
| 2026-09-06 23:27 |
| OTIS |
| 2026-09-06 23:27 |
| ODFL |
| 2026-09-06 23:27 |
| NSC |
| 2026-09-06 23:27 |
| NOC |
| 2026-09-06 23:27 |
| NDSN |
| 2026-09-06 23:27 |
| MMM |
| 2026-09-06 23:27 |
| MAS |