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 500 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-22 12:27 |
| BAC |
| BA |
| AZO |
| 2026-09-22 12:27 |
| AXP |
| AXON |
| 2026-09-22 12:27 |
| AWK |
| AVY |
| AVGO |
| ATO |
| 2026-09-22 12:27 |
| ARES |
| 2026-09-22 12:27 |
| ARE |
| APTV |
| APP |
| 2026-09-22 12:27 |
| APO |
| APH |
| 2026-09-22 12:27 |
| APD |
| APA |
| AOS |
| AON |
| ANET |
| AMZN |
| AMT |
| 2026-09-22 12:27 |
| AMP |
| AMGN |
| AME |
| 2026-09-22 12:27 |
| AMD |
| AMCR |
| AMAT |
| ALLE |
| ALL |
| ALGN |
| ALB |
| AKAM |
| 2026-09-22 12:27 |
| AJG |
| AIZ |
| 2026-09-22 12:27 |
| AIG |
| AFL |
| AES |
| 2026-09-22 12:27 |
| AEP |
| AEE |
| ADSK |
| 2026-09-22 12:27 |
| ADP |
| 2026-09-22 12:27 |
| ADM |
| ADI |
| ADBE |
| ACN |
| 2026-09-22 12:27 |
| ACGL |
| ABT |
| ABNB |