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 400 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 |
|---|
| EBAY |
| DXCM |
| DVN |
| DVA |
| DUK |
| DTE |
| 2026-09-22 12:27 |
| DRI |
| DPZ |
| DOW |
| DOV |
| 2026-09-22 12:27 |
| DOC |
| DLTR |
| 2026-09-22 12:27 |
| DLR |
| 2026-09-22 12:27 |
| DIS |
| DHR |
| DHI |
| DGX |
| 2026-09-22 12:27 |
| DG |
| DELL |
| 2026-09-22 12:27 |
| DECK |
| DE |
| DDOG |
| 2026-09-22 12:27 |
| DD |
| 2026-09-22 12:27 |
| DASH |
| DAL |
| D |
| CVX |
| CVS |
| CVNA |
| CTVA |
| 2026-09-22 12:27 |
| CTSH |
| CTAS |
| CSX |
| CSGP |
| CSCO |
| 2026-09-22 12:27 |
| CRWD |
| CRM |
| 2026-09-22 12:27 |
| CRL |
| CRH |
| 2026-09-22 12:27 |
| CPT |
| CPRT |
| 2026-09-22 12:27 |
| COST |
| COP |
| COO |
| COIN |
| COHR |