core.etf_holdings
Class E accrual. Cash rows are sentinel-tickered; see the ck_etf_holdings_cash_is_sentinel constraint.
uw_etf_holdings29,693 rowsexportableas_of leads no index, so this sort reads every matching row and keeps only the top 2,150 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 |
| BANF |
| 2026-09-06 23:27 |
| BAND |
| 2026-09-06 23:27 |
| BANC |
| 2026-09-06 23:27 |
| AZZ |
| 2026-09-06 23:27 |
| AZTA |
| 2026-09-06 23:27 |
| AXTI |
| 2026-09-06 23:27 |
| AXGN |
| 2026-09-06 23:27 |
| AX |
| 2026-09-06 23:27 |
| AWR |
| 2026-09-06 23:27 |
| AVPT |
| 2026-09-06 23:27 |
| AVNT |
| 2026-09-06 23:27 |
| AVAH |
| 2026-09-06 23:27 |
| AVA |
| 2026-09-06 23:27 |
| AUPH |
| 2026-09-06 23:27 |
| 2026-09-06 23:27 |
| AUB |
| 2026-09-06 23:27 |
| ATRO |
| 2026-09-06 23:27 |
| ATRC |
| 2026-09-06 23:27 |
| ATKR |
| 2026-09-06 23:27 |
| ATEX |
| 2026-09-06 23:27 |
| ATEN |
| 2026-09-06 23:27 |
| ATEC |
| 2026-09-06 23:27 |
| ATAI |
| 2026-09-06 23:27 |
| ASTE |
| 2026-09-06 23:27 |
| ASST |
| 2026-09-06 23:27 |
| 2026-09-06 23:27 |
| ASO |
| 2026-09-06 23:27 |
| ASH |
| 2026-09-06 23:27 |
| ASB |
| 2026-09-06 23:27 |
| ASAN |
| ARX |
| 2026-09-06 23:27 |
| ARR |
| 2026-09-06 23:27 |
| ARQT |
| 2026-09-06 23:27 |
| AROC |
| 2026-09-06 23:27 |
| ARLO |
| 2026-09-06 23:27 |
| ARDX |
| 2026-09-06 23:27 |
| ARCB |
| 2026-09-06 23:27 |
| APPS |
| 2026-09-06 23:27 |
| APPN |
| 2026-09-06 23:27 |
| APOG |
| 2026-09-06 23:27 |
| APLE |
| 2026-09-06 23:27 |
| 2026-09-06 23:27 |
| APEI |
| 2026-09-06 23:27 |
| 2026-09-06 23:27 |
| APAM |
| 2026-09-06 23:27 |
| AORT |
| 2026-09-06 23:27 |
| ANIP |
| 2026-09-06 23:27 |
| ANF |