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 |
|---|---|---|---|---|---|---|---|---|---|
| QQQ |
| sector |
| Industrial Services |
| 2026-09-08 |
| 0.002224700000 |
| uw_etf_weights |
| /api/etfs/QQQ/weights |
| {} |
| 2026-09-08 08:57 |
| 2026-09-08 08:57 |
| QQQ | sector | Healthcare | 2026-09-08 | 0.063400000000 | uw_etf_weights | /api/etfs/QQQ/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 |
| QQQ | sector | Financials | 2026-09-08 | 0.004818200000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Financial Services | 2026-09-08 | 0.005097600000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Energy Minerals | 2026-09-08 | 0.002369200000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Energy | 2026-09-08 | 0.004533100000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Electronic Technology | 2026-09-08 | 0.296300000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Distribution Services | 2026-09-08 | 0.003109400000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Consumer Services | 2026-09-08 | 0.050800000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Consumer Non-Durables | 2026-09-08 | 0.037700000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Consumer Durables | 2026-09-08 | 0.027700000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Consumer Discretionary | 2026-09-08 | 0.184600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Consumer Defensive | 2026-09-08 | 0.063900000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Consumer Cyclical | 2026-09-08 | 0.126700000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Communications | 2026-09-08 | 0.014200000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Communication Services | 2026-09-08 | 0.157100000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Commercial Services | 2026-09-08 | 0.004825000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Cash | 2026-09-08 | 0.001006000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | sector | Basic Materials | 2026-09-08 | 0.015400000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | country | Uruguay | 2026-09-08 | 0.006200000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | country | United States | 2026-09-08 | 0.969600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | country | United Kingdom | 2026-09-08 | 0.006800000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | country | Other | 2026-09-08 | 0.021600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | country | Netherlands | 2026-09-08 | 0.010200000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | country | Hong Kong | 2026-09-08 | 0.008200000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | country | China | 2026-09-08 | 0.006600000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | country | Canada | 2026-09-08 | 0.003100000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | country | Brazil | 2026-09-08 | 0.006800000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| QQQ | country | Australia | 2026-09-08 | 0.002100000000 | uw_etf_weights | /api/etfs/QQQ/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | sector | Utilities | 2026-09-08 | 0.027200000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | sector | Real Estate | 2026-09-08 | 0.056100000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | sector | Materials | 2026-09-08 | 0.043900000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | sector | Information Technology | 2026-09-08 | 0.129400000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | sector | Industrials | 2026-09-08 | 0.138700000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | sector | Health Care | 2026-09-08 | 0.201600000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | sector | Financials | 2026-09-08 | 0.194500000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | sector | Energy | 2026-09-08 | 0.067900000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | sector | Consumer Staples | 2026-09-08 | 0.019700000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | sector | Consumer Discretionary | 2026-09-08 | 0.091000000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | sector | Communication | 2026-09-08 | 0.024000000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | sector | Cash and/or Derivatives | 2026-09-08 | 0.004200000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | country | United States | 2026-09-08 | 0.979300000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | country | United Kingdom | 2026-09-08 | 0.000900000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | country | Singapore | 2026-09-08 | 0.000500000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | country | Panama | 2026-09-08 | 0.000500000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | country | Norway | 2026-09-08 | 0.002400000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | country | Monaco | 2026-09-08 | 0.000500000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | country | Japan | 2026-09-08 | 0.000000000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |
| IWM | country | Italy | 2026-09-08 | 0.000200000000 | uw_etf_weights | /api/etfs/IWM/weights | {} | 2026-09-08 08:57 | 2026-09-08 08:57 |