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.
Simplify Analyticsuw_etf_weights4,292 rowsexportable| etftext | dimensiontext | labeltext | as_of ↓date | weight_fractionnumeric | sourcetext | endpointtext | request_paramsjsonb | vintage_ts |
|---|
| retrieved_attimestamp with time zone |
|---|
| XLK | sector | Utilities | 2026-09-22 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Technology Services | 2026-09-22 | 0.465300000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Technology | 2026-09-22 | 1.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Real Estate | 2026-09-22 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Producer Manufacturing | 2026-09-22 | 0.031100000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Other | 2026-09-22 | 0.001303310626 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Mutual fund | 2026-09-22 | 0.000438494700 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Materials | 2026-09-22 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Information Technology | 2026-09-22 | 1.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Industrials | 2026-09-22 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Healthcare | 2026-09-22 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Financials | 2026-09-22 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Financial Services | 2026-09-22 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Energy | 2026-09-22 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Electronic Technology | 2026-09-22 | 0.503200000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Consumer Discretionary | 2026-09-22 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Consumer Defensive | 2026-09-22 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Consumer Cyclical | 2026-09-22 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Communication Services | 2026-09-22 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Cash | 2026-09-22 | -0.000032640100 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Basic Materials | 2026-09-22 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-22 16:30 | 2026-09-22 16:30 |
| XLK | sector | Utilities | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Technology Services | 2026-09-21 | 0.465300000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Technology | 2026-09-21 | 1.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Real Estate | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Producer Manufacturing | 2026-09-21 | 0.031100000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Other | 2026-09-21 | 0.001303310626 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Mutual fund | 2026-09-21 | 0.000438494700 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Materials | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Information Technology | 2026-09-21 | 1.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Industrials | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Healthcare | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Financials | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Financial Services | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Energy | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Electronic Technology | 2026-09-21 | 0.503200000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Consumer Discretionary | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Consumer Defensive | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Consumer Cyclical | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Communication Services | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Cash | 2026-09-21 | -0.000032640100 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Basic Materials | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | sector | Utilities | 2026-09-18 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLK | sector | Technology Services | 2026-09-18 | 0.465300000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLK | sector | Technology | 2026-09-18 | 1.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLK | sector | Real Estate | 2026-09-18 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLK | sector | Producer Manufacturing | 2026-09-18 | 0.031100000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLK | sector | Other | 2026-09-18 | 0.001303310626 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLK | sector | Mutual fund | 2026-09-18 | 0.000438494700 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLK | sector | Materials | 2026-09-18 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |