Simplify AnalyticsETF 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,901 rowsCSV — whole table, not this view
Sources in this table
uw_etf_weights3,901 rowsexportable
| etftext | dimensiontext | labeltext | as_of ↑date | weight_fractionnumeric | sourcetext | endpointtext | request_paramsjsonb | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|
| XLI | sector | Transportation | 2026-09-11 | 0.204600000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Technology Services | 2026-09-11 | 0.067600000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Technology | 2026-09-11 | 0.099300000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Retail Trade | 2026-09-11 | 0.019300000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Real Estate | 2026-09-11 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Producer Manufacturing | 2026-09-11 | 0.350000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Other | 2026-09-11 | 0.001144972293 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Mutual fund | 2026-09-11 | 0.000629629500 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Materials | 2026-09-11 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Information Technology | 2026-09-11 | 0.060500000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Industrials | 2026-09-11 | 0.881000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Industrial Services | 2026-09-11 | 0.039600000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Healthcare | 2026-09-11 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Financials | 2026-09-11 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Financial Services | 2026-09-11 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Finance | 2026-09-11 | 0.012200000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Energy | 2026-09-11 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Electronic Technology | 2026-09-11 | 0.246700000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Distribution Services | 2026-09-11 | 0.022900000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Consumer Services | 2026-09-11 | 0.017800000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Consumer Durables | 2026-09-11 | 0.007688000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Consumer Discretionary | 2026-09-11 | 0.003511500000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Consumer Defensive | 2026-09-11 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Consumer Cyclical | 2026-09-11 | 0.003592200000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Communication Services | 2026-09-11 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Commercial Services | 2026-09-11 | 0.010900000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Cash | 2026-09-11 | 0.000040813200 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Basic Materials | 2026-09-11 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | country | United States | 2026-09-11 | 1.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | country | United Kingdom | 2026-09-11 | 0.003600000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | country | Other | 2026-09-11 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | country | Ireland | 2026-09-11 | 0.068700000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLI | sector | Utilities | 2026-09-14 | 0.016200000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Transportation | 2026-09-14 | 0.204600000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Technology Services | 2026-09-14 | 0.067600000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Technology | 2026-09-14 | 0.099300000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Retail Trade | 2026-09-14 | 0.019300000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Real Estate | 2026-09-14 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Producer Manufacturing | 2026-09-14 | 0.350000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Other | 2026-09-14 | 0.001144972293 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Mutual fund | 2026-09-14 | 0.000629629500 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Materials | 2026-09-14 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Information Technology | 2026-09-14 | 0.060500000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Industrials | 2026-09-14 | 0.881000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Industrial Services | 2026-09-14 | 0.039600000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Healthcare | 2026-09-14 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Financials | 2026-09-14 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Financial Services | 2026-09-14 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Finance | 2026-09-14 | 0.012200000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLI | sector | Energy | 2026-09-14 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |