Simplify Analytics
← Data Explorer

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

as_ofto
column equals (exact text)
sort
chart against as_of
reset
active:label = Consumer Defensive×source = uw_etf_weights×
etftextdimensiontextlabeltextas_of ↓dateweight_fractionnumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
XLKsectorConsumer Defensive2026-09-080.000000000000uw_etf_weights/api/etfs/XLK/weights{}2026-09-08 08:572026-09-08 08:57
XLIsectorConsumer Defensive2026-09-080.000000000000uw_etf_weights/api/etfs/XLI/weights{}2026-09-08 08:572026-09-08 08:57
XLFsectorConsumer Defensive2026-09-080.000000000000uw_etf_weights/api/etfs/XLF/weights{}2026-09-08 08:572026-09-08 08:57
XLEsectorConsumer Defensive2026-09-080.000000000000uw_etf_weights/api/etfs/XLE/weights{}2026-09-08 08:572026-09-08 08:57
SPYsectorConsumer Defensive2026-09-080.059400000000uw_etf_weights/api/etfs/SPY/weights{}2026-09-08 08:572026-09-08 08:57
SMHsectorConsumer Defensive2026-09-080.000000000000uw_etf_weights/api/etfs/SMH/weights{}2026-09-08 08:572026-09-08 08:57
QQQsectorConsumer Defensive2026-09-080.063900000000uw_etf_weights/api/etfs/QQQ/weights{}2026-09-08 08:572026-09-08 08:57
DIAsectorConsumer Defensive2026-09-080.051500000000uw_etf_weights/api/etfs/DIA/weights{}2026-09-08 08:572026-09-08 08:57