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 |
|---|
| DIA | sector | Communication Services | 2026-09-11 | 0.021600000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| DIA | sector | Commercial Services | 2026-09-11 | 0.047500000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| DIA | sector | Cash | 2026-09-11 | 0.001062100000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| DIA | sector | Basic Materials | 2026-09-11 | 0.008133400000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| DIA | country | United States | 2026-09-11 | 1.000000000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| DIA | country | Other | 2026-09-11 | 0.000000000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-11 16:30 | 2026-09-11 16:30 |
| DIA | sector | Utilities | 2026-09-10 | 0.000000000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Technology Services | 2026-09-10 | 0.161000000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Technology | 2026-09-10 | 0.188400000000 | uw_etf_weights | /api/etfs/DIA/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 |
| DIA | sector | Real Estate | 2026-09-10 | 0.000000000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Producer Manufacturing | 2026-09-10 | 0.072500000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Process Industries | 2026-09-10 | 0.009624200000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Other | 2026-09-10 | 0.001555737330 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Materials | 2026-09-10 | 0.008771900000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Information Technology | 2026-09-10 | 0.187200000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Industrials | 2026-09-10 | 0.133900000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Healthcare | 2026-09-10 | 0.188900000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Health Technology | 2026-09-10 | 0.094700000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Health Services | 2026-09-10 | 0.080000000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Financials | 2026-09-10 | 0.232300000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Financial Services | 2026-09-10 | 0.235800000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Finance | 2026-09-10 | 0.172300000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Energy Minerals | 2026-09-10 | 0.025100000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Energy | 2026-09-10 | 0.022600000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Electronic Technology | 2026-09-10 | 0.104100000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Consumer Services | 2026-09-10 | 0.068200000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Consumer Non-Durables | 2026-09-10 | 0.053600000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Consumer Discretionary | 2026-09-10 | 0.194300000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Consumer Defensive | 2026-09-10 | 0.051500000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Consumer Cyclical | 2026-09-10 | 0.149100000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Communications | 2026-09-10 | 0.006758600000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Communication Services | 2026-09-10 | 0.021600000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Commercial Services | 2026-09-10 | 0.047500000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Cash | 2026-09-10 | 0.001062100000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Basic Materials | 2026-09-10 | 0.008133400000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | country | United States | 2026-09-10 | 1.000000000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | country | Other | 2026-09-10 | 0.000000000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-10 16:30 | 2026-09-10 16:30 |
| DIA | sector | Utilities | 2026-09-09 | 0.000000000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| DIA | sector | Technology Services | 2026-09-09 | 0.161000000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| DIA | sector | Technology | 2026-09-09 | 0.188400000000 | uw_etf_weights | /api/etfs/DIA/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 |
| DIA | sector | Real Estate | 2026-09-09 | 0.000000000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| DIA | sector | Producer Manufacturing | 2026-09-09 | 0.072500000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| DIA | sector | Process Industries | 2026-09-09 | 0.009624200000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| DIA | sector | Other | 2026-09-09 | 0.001555737330 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| DIA | sector | Materials | 2026-09-09 | 0.008771900000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| DIA | sector | Information Technology | 2026-09-09 | 0.187200000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| DIA | sector | Industrials | 2026-09-09 | 0.133900000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |
| DIA | sector | Healthcare | 2026-09-09 | 0.188900000000 | uw_etf_weights | /api/etfs/DIA/weights | {} | 2026-09-09 16:30 | 2026-09-09 16:30 |