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:country_code = US×sector = Consumer Defensive×

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-160.72355952371617.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WMT
SPYTSN2026-09-160.0226043374566.00Consumer DefensiveUNITED STATESUSNorth AmericaTYSON FOODSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TSN
SPYTGT2026-09-160.1077905422215.00Consumer DefensiveUNITED STATESUSNorth AmericaTARGETstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TGT
SPYTAP2026-09-160.0096451918813.00Consumer DefensiveUNITED STATESUSNorth AmericaMOLSON COORS BEVERAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TAP
SPYSYY2026-09-160.0578545719210.00Consumer DefensiveUNITED STATESUSNorth AmericaSYSCOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SYY
SPYSTZ2026-09-160.0263751668030.00Consumer DefensiveUNITED STATESUSNorth AmericaCONSTELLATION BRANDSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30STZ
SPYSJM2026-09-160.0202571275659.00Consumer DefensiveUNITED STATESUSNorth AmericaJ M SMUCKERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SJM
SPYPM2026-09-160.45864718615062.00Consumer DefensiveUNITED STATESUSNorth AmericaPHILIP MORRIS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PM
SPYPG2026-09-160.52549827811547.00Consumer DefensiveUNITED STATESUSNorth AmericaPROCTER & GAMBLEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PG
SPYPEP2026-09-160.28187616326131.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PEP
SPYMO2026-09-160.17954219928703.00Consumer DefensiveUNITED STATESUSNorth AmericaALTRIA stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MO
SPYMNST2026-09-160.09777517069362.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MNST
SPYMKC2026-09-160.0196063047356.00Consumer DefensiveUNITED STATESUSNorth AmericaMCCORMICK & COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MKC
SPYMDLZ2026-09-160.12272415312809.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MDLZ
SPYKR2026-09-160.0533156785122.00Consumer DefensiveUNITED STATESUSNorth AmericaKROGERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KR
SPYKO2026-09-160.52228246248237.00Consumer DefensiveUNITED STATESUSNorth AmericaCOCA COLAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KO
SPYKMB2026-09-160.0500533969992.00Consumer DefensiveUNITED STATESUSNorth AmericaKIMBERLY CLARKstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KMB
SPYKHC2026-09-160.03256010244515.00Consumer DefensiveUNITED STATESUSNorth AmericaKRAFT HEINZstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KHC
SPYKDP2026-09-160.06650716273205.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KDP
SPYHSY2026-09-160.0389851776092.00Consumer DefensiveUNITED STATESUSNorth AmericaHERSHEYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HSY
SPYHRL2026-09-160.0093163488291.00Consumer DefensiveUNITED STATESUSNorth AmericaHORMEL FOODSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HRL
SPYGIS2026-09-160.0301976382975.00Consumer DefensiveUNITED STATESUSNorth AmericaGENERAL MILLSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GIS
SPYEL2026-09-160.0362252948345.00Consumer DefensiveUNITED STATESUSNorth AmericaESTEE LAUDERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30EL
SPYDLTR2026-09-160.0312892165966.00Consumer DefensiveUNITED STATESUSNorth AmericaDOLLAR TREEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DLTR
SPYDG2026-09-160.0416912637139.00Consumer DefensiveUNITED STATESUSNorth AmericaDOLLAR GENERALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DG
SPYCOST2026-09-160.6087185299505.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30COST
SPYCLX2026-09-160.0158601454245.00Consumer DefensiveUNITED STATESUSNorth AmericaCLOROXstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CLX
SPYCL2026-09-160.1070439571231.00Consumer DefensiveUNITED STATESUSNorth AmericaCOLGATE PALMOLIVEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CL
SPYCHD2026-09-160.0346972826649.00Consumer DefensiveUNITED STATESUSNorth AmericaCHURCH & DWIGHT COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CHD
SPYCASY2026-09-160.033525442880.00Consumer DefensiveUNITED STATESUSNorth AmericaCASEYS GENERAL STORESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CASY
SPYBG2026-09-160.0245291629432.00Consumer DefensiveUNITED STATESUSNorth AmericaBUNGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BG
SPYADM2026-09-160.0629685764079.00Consumer DefensiveUNITED STATESUSNorth AmericaARCHER-DANIELS-MIDLANDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ADM
QQQWMT2026-09-162.349840103901495.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WMT
QQQPEP2026-09-160.83182629111124.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PEP
QQQMNST2026-09-160.39065041661660.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MNST
QQQMDLZ2026-09-160.35869427340753.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MDLZ
QQQKDP2026-09-160.19361528940301.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KDP
QQQCOST2026-09-161.7767499449456.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30COST
IWMWMK2026-09-180.030000325693.00Consumer DefensiveUNITED STATESUSNorth AmericaWEIS MARKETSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WMK
IWMUVV2026-09-180.040000664471.00Consumer DefensiveUNITED STATESUSNorth AmericaUNIVERSALstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UVV
IWMUTZ2026-09-180.0400001911518.00Consumer DefensiveUNITED STATESUSNorth AmericaUTZ BRANDSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UTZ
IWMUTI2026-09-180.0300001241250.00Consumer DefensiveUNITED STATESUSNorth AmericaUNIVERSAL TECHNICAL INSTITUTEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UTI
IWMUNFI2026-09-180.0900001579941.00Consumer DefensiveUNITED STATESUSNorth AmericaUNITED NATURAL FOODSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UNFI
IWMTPB2026-09-180.040000493693.00Consumer DefensiveUNITED STATESUSNorth AmericaTURNING POINT BRANDSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TPB
IWMSTRA2026-09-180.060000587432.00Consumer DefensiveUNITED STATESUSNorth AmericaSTRATEGIC EDUCATIONstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30STRA
IWMSPB2026-09-180.070000599297.00Consumer DefensiveUNITED STATESUSNorth AmericaSPECTRUM BRANDS HOLDINGSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SPB
IWMSMPL2026-09-180.0300002170057.00Consumer DefensiveUNITED STATESUSNorth AmericaSIMPLY GOOD FOODSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SMPL
IWMSENEA2026-09-180.030000119000.00Consumer DefensiveUNITED STATESUSNorth AmericaSENECA FOODSstockfalse——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SENEA
IWMSAM2026-09-180.040000200772.00Consumer DefensiveUNITED STATESUSNorth AmericaBOSTON BEER COstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SAM
IWMPSMT2026-09-180.150000681032.00Consumer DefensiveUNITED STATESUSNorth AmericaPRICESMARTstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PSMT