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
active:etf = SPY×
| etftext | dimensiontext | labeltext | as_of ↓date | weight_fractionnumeric | sourcetext | endpointtext | request_paramsjsonb | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|
| SPY | sector | Utilities | 2026-09-18 | 0.025200000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Transportation | 2026-09-18 | 0.018000000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Technology Services | 2026-09-18 | 0.205500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Technology | 2026-09-18 | 0.326200000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Retail Trade | 2026-09-18 | 0.081500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Real Estate | 2026-09-18 | 0.023000000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Producer Manufacturing | 2026-09-18 | 0.037700000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Process Industries | 2026-09-18 | 0.018000000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Other | 2026-09-18 | 0.001639458528 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Non-Energy Minerals | 2026-09-18 | 0.005446900000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Materials | 2026-09-18 | 0.019700000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Information Technology | 2026-09-18 | 0.326200000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Industrials | 2026-09-18 | 0.077800000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Industrial Services | 2026-09-18 | 0.009329900000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Healthcare | 2026-09-18 | 0.121000000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Health Technology | 2026-09-18 | 0.096600000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Health Services | 2026-09-18 | 0.022500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Financials | 2026-09-18 | 0.124800000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Financial Services | 2026-09-18 | 0.124800000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Finance | 2026-09-18 | 0.122800000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Energy Minerals | 2026-09-18 | 0.030800000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Energy | 2026-09-18 | 0.035800000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Electronic Technology | 2026-09-18 | 0.184800000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Distribution Services | 2026-09-18 | 0.009486700000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Consumer Services | 2026-09-18 | 0.033200000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Consumer Non-Durables | 2026-09-18 | 0.043800000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Consumer Durables | 2026-09-18 | 0.019600000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Consumer Discretionary | 2026-09-18 | 0.098400000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Consumer Defensive | 2026-09-18 | 0.059400000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Consumer Cyclical | 2026-09-18 | 0.098400000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Communications | 2026-09-18 | 0.008716300000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Communication Services | 2026-09-18 | 0.088700000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Commercial Services | 2026-09-18 | 0.029200000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Cash | 2026-09-18 | 0.001191300000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Basic Materials | 2026-09-18 | 0.019700000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | country | United States | 2026-09-18 | 0.993700000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | country | United Kingdom | 2026-09-18 | 0.001000000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | country | Switzerland | 2026-09-18 | 0.003000000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | country | Singapore | 2026-09-18 | 0.000400000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | country | Other | 2026-09-18 | 0.000500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | country | Netherlands | 2026-09-18 | 0.001400000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | country | Israel | 2026-09-18 | 0.000100000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | country | Ireland | 2026-09-18 | 0.000400000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | country | Canada | 2026-09-18 | 0.000900000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | country | Bermuda | 2026-09-18 | 0.001200000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-18 16:30 | 2026-09-18 16:30 |
| SPY | sector | Utilities | 2026-09-17 | 0.025200000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| SPY | sector | Transportation | 2026-09-17 | 0.018000000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| SPY | sector | Technology Services | 2026-09-17 | 0.205500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| SPY | sector | Technology | 2026-09-17 | 0.326200000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |
| SPY | sector | Retail Trade | 2026-09-17 | 0.081500000000 | uw_etf_weights | /api/etfs/SPY/weights | {} | 2026-09-17 16:30 | 2026-09-17 16:30 |