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
| etftext | dimensiontext | labeltext | as_of ↑date | weight_fractionnumeric | sourcetext | endpointtext | request_paramsjsonb | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|
| XLY | sector | Retail Trade | 2026-09-08 | 0.478800000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLV | sector | Retail Trade | 2026-09-08 | 0.017700000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLP | sector | Retail Trade | 2026-09-08 | 0.254100000000 | uw_etf_weights | /api/etfs/XLP/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLI | sector | Retail Trade | 2026-09-08 | 0.019300000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| SPY | sector | Retail Trade | 2026-09-08 | 0.081500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Retail Trade | 2026-09-08 | 0.107600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| DIA | sector | Retail Trade | 2026-09-08 | 0.103500000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| XLY | sector | Retail Trade | 2026-09-09 | 0.478800000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLV | sector | Retail Trade | 2026-09-09 | 0.017700000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLP | sector | Retail Trade | 2026-09-09 | 0.254100000000 | uw_etf_weights | /api/etfs/XLP/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLI | sector | Retail Trade | 2026-09-09 | 0.019300000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| SPY | sector | Retail Trade | 2026-09-09 | 0.081500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| QQQ | sector | Retail Trade | 2026-09-09 | 0.107600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| DIA | sector | Retail Trade | 2026-09-09 | 0.103500000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| XLY | sector | Retail Trade | 2026-09-10 | 0.478800000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| XLV | sector | Retail Trade | 2026-09-10 | 0.017700000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| XLP | sector | Retail Trade | 2026-09-10 | 0.254100000000 | uw_etf_weights | /api/etfs/XLP/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| XLI | sector | Retail Trade | 2026-09-10 | 0.019300000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| SPY | sector | Retail Trade | 2026-09-10 | 0.081500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| QQQ | sector | Retail Trade | 2026-09-10 | 0.107600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Retail Trade | 2026-09-10 | 0.103500000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| XLY | sector | Retail Trade | 2026-09-11 | 0.478800000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLV | sector | Retail Trade | 2026-09-11 | 0.017700000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLP | sector | Retail Trade | 2026-09-11 | 0.254100000000 | uw_etf_weights | /api/etfs/XLP/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 |
| SPY | sector | Retail Trade | 2026-09-11 | 0.081500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| QQQ | sector | Retail Trade | 2026-09-11 | 0.107600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| DIA | sector | Retail Trade | 2026-09-11 | 0.103500000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| XLY | sector | Retail Trade | 2026-09-14 | 0.478800000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLV | sector | Retail Trade | 2026-09-14 | 0.017700000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLP | sector | Retail Trade | 2026-09-14 | 0.254100000000 | uw_etf_weights | /api/etfs/XLP/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 |
| SPY | sector | Retail Trade | 2026-09-14 | 0.081500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| QQQ | sector | Retail Trade | 2026-09-14 | 0.107600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| DIA | sector | Retail Trade | 2026-09-14 | 0.103500000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-14 16:30 | 2026-09-14 16:30 |
| XLY | sector | Retail Trade | 2026-09-15 | 0.478800000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-15 16:30 | 2026-09-15 16:30 |
| XLV | sector | Retail Trade | 2026-09-15 | 0.017700000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-15 16:30 | 2026-09-15 16:30 |
| XLP | sector | Retail Trade | 2026-09-15 | 0.254100000000 | uw_etf_weights | /api/etfs/XLP/weights | {} | 2026-09-15 16:30 | 2026-09-15 16:30 |
| XLI | sector | Retail Trade | 2026-09-15 | 0.019300000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-15 16:30 | 2026-09-15 16:30 |
| SPY | sector | Retail Trade | 2026-09-15 | 0.081500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-15 16:30 | 2026-09-15 16:30 |
| QQQ | sector | Retail Trade | 2026-09-15 | 0.107600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-15 16:30 | 2026-09-15 16:30 |
| DIA | sector | Retail Trade | 2026-09-15 | 0.103500000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-15 16:30 | 2026-09-15 16:30 |
| XLY | sector | Retail Trade | 2026-09-16 | 0.478800000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-16 16:30 | 2026-09-16 16:30 |
| XLV | sector | Retail Trade | 2026-09-16 | 0.017700000000 | uw_etf_weights | /api/etfs/XLV/weights | {} | 2026-09-16 16:30 | 2026-09-16 16:30 |
| XLP | sector | Retail Trade | 2026-09-16 | 0.254100000000 | uw_etf_weights | /api/etfs/XLP/weights | {} | 2026-09-16 16:30 | 2026-09-16 16:30 |
| XLI | sector | Retail Trade | 2026-09-16 | 0.019300000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-16 16:30 | 2026-09-16 16:30 |
| SPY | sector | Retail Trade | 2026-09-16 | 0.081500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-16 16:30 | 2026-09-16 16:30 |
| QQQ | sector | Retail Trade | 2026-09-16 | 0.107600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-16 16:30 | 2026-09-16 16:30 |
| DIA | sector | Retail Trade | 2026-09-16 | 0.103500000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-16 16:30 | 2026-09-16 16:30 |
| XLY | sector | Retail Trade | 2026-09-17 | 0.478800000000 | uw_etf_weights | /api/etfs/XLY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |