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 — whole table, not this view
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 |
|---|---|---|---|---|---|---|---|---|---|
| XLF | sector | Utilities | 2026-09-08 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Technology Services | 2026-09-08 | 0.020600000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Technology | 2026-09-08 | 0.029500000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Real Estate | 2026-09-08 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Other | 2026-09-08 | 0.001370989973 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Mutual fund | 2026-09-08 | 0.000751005400 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Materials | 2026-09-08 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Information Technology | 2026-09-08 | 0.028900000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Industrials | 2026-09-08 | 0.004564900000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Healthcare | 2026-09-08 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Financials | 2026-09-08 | 0.966600000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Financial Services | 2026-09-08 | 0.965900000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Finance | 2026-09-08 | 0.769000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Energy | 2026-09-08 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Consumer Discretionary | 2026-09-08 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Consumer Defensive | 2026-09-08 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Consumer Cyclical | 2026-09-08 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Communication Services | 2026-09-08 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Commercial Services | 2026-09-08 | 0.209700000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Cash | 2026-09-08 | 0.000000057296 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Basic Materials | 2026-09-08 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLF | sector | Utilities | 2026-09-09 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Technology Services | 2026-09-09 | 0.020600000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Technology | 2026-09-09 | 0.029500000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Real Estate | 2026-09-09 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Other | 2026-09-09 | 0.001370989973 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Mutual fund | 2026-09-09 | 0.000751005400 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Materials | 2026-09-09 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Information Technology | 2026-09-09 | 0.028900000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Industrials | 2026-09-09 | 0.004564900000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Healthcare | 2026-09-09 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Financials | 2026-09-09 | 0.966600000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Financial Services | 2026-09-09 | 0.965900000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Finance | 2026-09-09 | 0.769000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Energy | 2026-09-09 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Consumer Discretionary | 2026-09-09 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Consumer Defensive | 2026-09-09 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Consumer Cyclical | 2026-09-09 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Communication Services | 2026-09-09 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Commercial Services | 2026-09-09 | 0.209700000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Cash | 2026-09-09 | 0.000000057296 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Basic Materials | 2026-09-09 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLF | sector | Utilities | 2026-09-10 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| XLF | sector | Technology Services | 2026-09-10 | 0.020600000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| XLF | sector | Technology | 2026-09-10 | 0.029500000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| XLF | sector | Real Estate | 2026-09-10 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| XLF | sector | Other | 2026-09-10 | 0.001370989973 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| XLF | sector | Mutual fund | 2026-09-10 | 0.000751005400 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| XLF | sector | Materials | 2026-09-10 | 0.000000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| XLF | sector | Information Technology | 2026-09-10 | 0.028900000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |