ETF sector and country weights
core.etf_weights
One row per (etf, dimension, label). Five labels belong to more than one taxonomy, so weights within a dimension can exceed 1 - see app/core/etf_taxonomy.py.
3,511 rowsCSV
Sources in this table
uw_etf_weights3,511 rowsexportable
| etftext | dimensiontext | labeltext | as_of ↓date | weight_fractionnumeric | sourcetext | endpointtext | request_paramsjsonb | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|
| XLY | sector | Industrials | 2026-09-17 | 0.003732000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | sector | Healthcare | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | sector | Financials | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | sector | Financial Services | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | sector | Energy | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | sector | Electronic Technology | 2026-09-17 | 0.005914500000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | sector | Distribution Services | 2026-09-17 | 0.010400000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | sector | Consumer Services | 2026-09-17 | 0.238300000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | sector | Consumer Non-Durables | 2026-09-17 | 0.040500000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | sector | Consumer Durables | 2026-09-17 | 0.215000000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | sector | Consumer Discretionary | 2026-09-17 | 0.988600000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | sector | Consumer Defensive | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | sector | Consumer Cyclical | 2026-09-17 | 0.989400000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | sector | Communication Services | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | sector | Basic Materials | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | country | United States | 2026-09-17 | 0.992500000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | country | Switzerland | 2026-09-17 | 0.007500000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | country | Other | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | country | Ireland | 2026-09-17 | 0.006500000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | country | Canada | 2026-09-17 | 0.011300000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Utilities | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Technology | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Retail Trade | 2026-09-17 | 0.017700000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Real Estate | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Other | 2026-09-17 | 0.000886788379 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Mutual fund | 2026-09-17 | 0.001405200000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Materials | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Information Technology | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Industrials | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Healthcare | 2026-09-17 | 1.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Health Technology | 2026-09-17 | 0.762600000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Health Services | 2026-09-17 | 0.170500000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Financials | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Financial Services | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Energy | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Distribution Services | 2026-09-17 | 0.045300000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Consumer Discretionary | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Consumer Defensive | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Consumer Cyclical | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Communication Services | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Commercial Services | 2026-09-17 | 0.002499800000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Basic Materials | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | country | United States | 2026-09-17 | 1.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | country | Other | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | country | Ireland | 2026-09-17 | 0.025000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLU | sector | Utilities | 2026-09-17 | 1.000000000000 | uw_etf_weights | /api/etfs/XLU/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLU | sector | Technology | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLU/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLU | sector | Real Estate | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLU/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLU | sector | Other | 2026-09-17 | 0.000351920551 | uw_etf_weights | /api/etfs/XLU/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLU | sector | Mutual fund | 2026-09-17 | 0.000779400900 | uw_etf_weights | /api/etfs/XLU/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |