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
active:label = Other×
| etftext | dimensiontext | labeltext | as_of ↓date | weight_fractionnumeric | sourcetext | endpointtext | request_paramsjsonb | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|
| XLY | sector | Other | 2026-09-18 | 0.000100000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLY | country | Other | 2026-09-18 | 0.000000000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLV | sector | Other | 2026-09-18 | 0.000886788379 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLV | country | Other | 2026-09-18 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLU | sector | Other | 2026-09-18 | 0.000351920551 | uw_etf_weights | /api/etfs/XLU/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLU | country | Other | 2026-09-18 | 0.000000000000 | uw_etf_weights | /api/etfs/XLU/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLP | sector | Other | 2026-09-18 | 0.002542966389 | uw_etf_weights | /api/etfs/XLP/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLP | country | Other | 2026-09-18 | 0.000000000000 | uw_etf_weights | /api/etfs/XLP/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 | country | Other | 2026-09-18 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLI | sector | Other | 2026-09-18 | 0.001144972293 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLI | country | Other | 2026-09-18 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLF | sector | Other | 2026-09-18 | 0.001370989973 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLF | country | Other | 2026-09-18 | 0.003900000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLE | sector | Other | 2026-09-18 | 0.001372566268 | uw_etf_weights | /api/etfs/XLE/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLE | country | Other | 2026-09-18 | 0.000000000000 | uw_etf_weights | /api/etfs/XLE/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Other | 2026-09-18 | 0.001639458528 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | country | Other | 2026-09-18 | 0.000500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SMH | sector | Other | 2026-09-18 | -0.000299970003 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SMH | country | Other | 2026-09-18 | -0.000400000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| QQQ | sector | Other | 2026-09-18 | 0.000100000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| QQQ | country | Other | 2026-09-18 | 0.021600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| DIA | sector | Other | 2026-09-18 | 0.001555737330 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| DIA | country | Other | 2026-09-18 | 0.000000000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| XLY | sector | Other | 2026-09-17 | 0.000100000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | country | Other | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | sector | Other | 2026-09-17 | 0.000886788379 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLV | country | Other | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLU | sector | Other | 2026-09-17 | 0.000351920551 | uw_etf_weights | /api/etfs/XLU/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLU | country | Other | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLU/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLP | sector | Other | 2026-09-17 | 0.002542966389 | uw_etf_weights | /api/etfs/XLP/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLP | country | Other | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLP/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLK | sector | Other | 2026-09-17 | 0.001303310626 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLK | country | Other | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLI | sector | Other | 2026-09-17 | 0.001144972293 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLI | country | Other | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLF | sector | Other | 2026-09-17 | 0.001370989973 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLF | country | Other | 2026-09-17 | 0.003900000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLE | sector | Other | 2026-09-17 | 0.001372566268 | uw_etf_weights | /api/etfs/XLE/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLE | country | Other | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/XLE/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| SPY | sector | Other | 2026-09-17 | 0.001639458528 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| SPY | country | Other | 2026-09-17 | 0.000500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| SMH | sector | Other | 2026-09-17 | -0.000299970003 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| SMH | country | Other | 2026-09-17 | -0.000400000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| QQQ | sector | Other | 2026-09-17 | 0.000100000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| QQQ | country | Other | 2026-09-17 | 0.021600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| DIA | sector | Other | 2026-09-17 | 0.001555737330 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| DIA | country | Other | 2026-09-17 | 0.000000000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| XLY | sector | Other | 2026-09-16 | 0.000100000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-16 16:30 | 2026-09-16 16:30 |
| XLY | country | Other | 2026-09-16 | 0.000000000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-16 16:30 | 2026-09-16 16:30 |