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 |
|---|
| XLV | sector | Health Technology | 2026-09-08 | 0.762600000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLP | sector | Health Technology | 2026-09-08 | 0.007007100000 | uw_etf_weights | /api/etfs/XLP/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| SPY | sector | Health Technology | 2026-09-08 | 0.096600000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Health Technology | 2026-09-08 | 0.065200000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| DIA | sector | Health Technology | 2026-09-08 | 0.094700000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |