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
XLYsectorConsumer Defensive2026-09-180.000000000000uw_etf_weights/api/etfs/XLY/weights{}2026-09-18 16:302026-09-18 16:30
XLVsectorConsumer Defensive2026-09-180.000000000000uw_etf_weights/api/etfs/XLV/weights{}2026-09-18 16:302026-09-18 16:30
XLUsectorConsumer Defensive2026-09-180.000000000000uw_etf_weights/api/etfs/XLU/weights{}2026-09-18 16:302026-09-18 16:30
XLPsectorConsumer Defensive2026-09-180.997400000000uw_etf_weights/api/etfs/XLP/weights{}2026-09-18 16:302026-09-18 16:30
XLKsectorConsumer Defensive2026-09-180.000000000000uw_etf_weights/api/etfs/XLK/weights{}2026-09-18 16:302026-09-18 16:30
XLIsectorConsumer Defensive2026-09-180.000000000000uw_etf_weights/api/etfs/XLI/weights{}2026-09-18 16:302026-09-18 16:30
XLFsectorConsumer Defensive2026-09-180.000000000000uw_etf_weights/api/etfs/XLF/weights{}2026-09-18 16:302026-09-18 16:30
XLEsectorConsumer Defensive2026-09-180.000000000000uw_etf_weights/api/etfs/XLE/weights{}2026-09-18 16:302026-09-18 16:30
SPYsectorConsumer Defensive2026-09-180.059400000000uw_etf_weights/api/etfs/SPY/weights{}2026-09-18 16:302026-09-18 16:30
SMHsectorConsumer Defensive2026-09-180.000000000000uw_etf_weights/api/etfs/SMH/weights{}2026-09-18 16:302026-09-18 16:30
QQQsectorConsumer Defensive2026-09-180.063900000000uw_etf_weights/api/etfs/QQQ/weights{}2026-09-18 16:302026-09-18 16:30
DIAsectorConsumer Defensive2026-09-180.051500000000uw_etf_weights/api/etfs/DIA/weights{}2026-09-18 16:302026-09-18 16:30
XLYsectorConsumer Defensive2026-09-170.000000000000uw_etf_weights/api/etfs/XLY/weights{}2026-09-17 16:302026-09-17 16:30
XLVsectorConsumer Defensive2026-09-170.000000000000uw_etf_weights/api/etfs/XLV/weights{}2026-09-17 16:302026-09-17 16:30
XLUsectorConsumer Defensive2026-09-170.000000000000uw_etf_weights/api/etfs/XLU/weights{}2026-09-17 16:302026-09-17 16:30
XLPsectorConsumer Defensive2026-09-170.997400000000uw_etf_weights/api/etfs/XLP/weights{}2026-09-17 16:302026-09-17 16:30
XLKsectorConsumer Defensive2026-09-170.000000000000uw_etf_weights/api/etfs/XLK/weights{}2026-09-17 16:302026-09-17 16:30
XLIsectorConsumer Defensive2026-09-170.000000000000uw_etf_weights/api/etfs/XLI/weights{}2026-09-17 16:302026-09-17 16:30
XLFsectorConsumer Defensive2026-09-170.000000000000uw_etf_weights/api/etfs/XLF/weights{}2026-09-17 16:302026-09-17 16:30
XLEsectorConsumer Defensive2026-09-170.000000000000uw_etf_weights/api/etfs/XLE/weights{}2026-09-17 16:302026-09-17 16:30
SPYsectorConsumer Defensive2026-09-170.059400000000uw_etf_weights/api/etfs/SPY/weights{}2026-09-17 16:302026-09-17 16:30
SMHsectorConsumer Defensive2026-09-170.000000000000uw_etf_weights/api/etfs/SMH/weights{}2026-09-17 16:302026-09-17 16:30
QQQsectorConsumer Defensive2026-09-170.063900000000uw_etf_weights/api/etfs/QQQ/weights{}2026-09-17 16:302026-09-17 16:30
DIAsectorConsumer Defensive2026-09-170.051500000000uw_etf_weights/api/etfs/DIA/weights{}2026-09-17 16:302026-09-17 16:30
XLYsectorConsumer Defensive2026-09-160.000000000000uw_etf_weights/api/etfs/XLY/weights{}2026-09-16 16:302026-09-16 16:30
XLVsectorConsumer Defensive2026-09-160.000000000000uw_etf_weights/api/etfs/XLV/weights{}2026-09-16 16:302026-09-16 16:30
XLUsectorConsumer Defensive2026-09-160.000000000000uw_etf_weights/api/etfs/XLU/weights{}2026-09-16 16:302026-09-16 16:30
XLPsectorConsumer Defensive2026-09-160.997400000000uw_etf_weights/api/etfs/XLP/weights{}2026-09-16 16:302026-09-16 16:30
XLKsectorConsumer Defensive2026-09-160.000000000000uw_etf_weights/api/etfs/XLK/weights{}2026-09-16 16:302026-09-16 16:30
XLIsectorConsumer Defensive2026-09-160.000000000000uw_etf_weights/api/etfs/XLI/weights{}2026-09-16 16:302026-09-16 16:30
XLFsectorConsumer Defensive2026-09-160.000000000000uw_etf_weights/api/etfs/XLF/weights{}2026-09-16 16:302026-09-16 16:30
XLEsectorConsumer Defensive2026-09-160.000000000000uw_etf_weights/api/etfs/XLE/weights{}2026-09-16 16:302026-09-16 16:30
SPYsectorConsumer Defensive2026-09-160.059400000000uw_etf_weights/api/etfs/SPY/weights{}2026-09-16 16:302026-09-16 16:30
SMHsectorConsumer Defensive2026-09-160.000000000000uw_etf_weights/api/etfs/SMH/weights{}2026-09-16 16:302026-09-16 16:30
QQQsectorConsumer Defensive2026-09-160.063900000000uw_etf_weights/api/etfs/QQQ/weights{}2026-09-16 16:302026-09-16 16:30
DIAsectorConsumer Defensive2026-09-160.051500000000uw_etf_weights/api/etfs/DIA/weights{}2026-09-16 16:302026-09-16 16:30
XLYsectorConsumer Defensive2026-09-150.000000000000uw_etf_weights/api/etfs/XLY/weights{}2026-09-15 16:302026-09-15 16:30
XLVsectorConsumer Defensive2026-09-150.000000000000uw_etf_weights/api/etfs/XLV/weights{}2026-09-15 16:302026-09-15 16:30
XLUsectorConsumer Defensive2026-09-150.000000000000uw_etf_weights/api/etfs/XLU/weights{}2026-09-15 16:302026-09-15 16:30
XLPsectorConsumer Defensive2026-09-150.997400000000uw_etf_weights/api/etfs/XLP/weights{}2026-09-15 16:302026-09-15 16:30
XLKsectorConsumer Defensive2026-09-150.000000000000uw_etf_weights/api/etfs/XLK/weights{}2026-09-15 16:302026-09-15 16:30
XLIsectorConsumer Defensive2026-09-150.000000000000uw_etf_weights/api/etfs/XLI/weights{}2026-09-15 16:302026-09-15 16:30
XLFsectorConsumer Defensive2026-09-150.000000000000uw_etf_weights/api/etfs/XLF/weights{}2026-09-15 16:302026-09-15 16:30
XLEsectorConsumer Defensive2026-09-150.000000000000uw_etf_weights/api/etfs/XLE/weights{}2026-09-15 16:302026-09-15 16:30
SPYsectorConsumer Defensive2026-09-150.059400000000uw_etf_weights/api/etfs/SPY/weights{}2026-09-15 16:302026-09-15 16:30
SMHsectorConsumer Defensive2026-09-150.000000000000uw_etf_weights/api/etfs/SMH/weights{}2026-09-15 16:302026-09-15 16:30
QQQsectorConsumer Defensive2026-09-150.063900000000uw_etf_weights/api/etfs/QQQ/weights{}2026-09-15 16:302026-09-15 16:30
DIAsectorConsumer Defensive2026-09-150.051500000000uw_etf_weights/api/etfs/DIA/weights{}2026-09-15 16:302026-09-15 16:30
XLYsectorConsumer Defensive2026-09-140.000000000000uw_etf_weights/api/etfs/XLY/weights{}2026-09-14 16:302026-09-14 16:30
XLVsectorConsumer Defensive2026-09-140.000000000000uw_etf_weights/api/etfs/XLV/weights{}2026-09-14 16:302026-09-14 16:30