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×
etftextdimensiontextlabeltextas_of ↓dateweight_fractionnumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
XLUsectorConsumer Defensive2026-09-140.000000000000uw_etf_weights/api/etfs/XLU/weights{}2026-09-14 16:302026-09-14 16:30
XLPsectorConsumer Defensive2026-09-140.997400000000uw_etf_weights/api/etfs/XLP/weights{}2026-09-14 16:302026-09-14 16:30
XLKsectorConsumer Defensive2026-09-140.000000000000uw_etf_weights/api/etfs/XLK/weights{}2026-09-14 16:302026-09-14 16:30
XLIsectorConsumer Defensive2026-09-140.000000000000uw_etf_weights/api/etfs/XLI/weights{}2026-09-14 16:302026-09-14 16:30
XLFsectorConsumer Defensive2026-09-140.000000000000uw_etf_weights/api/etfs/XLF/weights{}2026-09-14 16:302026-09-14 16:30
XLEsectorConsumer Defensive2026-09-140.000000000000uw_etf_weights/api/etfs/XLE/weights{}2026-09-14 16:302026-09-14 16:30
SPYsectorConsumer Defensive2026-09-140.059400000000uw_etf_weights/api/etfs/SPY/weights{}2026-09-14 16:302026-09-14 16:30
SMHsectorConsumer Defensive2026-09-140.000000000000uw_etf_weights/api/etfs/SMH/weights{}2026-09-14 16:302026-09-14 16:30
QQQsectorConsumer Defensive2026-09-140.063900000000uw_etf_weights/api/etfs/QQQ/weights{}2026-09-14 16:302026-09-14 16:30
DIAsectorConsumer Defensive2026-09-140.051500000000uw_etf_weights/api/etfs/DIA/weights{}2026-09-14 16:302026-09-14 16:30
XLYsectorConsumer Defensive2026-09-110.000000000000uw_etf_weights/api/etfs/XLY/weights{}2026-09-11 16:302026-09-11 16:30
XLVsectorConsumer Defensive2026-09-110.000000000000uw_etf_weights/api/etfs/XLV/weights{}2026-09-11 16:302026-09-11 16:30
XLUsectorConsumer Defensive2026-09-110.000000000000uw_etf_weights/api/etfs/XLU/weights{}2026-09-11 16:302026-09-11 16:30
XLPsectorConsumer Defensive2026-09-110.997400000000uw_etf_weights/api/etfs/XLP/weights{}2026-09-11 16:302026-09-11 16:30
XLKsectorConsumer Defensive2026-09-110.000000000000uw_etf_weights/api/etfs/XLK/weights{}2026-09-11 16:302026-09-11 16:30
XLIsectorConsumer Defensive2026-09-110.000000000000uw_etf_weights/api/etfs/XLI/weights{}2026-09-11 16:302026-09-11 16:30
XLFsectorConsumer Defensive2026-09-110.000000000000uw_etf_weights/api/etfs/XLF/weights{}2026-09-11 16:302026-09-11 16:30
XLEsectorConsumer Defensive2026-09-110.000000000000uw_etf_weights/api/etfs/XLE/weights{}2026-09-11 16:302026-09-11 16:30
SPYsectorConsumer Defensive2026-09-110.059400000000uw_etf_weights/api/etfs/SPY/weights{}2026-09-11 16:302026-09-11 16:30
SMHsectorConsumer Defensive2026-09-110.000000000000uw_etf_weights/api/etfs/SMH/weights{}2026-09-11 16:302026-09-11 16:30
QQQsectorConsumer Defensive2026-09-110.063900000000uw_etf_weights/api/etfs/QQQ/weights{}2026-09-11 16:302026-09-11 16:30
DIAsectorConsumer Defensive2026-09-110.051500000000uw_etf_weights/api/etfs/DIA/weights{}2026-09-11 16:302026-09-11 16:30
XLYsectorConsumer Defensive2026-09-100.000000000000uw_etf_weights/api/etfs/XLY/weights{}2026-09-10 16:302026-09-10 16:30
XLVsectorConsumer Defensive2026-09-100.000000000000uw_etf_weights/api/etfs/XLV/weights{}2026-09-10 16:302026-09-10 16:30
XLUsectorConsumer Defensive2026-09-100.000000000000uw_etf_weights/api/etfs/XLU/weights{}2026-09-10 16:302026-09-10 16:30
XLPsectorConsumer Defensive2026-09-100.997400000000uw_etf_weights/api/etfs/XLP/weights{}2026-09-10 16:302026-09-10 16:30
XLKsectorConsumer Defensive2026-09-100.000000000000uw_etf_weights/api/etfs/XLK/weights{}2026-09-10 16:302026-09-10 16:30
XLIsectorConsumer Defensive2026-09-100.000000000000uw_etf_weights/api/etfs/XLI/weights{}2026-09-10 16:302026-09-10 16:30
XLFsectorConsumer Defensive2026-09-100.000000000000uw_etf_weights/api/etfs/XLF/weights{}2026-09-10 16:302026-09-10 16:30
XLEsectorConsumer Defensive2026-09-100.000000000000uw_etf_weights/api/etfs/XLE/weights{}2026-09-10 16:302026-09-10 16:30
SPYsectorConsumer Defensive2026-09-100.059400000000uw_etf_weights/api/etfs/SPY/weights{}2026-09-10 16:302026-09-10 16:30
SMHsectorConsumer Defensive2026-09-100.000000000000uw_etf_weights/api/etfs/SMH/weights{}2026-09-10 16:302026-09-10 16:30
QQQsectorConsumer Defensive2026-09-100.063900000000uw_etf_weights/api/etfs/QQQ/weights{}2026-09-10 16:302026-09-10 16:30
DIAsectorConsumer Defensive2026-09-100.051500000000uw_etf_weights/api/etfs/DIA/weights{}2026-09-10 16:302026-09-10 16:30
XLYsectorConsumer Defensive2026-09-090.000000000000uw_etf_weights/api/etfs/XLY/weights{}2026-09-09 16:302026-09-09 16:30
XLVsectorConsumer Defensive2026-09-090.000000000000uw_etf_weights/api/etfs/XLV/weights{}2026-09-09 16:302026-09-09 16:30
XLUsectorConsumer Defensive2026-09-090.000000000000uw_etf_weights/api/etfs/XLU/weights{}2026-09-09 16:302026-09-09 16:30
XLPsectorConsumer Defensive2026-09-090.997400000000uw_etf_weights/api/etfs/XLP/weights{}2026-09-09 16:302026-09-09 16:30
XLKsectorConsumer Defensive2026-09-090.000000000000uw_etf_weights/api/etfs/XLK/weights{}2026-09-09 16:302026-09-09 16:30
XLIsectorConsumer Defensive2026-09-090.000000000000uw_etf_weights/api/etfs/XLI/weights{}2026-09-09 16:302026-09-09 16:30
XLFsectorConsumer Defensive2026-09-090.000000000000uw_etf_weights/api/etfs/XLF/weights{}2026-09-09 16:302026-09-09 16:30
XLEsectorConsumer Defensive2026-09-090.000000000000uw_etf_weights/api/etfs/XLE/weights{}2026-09-09 16:302026-09-09 16:30
SPYsectorConsumer Defensive2026-09-090.059400000000uw_etf_weights/api/etfs/SPY/weights{}2026-09-09 16:302026-09-09 16:30
SMHsectorConsumer Defensive2026-09-090.000000000000uw_etf_weights/api/etfs/SMH/weights{}2026-09-09 16:302026-09-09 16:30
QQQsectorConsumer Defensive2026-09-090.063900000000uw_etf_weights/api/etfs/QQQ/weights{}2026-09-09 16:302026-09-09 16:30
DIAsectorConsumer Defensive2026-09-090.051500000000uw_etf_weights/api/etfs/DIA/weights{}2026-09-09 16:302026-09-09 16:30
XLYsectorConsumer Defensive2026-09-080.000000000000uw_etf_weights/api/etfs/XLY/weights{}2026-09-08 08:572026-09-08 08:57
XLVsectorConsumer Defensive2026-09-080.000000000000uw_etf_weights/api/etfs/XLV/weights{}2026-09-08 08:572026-09-08 08:57
XLUsectorConsumer Defensive2026-09-080.000000000000uw_etf_weights/api/etfs/XLU/weights{}2026-09-08 08:572026-09-08 08:57
XLPsectorConsumer Defensive2026-09-080.997400000000uw_etf_weights/api/etfs/XLP/weights{}2026-09-08 08:572026-09-08 08:57