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 350 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 | security_type |
|---|
| 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 |
| GEHC |
| GE |
| GDDY |
| GD |
| FTV |
| FTNT |
| FSLR |
| 2026-09-22 12:27 |
| FRT |
| FOXA |
| FOX |
| FLEX |
| FIX |
| 2026-09-22 12:27 |
| FITB |
| FISV |
| 2026-09-22 12:27 |
| FIS |
| FICO |
| FFIV |
| FERG |
| FE |
| FDX |
| 2026-09-22 12:27 |
| FDS |
| 2026-09-22 12:27 |
| FCX |
| FAST |
| FANG |
| F |
| EXR |
| 2026-09-22 12:27 |
| EXPE |
| 2026-09-22 12:27 |
| EXPD |
| EXC |
| EW |
| EVRG |
| ETR |
| ETN |
| ESS |
| ES |
| 2026-09-22 12:27 |
| ERIE |
| EQT |
| EQIX |
| EOG |
| EMR |
| EME |
| ELV |
| EL |
| EIX |
| EFX |
| ED |