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 | country | Netherlands | 2026-09-21 | 0.007100000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | country | Israel | 2026-09-21 | 0.000600000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLK | country | Ireland | 2026-09-21 | 0.022900000000 | uw_etf_weights | /api/etfs/XLK/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLI | country | United States | 2026-09-21 | 1.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLI | country | United Kingdom | 2026-09-21 | 0.003600000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLI | country | Other | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLI | country | Ireland | 2026-09-21 | 0.068700000000 | uw_etf_weights | /api/etfs/XLI/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLF | country | United States | 2026-09-21 | 0.976400000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLF | country | United Kingdom | 2026-09-21 | 0.004900000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLF | country | Switzerland | 2026-09-21 | 0.018700000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLF | country | Other | 2026-09-21 | 0.003900000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLF | country | Ireland | 2026-09-21 | 0.010000000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLF | country | Bermuda | 2026-09-21 | 0.009400000000 | uw_etf_weights | /api/etfs/XLF/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLE | country | United States | 2026-09-21 | 1.000000000000 | uw_etf_weights | /api/etfs/XLE/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| XLE | country | Other | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/XLE/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SPY | country | United States | 2026-09-21 | 0.993700000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SPY | country | United Kingdom | 2026-09-21 | 0.001000000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SPY | country | Switzerland | 2026-09-21 | 0.003000000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SPY | country | Singapore | 2026-09-21 | 0.000400000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SPY | country | Other | 2026-09-21 | 0.000500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SPY | country | Netherlands | 2026-09-21 | 0.001400000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SPY | country | Israel | 2026-09-21 | 0.000100000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SPY | country | Ireland | 2026-09-21 | 0.000400000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SPY | country | Canada | 2026-09-21 | 0.000900000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SPY | country | Bermuda | 2026-09-21 | 0.001200000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SOXX | country | United States | 2026-09-21 | 0.885200000000 | uw_etf_weights | /api/etfs/SOXX/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SOXX | country | United Kingdom | 2026-09-21 | 0.007300000000 | uw_etf_weights | /api/etfs/SOXX/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SOXX | country | Taiwan | 2026-09-21 | 0.072000000000 | uw_etf_weights | /api/etfs/SOXX/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SOXX | country | Netherlands | 2026-09-21 | 0.023300000000 | uw_etf_weights | /api/etfs/SOXX/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SOXX | country | Israel | 2026-09-21 | 0.006100000000 | uw_etf_weights | /api/etfs/SOXX/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SOXX | country | France | 2026-09-21 | 0.006300000000 | uw_etf_weights | /api/etfs/SOXX/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | country | United States | 2026-09-21 | 0.777800000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | country | Taiwan, Province of China | 2026-09-21 | 0.110200000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | country | Taiwan (Province of China) | 2026-09-21 | 0.129700000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | country | Taiwan | 2026-09-21 | 0.145300000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | country | Switzerland | 2026-09-21 | 0.009000000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | country | Other | 2026-09-21 | -0.000400000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | country | Netherlands | 2026-09-21 | 0.067900000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | country | France | 2026-09-21 | 0.024700000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | country | Uruguay | 2026-09-21 | 0.006200000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | country | United States | 2026-09-21 | 0.969600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | country | United Kingdom | 2026-09-21 | 0.006800000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | country | Other | 2026-09-21 | 0.021600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | country | Netherlands | 2026-09-21 | 0.010200000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | country | Hong Kong | 2026-09-21 | 0.008200000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | country | China | 2026-09-21 | 0.006600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | country | Canada | 2026-09-21 | 0.003100000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | country | Brazil | 2026-09-21 | 0.006800000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | country | Australia | 2026-09-21 | 0.002100000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| IWM | country | United States | 2026-09-21 | 0.982200000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |