Simplify Analytics
← Data Explorer

ETF holdings

core.etf_holdings

Class E accrual. Cash rows are sentinel-tickered; see the ck_etf_holdings_cash_is_sentinel constraint.

16,657 rowsCSV — whole table, not this view

Sources in this table

as_ofto
column equals (exact text)
sort
chart against as_of
reset
active:sector = Consumer Defensive×sorted by as_of ↑×

as_of leads no index, so this sort reads every matching row and keeps only the top 50 in a heap (the page LIMIT), under a 5s statement timeout.

etftexttickertextvintage_datedateweightnumericsharesnumericsectortextcountry_nametextcountry_codetextcontinenttextshort_nametextsecurity_typetexthas_optionsbooleancusiptextisintextsourcetextendpointtextrequest_paramsjsonbas_of ↑datevintage_tstimestamp with time zoneretrieved_attimestamp with time zonevendor_tickertext
XLPWMT2026-06-3010.78675212999430.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WMT
XLPTSN2026-06-301.0467032495504.00Consumer DefensiveUNITED STATESUSNorth AmericaTYSON FOODSstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TSN
XLPTGT2026-06-303.8442734017427.00Consumer DefensiveUNITED STATESUSNorth AmericaTARGETstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TGT
XLPTAP2026-06-300.4050661419113.00Consumer DefensiveUNITED STATESUSNorth AmericaMOLSON COORS BEVERAGEstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TAP
XLPSYY2026-06-302.5900584229776.00Consumer DefensiveUNITED STATESUSNorth AmericaSYSCOstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SYY
XLPSTZ2026-06-301.2570701233598.00Consumer DefensiveUNITED STATESUSNorth AmericaCONSTELLATION BRANDSstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27STZ
XLPSJM2026-06-300.777537943363.00Consumer DefensiveUNITED STATESUSNorth AmericaJ M SMUCKERstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SJM
XLPPM2026-06-306.1252604621385.00Consumer DefensiveUNITED STATESUSNorth AmericaPHILIP MORRIS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PM
XLPPG2026-06-307.4179766904673.00Consumer DefensiveUNITED STATESUSNorth AmericaPROCTER & GAMBLEstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PG
XLPPEP2026-06-304.3169434351789.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PEP
XLPMO2026-06-304.5270988588142.00Consumer DefensiveUNITED STATESUSNorth AmericaALTRIA stocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MO
XLPMNST2026-06-304.4472636315230.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MNST
XLPMKC2026-06-300.8299082246660.00Consumer DefensiveUNITED STATESUSNorth AmericaMCCORMICK & COstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MKC
XLPMDLZ2026-06-304.1468019785771.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MDLZ
XLPKVUE2026-06-302.37781316983502.00Consumer Defensive———KENVUEstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KVUE
XLPKR2026-06-302.0412905017498.00Consumer DefensiveUNITED STATESUSNorth AmericaKROGERstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KR
XLPKO2026-06-306.83645111481817.00Consumer DefensiveUNITED STATESUSNorth AmericaCOCA COLAstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KO
XLPKMB2026-06-302.3613262936179.00Consumer DefensiveUNITED STATESUSNorth AmericaKIMBERLY CLARKstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KMB
XLPKHC2026-06-301.3068607551955.00Consumer DefensiveUNITED STATESUSNorth AmericaKRAFT HEINZstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KHC
XLPKDP2026-06-302.88587012034858.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KDP
XLPHSY2026-06-301.6854121311182.00Consumer DefensiveUNITED STATESUSNorth AmericaHERSHEYstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HSY
XLPHRL2026-06-300.4691142579804.00Consumer DefensiveUNITED STATESUSNorth AmericaHORMEL FOODSstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HRL
XLPGIS2026-06-301.2035814720697.00Consumer DefensiveUNITED STATESUSNorth AmericaGENERAL MILLSstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GIS
XLPEL2026-06-301.2652332187402.00Consumer DefensiveUNITED STATESUSNorth AmericaESTEE LAUDERstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EL
XLPDLTR2026-06-301.4194651601876.00Consumer DefensiveUNITED STATESUSNorth AmericaDOLLAR TREEstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DLTR
XLPDG2026-06-301.6428471948024.00Consumer DefensiveUNITED STATESUSNorth AmericaDOLLAR GENERALstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DG
XLPCOST2026-06-309.0159511315503.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27COST
XLPCLX2026-06-300.7479031069609.00Consumer DefensiveUNITED STATESUSNorth AmericaCLOROXstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CLX
XLPCL2026-06-304.6898406982221.00Consumer DefensiveUNITED STATESUSNorth AmericaCOLGATE PALMOLIVEstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CL
XLPCHD2026-06-301.4876202095888.00Consumer DefensiveUNITED STATESUSNorth AmericaCHURCH & DWIGHT COstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CHD
XLPCASY2026-06-301.903606326915.00Consumer DefensiveUNITED STATESUSNorth AmericaCASEYS GENERAL STORESstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CASY
XLPBG2026-06-300.9393761201332.00Consumer DefensiveUNITED STATESUSNorth AmericaBUNGEstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BG
XLPBFB2026-06-300.2907551489155.00Consumer Defensive———Brown-Forman BF-Bstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BFB
XLPADM2026-06-302.3862464263164.00Consumer DefensiveUNITED STATESUSNorth AmericaARCHER-DANIELS-MIDLANDstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ADM
SPYWMT2026-09-030.71176053501027.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WMT
SPYTSN2026-09-030.0218933447101.00Consumer DefensiveUNITED STATESUSNorth AmericaTYSON FOODSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TSN
SPYTGT2026-09-030.1114775539250.00Consumer DefensiveUNITED STATESUSNorth AmericaTARGETstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TGT
SPYTAP2026-09-030.0097581960198.00Consumer DefensiveUNITED STATESUSNorth AmericaMOLSON COORS BEVERAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TAP
SPYSYY2026-09-030.0581265842475.00Consumer DefensiveUNITED STATESUSNorth AmericaSYSCOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SYY
SPYSTZ2026-09-030.0269931704075.00Consumer DefensiveUNITED STATESUSNorth AmericaCONSTELLATION BRANDSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27STZ
SPYSJM2026-09-030.0205511303249.00Consumer DefensiveUNITED STATESUSNorth AmericaJ M SMUCKERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SJM
SPYPM2026-09-030.43441219016452.00Consumer DefensiveUNITED STATESUSNorth AmericaPHILIP MORRIS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PM
SPYPG2026-09-030.51219628411407.00Consumer DefensiveUNITED STATESUSNorth AmericaPROCTER & GAMBLEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PG
SPYPEP2026-09-030.28352116678126.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PEP
SPYMO2026-09-030.17359720359018.00Consumer DefensiveUNITED STATESUSNorth AmericaALTRIA stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MO
SPYMNST2026-09-030.09431617437377.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MNST
SPYMKC2026-09-030.0200833112771.00Consumer DefensiveUNITED STATESUSNorth AmericaMCCORMICK & COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MKC
SPYMDLZ2026-09-030.11795515643444.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MDLZ
SPYKVUE2026-09-030.05455023459638.00Consumer Defensive———KENVUEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KVUE
SPYKR2026-09-030.0497626931082.00Consumer DefensiveUNITED STATESUSNorth AmericaKROGERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KR