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 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
IWMPRDO2026-09-180.0700001566138.00Consumer DefensiveUNITED STATESUSNorth AmericaPERDOCEO EDUCATIONstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PRDO
IWMNWL2026-09-180.08000011105521.00Consumer DefensiveUNITED STATESUSNorth AmericaNEWELL BRANDSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NWL
IWMLRN2026-09-180.1200001095689.00Consumer DefensiveUNITED STATESUSNorth AmericaSTRIDEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LRN
IWMLAUR2026-09-180.1500003174963.00Consumer DefensiveUNITED STATESUSNorth AmericaLAUREATE EDUCATIONstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LAUR
IWMJJSF2026-09-180.040000397327.00Consumer DefensiveUNITED STATESUSNorth AmericaJ&J SNACK FOODSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30JJSF
IWMIPAR2026-09-180.070000480558.00Consumer DefensiveUNITED STATESUSNorth AmericaINTER PARFUMSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30IPAR
IWMIMKTA2026-09-180.040000386619.00Consumer DefensiveUNITED STATESUSNorth AmericaINGLES MARKETSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30IMKTA
IWMHIMS2026-09-180.2000005577746.00Consumer DefensiveUNITED STATESUSNorth AmericaHIMS & HERS HEALTHstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HIMS
IWMGO2026-09-180.0400002440384.00Consumer DefensiveUNITED STATESUSNorth AmericaGROCERY OUTLET HOLDINGstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GO
IWMGHC2026-09-180.12000083347.00Consumer DefensiveUNITED STATESUSNorth AmericaGRAHAM HOLDINGSstockfalse——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GHC
IWMFLO2026-09-180.0400004960222.00Consumer DefensiveUNITED STATESUSNorth AmericaFLOWERS FOODSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FLO
IWMEPC2026-09-180.0400001230453.00Consumer DefensiveUNITED STATESUSNorth AmericaEDGEWELL PERSONAL CAREstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30EPC
IWMCOUR2026-09-180.0400005700193.00Consumer DefensiveUNITED STATESUSNorth AmericaCOURSERAstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30COUR
IWMCOTY2026-09-180.0300009202824.00Consumer DefensiveUNITED STATESUSNorth AmericaCOTYstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30COTY
IWMCOCO2026-09-180.0900001268837.00Consumer DefensiveUNITED STATESUSNorth AmericaVITA COCO COMPANYstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30COCO
IWMCHEF2026-09-180.140000962726.00Consumer DefensiveUNITED STATESUSNorth AmericaCHEFS' WAREHOUSEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CHEF
IWMCALM2026-09-180.1100001140858.00Consumer DefensiveUNITED STATESUSNorth AmericaCAL-MAINE FOODSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CALM
IWMBRBR2026-09-180.0400003070290.00Consumer DefensiveUNITED STATESUSNorth AmericaBELLRING BRANDSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BRBR
IWMAPEI2026-09-180.030000471318.00Consumer DefensiveUNITED STATESUSNorth AmericaAMERICAN PUBLIC EDUCATIONstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30APEI
IWMANDE2026-09-180.080000874061.00Consumer DefensiveUNITED STATESUSNorth AmericaANDERSONSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ANDE
SPYWMT2026-09-150.72431052706633.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30WMT
SPYTSN2026-09-150.0226893396082.00Consumer DefensiveUNITED STATESUSNorth AmericaTYSON FOODSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30TSN
SPYTGT2026-09-150.1071205456931.00Consumer DefensiveUNITED STATESUSNorth AmericaTARGETstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30TGT
SPYTAP2026-09-150.0096411931089.00Consumer DefensiveUNITED STATESUSNorth AmericaMOLSON COORS BEVERAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30TAP
SPYSYY2026-09-150.0582495755774.00Consumer DefensiveUNITED STATESUSNorth AmericaSYSCOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SYY
SPYSTZ2026-09-150.0263841678722.00Consumer DefensiveUNITED STATESUSNorth AmericaCONSTELLATION BRANDSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30STZ
SPYSJM2026-09-150.0198641283843.00Consumer DefensiveUNITED STATESUSNorth AmericaJ M SMUCKERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SJM
SPYPM2026-09-150.46233318734126.00Consumer DefensiveUNITED STATESUSNorth AmericaPHILIP MORRIS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PM
SPYPG2026-09-150.52192727989483.00Consumer DefensiveUNITED STATESUSNorth AmericaPROCTER & GAMBLEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PG
SPYPEP2026-09-150.28305116430543.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PEP
SPYMO2026-09-150.17801020056347.00Consumer DefensiveUNITED STATESUSNorth AmericaALTRIA stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MO
SPYMNST2026-09-150.09747417178526.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MNST
SPYMKC2026-09-150.0194403066760.00Consumer DefensiveUNITED STATESUSNorth AmericaMCCORMICK & COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MKC
SPYMDLZ2026-09-150.12167315410885.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MDLZ
SPYKR2026-09-150.0540426828418.00Consumer DefensiveUNITED STATESUSNorth AmericaKROGERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30KR
SPYKO2026-09-150.52494346544181.00Consumer DefensiveUNITED STATESUSNorth AmericaCOCA COLAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30KO
SPYKMB2026-09-150.0501233995336.00Consumer DefensiveUNITED STATESUSNorth AmericaKIMBERLY CLARKstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30KMB
SPYKHC2026-09-150.03241510309723.00Consumer DefensiveUNITED STATESUSNorth AmericaKRAFT HEINZstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30KHC
SPYKDP2026-09-150.06556716377221.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30KDP
SPYHSY2026-09-150.0387281787444.00Consumer DefensiveUNITED STATESUSNorth AmericaHERSHEYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30HSY
SPYHRL2026-09-150.0092793510599.00Consumer DefensiveUNITED STATESUSNorth AmericaHORMEL FOODSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30HRL
SPYGIS2026-09-150.0298756423763.00Consumer DefensiveUNITED STATESUSNorth AmericaGENERAL MILLSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30GIS
SPYEL2026-09-150.0363102967221.00Consumer DefensiveUNITED STATESUSNorth AmericaESTEE LAUDERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30EL
SPYDLTR2026-09-150.0312582179826.00Consumer DefensiveUNITED STATESUSNorth AmericaDOLLAR TREEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30DLTR
SPYDG2026-09-150.0420772654035.00Consumer DefensiveUNITED STATESUSNorth AmericaDOLLAR GENERALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30DG
SPYCOST2026-09-150.6111875333429.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30COST
SPYCLX2026-09-150.0162171463485.00Consumer DefensiveUNITED STATESUSNorth AmericaCLOROXstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CLX
SPYCL2026-09-150.1065439632347.00Consumer DefensiveUNITED STATESUSNorth AmericaCOLGATE PALMOLIVEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CL
SPYCHD2026-09-150.0341822844733.00Consumer DefensiveUNITED STATESUSNorth AmericaCHURCH & DWIGHT COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CHD
SPYCASY2026-09-150.033267445652.00Consumer DefensiveUNITED STATESUSNorth AmericaCASEYS GENERAL STORESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CASY