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 50 in a heap (the page LIMIT), under a 5s statement timeout.
| etftext | tickertext | vintage_datedate | weightnumeric | sharesnumeric | sectortext | country_nametext | country_codetext | continent |
|---|
| short_nametext |
|---|
| security_typetext |
|---|
| has_optionsboolean |
|---|
| cusiptext |
|---|
| isintext |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_of ↓date |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| vendor_tickertext |
|---|
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| WDFC |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| USLM |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| UFPI |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| SXT |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| SXC |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| SSRM |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| SLVM |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| SCL |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| PPTA |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| ODC |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| NGVT |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| MTX |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| MTRN |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| LWLG |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| KWR |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| KOP |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| KALU |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| IOSP |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| IE |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| HYMC |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| HWKN |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| HUN |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| HCC |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| GPRE |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| FUL |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| FMC |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| ECVT |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 16:30 |
| 2026-09-22 16:30 |
| DC |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| CMC |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| CENX |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| CC |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| CBT |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| BCPC |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| BCC |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| AVNT |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| ASH |
| {"limit":1000} |
| 2026-09-22 |
| 2026-09-22 12:27 |
| 2026-09-22 12:27 |
| AMR |
| {"limit":1000} |
| 2026-09-18 |
| 2026-09-18 16:30 |
| 2026-09-18 16:30 |
| WOR |
| {"limit":1000} |
| 2026-09-18 |
| 2026-09-18 16:30 |
| 2026-09-18 16:30 |
| WDFC |
| {"limit":1000} |
| 2026-09-18 |
| 2026-09-18 16:30 |
| 2026-09-18 16:30 |
| USLM |
| {"limit":1000} |
| 2026-09-18 |
| 2026-09-18 16:30 |
| 2026-09-18 16:30 |
| UFPI |
| {"limit":1000} |
| 2026-09-18 |
| 2026-09-18 16:30 |
| 2026-09-18 16:30 |
| SXT |
| {"limit":1000} |
| 2026-09-18 |
| 2026-09-18 16:30 |
| 2026-09-18 16:30 |
| SXC |
| {"limit":1000} |
| 2026-09-18 |
| 2026-09-18 16:30 |
| 2026-09-18 16:30 |
| SSRM |
| {"limit":1000} |
| 2026-09-18 |
| 2026-09-18 16:30 |
| 2026-09-18 16:30 |
| SLVM |
| {"limit":1000} |
| 2026-09-18 |
| 2026-09-18 16:30 |
| 2026-09-18 16:30 |
| SCL |
| {"limit":1000} |
| 2026-09-18 |
| 2026-09-18 16:30 |
| 2026-09-18 16:30 |
| PPTA |
| {"limit":1000} |
| 2026-09-18 |
| 2026-09-18 16:30 |
| 2026-09-18 16:30 |
| ODC |
| {"limit":1000} |
| 2026-09-18 |
| 2026-09-18 16:30 |
| 2026-09-18 16:30 |
| NGVT |