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.
uw_etf_weights4,292 rowsexportable| etftext | dimensiontext | labeltext | as_of ↓date | weight_fractionnumeric | sourcetext | endpointtext | request_paramsjsonb | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|
| 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 | sector | Utilities | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Technology Services | 2026-09-21 | 0.060700000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Technology | 2026-09-21 | 0.999900000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Real Estate | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Producer Manufacturing | 2026-09-21 | 0.089700000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Other | 2026-09-21 | -0.000299970003 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Materials | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Information Technology | 2026-09-21 | 1.000000000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Industrials | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Healthcare | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Financials | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Financial Services | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Energy | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Electronic Technology | 2026-09-21 | 0.849300000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Consumer Discretionary | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Consumer Defensive | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Consumer Cyclical | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Communication Services | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Cash | 2026-09-21 | 0.000261288500 | uw_etf_weights | /api/etfs/SMH/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| SMH | sector | Basic Materials | 2026-09-21 | 0.000000000000 | uw_etf_weights | /api/etfs/SMH/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 | sector | Utilities | 2026-09-21 | 0.013200000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Transportation | 2026-09-21 | 0.012600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Technology Services | 2026-09-21 | 0.336400000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Technology | 2026-09-21 | 0.514300000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Retail Trade | 2026-09-21 | 0.107600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Real Estate | 2026-09-21 | 0.002101200000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Producer Manufacturing | 2026-09-21 | 0.026100000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Other | 2026-09-21 | 0.000100000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Materials | 2026-09-21 | 0.015400000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Information Technology | 2026-09-21 | 0.503000000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Industrials | 2026-09-21 | 0.034200000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Industrial Services | 2026-09-21 | 0.002224700000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Healthcare | 2026-09-21 | 0.063400000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Health Technology | 2026-09-21 | 0.065200000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Financials | 2026-09-21 | 0.004818200000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Financial Services | 2026-09-21 | 0.005097600000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Energy Minerals | 2026-09-21 | 0.002369200000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Energy | 2026-09-21 | 0.004533100000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Electronic Technology | 2026-09-21 | 0.296300000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |
| QQQ | sector | Distribution Services | 2026-09-21 | 0.003109400000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-21 16:30 | 2026-09-21 16:30 |