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 500 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 |
| LMT |
| 2026-09-06 23:27 |
| LII |
| 2026-09-06 23:27 |
| LHX |
| 2026-09-06 23:27 |
| LDOS |
| 2026-09-06 23:27 |
| JCI |
| 2026-09-06 23:27 |
| JBHT |
| 2026-09-06 23:27 |
| J |
| 2026-09-06 23:27 |
| ITW |
| 2026-09-06 23:27 |
| IR |
| 2026-09-06 23:27 |
| IEX |
| 2026-09-06 23:27 |
| HWM |
| 2026-09-06 23:27 |
| HUBB |
| 2026-09-06 23:27 |
| HON |
| 2026-09-06 23:27 |
| 2026-09-06 23:27 |
| HII |
| 2026-09-06 23:27 |
| GWW |
| 2026-09-06 23:27 |
| GNRC |
| 2026-09-06 23:27 |
| GE |
| 2026-09-06 23:27 |
| GD |
| 2026-09-06 23:27 |
| FTV |
| 2026-09-06 23:27 |
| FIX |
| 2026-09-06 23:27 |
| FDX |
| 2026-09-06 23:27 |
| FAST |
| 2026-09-06 23:27 |
| 2026-09-06 23:27 |
| EXPD |
| 2026-09-06 23:27 |
| ETN |
| 2026-09-06 23:27 |
| EMR |
| 2026-09-06 23:27 |
| EME |
| 2026-09-06 23:27 |
| EFX |
| 2026-09-06 23:27 |
| DOV |
| 2026-09-06 23:27 |
| DE |
| 2026-09-06 23:27 |
| DAL |
| 2026-09-06 23:27 |
| CTAS |
| 2026-09-06 23:27 |
| CSX |
| 2026-09-06 23:27 |
| CPRT |
| 2026-09-06 23:27 |
| CMI |
| 2026-09-06 23:27 |
| CHRW |
| 2026-09-06 23:27 |
| CAT |
| 2026-09-06 23:27 |
| CARR |
| 2026-09-06 23:27 |
| 2026-09-06 23:27 |
| BR |
| 2026-09-06 23:27 |
| BLDR |
| 2026-09-06 23:27 |
| BA |
| 2026-09-06 23:27 |
| AXON |
| 2026-09-06 23:27 |
| AOS |
| 2026-09-06 23:27 |
| AME |
| 2026-09-06 23:27 |
| ALLE |
| 2026-09-06 23:27 |
| ADP |