core.etf_holdings
Class E accrual. Cash rows are sentinel-tickered; see the ck_etf_holdings_cash_is_sentinel constraint.
uw_etf_holdings31,862 rowsexportableas_of leads no index, so this sort reads every matching row and keeps only the top 250 in a heap (the page LIMIT), under a 5s statement timeout.
| etftext | tickertext | vintage_datedate | weightnumeric | sharesnumeric | sectortext | country_nametext | country_codetext | continenttext |
|---|
| 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-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| KFY |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| KFRC |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| KAI |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| JOBY |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| JBLU |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| INSW |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| ICFI |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| IBP |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| HURN |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| HUBG |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| HRI |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| HNI |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| HLMN |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| HLIO |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| GVA |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| GRC |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| GNK |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| GHM |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| GFF |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| GBX |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| GATX |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| FSS |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| FLR |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| FELE |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| FCEL |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| FA |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| EXPO |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| EVLV |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| EPAC |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| EOSE |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| ENS |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| ENR |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| DXPE |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| DCO |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| CYRX |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| CXT |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| CWST |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| CRAI |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| CECO |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| CDRE |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| CBZ |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| BW |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| BMI |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| BDC |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| BCO |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| AZZ |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| ATRO |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| ATKR |
| {"limit":1000} |
| 2026-10-01 |
| 2026-10-01 16:30 |
| 2026-10-01 16:30 |
| ASTE |