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:etf = SPY×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
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
SPYKO2026-09-030.51485947245927.00Consumer DefensiveUNITED STATESUSNorth AmericaCOCA COLAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KO
SPYKMB2026-09-030.0530814055432.00Consumer DefensiveUNITED STATESUSNorth AmericaKIMBERLY CLARKstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KMB
SPYKHC2026-09-030.03212610464345.00Consumer DefensiveUNITED STATESUSNorth AmericaKRAFT HEINZstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KHC
SPYKDP2026-09-030.06707016623865.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KDP
SPYHSY2026-09-030.0389741814362.00Consumer DefensiveUNITED STATESUSNorth AmericaHERSHEYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HSY
SPYHRL2026-09-030.0094803563496.00Consumer DefensiveUNITED STATESUSNorth AmericaHORMEL FOODSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HRL
SPYGIS2026-09-030.0314126520480.00Consumer DefensiveUNITED STATESUSNorth AmericaGENERAL MILLSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GIS
SPYEL2026-09-030.0372763011980.00Consumer DefensiveUNITED STATESUSNorth AmericaESTEE LAUDERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EL
SPYDLTR2026-09-030.0355782212691.00Consumer DefensiveUNITED STATESUSNorth AmericaDOLLAR TREEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DLTR
SPYDG2026-09-030.0433922694099.00Consumer DefensiveUNITED STATESUSNorth AmericaDOLLAR GENERALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DG
SPYCOST2026-09-030.6147585413870.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27COST
SPYCLX2026-09-030.0171861485395.00Consumer DefensiveUNITED STATESUSNorth AmericaCLOROXstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CLX
SPYCL2026-09-030.1080839777266.00Consumer DefensiveUNITED STATESUSNorth AmericaCOLGATE PALMOLIVEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CL
SPYCHD2026-09-030.0349332887614.00Consumer DefensiveUNITED STATESUSNorth AmericaCHURCH & DWIGHT COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CHD
SPYCASY2026-09-030.042085452225.00Consumer DefensiveUNITED STATESUSNorth AmericaCASEYS GENERAL STORESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CASY
SPYBG2026-09-030.0245351664587.00Consumer DefensiveUNITED STATESUSNorth AmericaBUNGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BG
SPYBFB2026-09-030.0069452057515.00Consumer Defensive———Brown-Forman BF-Bstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BFB
SPYADM2026-09-030.0609665888234.00Consumer DefensiveUNITED STATESUSNorth AmericaARCHER-DANIELS-MIDLANDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ADM
SPYWMT2026-09-040.70589953422349.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30WMT
SPYTSN2026-09-040.0218283442048.00Consumer DefensiveUNITED STATESUSNorth AmericaTYSON FOODSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30TSN
SPYTGT2026-09-040.1121735531097.00Consumer DefensiveUNITED STATESUSNorth AmericaTARGETstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30TGT
SPYTAP2026-09-040.0097761957315.00Consumer DefensiveUNITED STATESUSNorth AmericaMOLSON COORS BEVERAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30TAP
SPYSYY2026-09-040.0575955833888.00Consumer DefensiveUNITED STATESUSNorth AmericaSYSCOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30SYY
SPYSTZ2026-09-040.0268991701564.00Consumer DefensiveUNITED STATESUSNorth AmericaCONSTELLATION BRANDSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30STZ
SPYSJM2026-09-040.0202351301327.00Consumer DefensiveUNITED STATESUSNorth AmericaJ M SMUCKERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30SJM
SPYPM2026-09-040.42745718988490.00Consumer DefensiveUNITED STATESUSNorth AmericaPHILIP MORRIS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30PM
SPYPG2026-09-040.51236728369619.00Consumer DefensiveUNITED STATESUSNorth AmericaPROCTER & GAMBLEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30PG
SPYPEP2026-09-040.28267616653605.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30PEP
SPYMO2026-09-040.17269420329041.00Consumer DefensiveUNITED STATESUSNorth AmericaALTRIA stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30MO
SPYMNST2026-09-040.09409817411740.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30MNST
SPYMKC2026-09-040.0199643108214.00Consumer DefensiveUNITED STATESUSNorth AmericaMCCORMICK & COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30MKC
SPYMDLZ2026-09-040.11805415620411.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30MDLZ
SPYKVUE2026-09-040.05414023425166.00Consumer Defensive———KENVUEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30KVUE
SPYKR2026-09-040.0500106920914.00Consumer DefensiveUNITED STATESUSNorth AmericaKROGERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30KR