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_tstimestamp with time zone | retrieved_at |
|---|
| XLK | sector | Basic Materials | 2026-09-08 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLK | country | United States | 2026-09-08 | 0.990800000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLK | country | Switzerland | 2026-09-08 | 0.004800000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLK | country | Singapore | 2026-09-08 | 0.002100000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLK | country | Other | 2026-09-08 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLK | country | Netherlands | 2026-09-08 | 0.007100000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLK | country | Israel | 2026-09-08 | 0.000600000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLK | country | Ireland | 2026-09-08 | 0.022900000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |