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 100 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
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
QQQWMT2026-09-032.329445104961226.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WMT
QQQPEP2026-09-030.84095829407460.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PEP
QQQMNST2026-09-030.37888142085747.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MNST
QQQMDLZ2026-09-030.34664627620927.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MDLZ
QQQKHC2026-09-030.13247125516267.00Consumer DefensiveUNITED STATESUSNorth AmericaKRAFT HEINZstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KHC
QQQKDP2026-09-030.19659029275435.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KDP
QQQCOST2026-09-031.8041909546005.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27COST
QQQCCEP2026-09-030.2138719594045.00Consumer DefensiveUNITED KINGDOMGBEuropeCOCA-COLA EUROPACIFIC PARTNERSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CCEP
IWMWMK2026-09-050.030000323097.00Consumer DefensiveUNITED STATESUSNorth AmericaWEIS MARKETSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WMK
IWMUVV2026-09-050.040000659147.00Consumer DefensiveUNITED STATESUSNorth AmericaUNIVERSALstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UVV
IWMUTZ2026-09-050.0300001896162.00Consumer DefensiveUNITED STATESUSNorth AmericaUTZ BRANDSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UTZ
IWMUTI2026-09-050.0300001231306.00Consumer DefensiveUNITED STATESUSNorth AmericaUNIVERSAL TECHNICAL INSTITUTEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UTI
IWMUNFI2026-09-050.0900001567269.00Consumer DefensiveUNITED STATESUSNorth AmericaUNITED NATURAL FOODSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UNFI
IWMTPB2026-09-050.050000489733.00Consumer DefensiveUNITED STATESUSNorth AmericaTURNING POINT BRANDSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TPB
IWMSTRA2026-09-050.060000582724.00Consumer DefensiveUNITED STATESUSNorth AmericaSTRATEGIC EDUCATIONstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27STRA
IWMSPB2026-09-050.070000594501.00Consumer DefensiveUNITED STATESUSNorth AmericaSPECTRUM BRANDS HOLDINGSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SPB
IWMSMPL2026-09-050.0300002152633.00Consumer DefensiveUNITED STATESUSNorth AmericaSIMPLY GOOD FOODSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SMPL
IWMSENEA2026-09-050.030000118032.00Consumer DefensiveUNITED STATESUSNorth AmericaSENECA FOODSstockfalse——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SENEA
IWMSAM2026-09-050.040000199144.00Consumer DefensiveUNITED STATESUSNorth AmericaBOSTON BEER COstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SAM
IWMPSMT2026-09-050.150000675576.00Consumer DefensiveUNITED STATESUSNorth AmericaPRICESMARTstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PSMT
IWMPRDO2026-09-050.0600001566138.00Consumer DefensiveUNITED STATESUSNorth AmericaPERDOCEO EDUCATIONstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PRDO
IWMNWL2026-09-050.08000011016421.00Consumer DefensiveUNITED STATESUSNorth AmericaNEWELL BRANDSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NWL
IWMMZTI2026-09-050.070000513586.00Consumer Defensive———The Marzetti Companystocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MZTI
IWMLRN2026-09-050.1200001086889.00Consumer DefensiveUNITED STATESUSNorth AmericaSTRIDEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LRN
IWMLAUR2026-09-050.1400003149487.00Consumer DefensiveUNITED STATESUSNorth AmericaLAUREATE EDUCATIONstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LAUR
IWMJJSF2026-09-050.040000394159.00Consumer DefensiveUNITED STATESUSNorth AmericaJ&J SNACK FOODSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27JJSF
IWMIPAR2026-09-050.070000476686.00Consumer DefensiveUNITED STATESUSNorth AmericaINTER PARFUMSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IPAR
IWMIMKTA2026-09-050.040000383495.00Consumer DefensiveUNITED STATESUSNorth AmericaINGLES MARKETSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IMKTA
IWMHLF2026-09-050.0400002662628.00Consumer DefensiveCAYMAN ISLANDSKYNorth AmericaHERBALIFEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HLF
IWMHIMS2026-09-050.1900005532998.00Consumer DefensiveUNITED STATESUSNorth AmericaHIMS & HERS HEALTHstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HIMS
IWMGO2026-09-050.0400002420804.00Consumer DefensiveUNITED STATESUSNorth AmericaGROCERY OUTLET HOLDINGstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GO
IWMGHC2026-09-050.12000082687.00Consumer DefensiveUNITED STATESUSNorth AmericaGRAHAM HOLDINGSstockfalse——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GHC