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 150 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
SPYBG2026-09-150.0253851639860.00Consumer DefensiveUNITED STATESUSNorth AmericaBUNGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30BG
SPYADM2026-09-150.0638765800907.00Consumer DefensiveUNITED STATESUSNorth AmericaARCHER-DANIELS-MIDLANDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30ADM
QQQWMT2026-09-152.363352103685811.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30WMT
QQQPEP2026-09-150.83916829050700.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PEP
QQQMNST2026-09-150.39127741575168.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MNST
QQQMDLZ2026-09-150.35729227283997.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MDLZ
QQQKDP2026-09-150.19177728880241.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30KDP
QQQCOST2026-09-151.7923429429828.00Consumer DefensiveUNITED STATESUSNorth AmericaCOSTCO WHOLESALEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30COST
IWMWMK2026-09-170.030000332537.00Consumer DefensiveUNITED STATESUSNorth AmericaWEIS MARKETSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30WMK
IWMUVV2026-09-170.040000678507.00Consumer DefensiveUNITED STATESUSNorth AmericaUNIVERSALstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30UVV
IWMUTZ2026-09-170.0300001952002.00Consumer DefensiveUNITED STATESUSNorth AmericaUTZ BRANDSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30UTZ
IWMUTI2026-09-170.0300001267466.00Consumer DefensiveUNITED STATESUSNorth AmericaUNIVERSAL TECHNICAL INSTITUTEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30UTI
IWMUNFI2026-09-170.0900001613349.00Consumer DefensiveUNITED STATESUSNorth AmericaUNITED NATURAL FOODSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30UNFI
IWMTPB2026-09-170.040000504133.00Consumer DefensiveUNITED STATESUSNorth AmericaTURNING POINT BRANDSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30TPB
IWMSTRA2026-09-170.060000599844.00Consumer DefensiveUNITED STATESUSNorth AmericaSTRATEGIC EDUCATIONstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30STRA
IWMSPB2026-09-170.070000611941.00Consumer DefensiveUNITED STATESUSNorth AmericaSPECTRUM BRANDS HOLDINGSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SPB
IWMSMPL2026-09-170.0300002215993.00Consumer DefensiveUNITED STATESUSNorth AmericaSIMPLY GOOD FOODSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SMPL
IWMSENEA2026-09-170.030000121552.00Consumer DefensiveUNITED STATESUSNorth AmericaSENECA FOODSstockfalse——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SENEA
IWMSAM2026-09-170.040000205064.00Consumer DefensiveUNITED STATESUSNorth AmericaBOSTON BEER COstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SAM
IWMPSMT2026-09-170.150000695416.00Consumer DefensiveUNITED STATESUSNorth AmericaPRICESMARTstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PSMT
IWMPRDO2026-09-170.0600001566138.00Consumer DefensiveUNITED STATESUSNorth AmericaPERDOCEO EDUCATIONstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PRDO
IWMNWL2026-09-170.08000011340421.00Consumer DefensiveUNITED STATESUSNorth AmericaNEWELL BRANDSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30NWL
IWMLRN2026-09-170.1200001118889.00Consumer DefensiveUNITED STATESUSNorth AmericaSTRIDEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30LRN
IWMLAUR2026-09-170.1500003242127.00Consumer DefensiveUNITED STATESUSNorth AmericaLAUREATE EDUCATIONstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30LAUR
IWMJJSF2026-09-170.040000405679.00Consumer DefensiveUNITED STATESUSNorth AmericaJ&J SNACK FOODSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30JJSF
IWMIPAR2026-09-170.070000490766.00Consumer DefensiveUNITED STATESUSNorth AmericaINTER PARFUMSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30IPAR
IWMIMKTA2026-09-170.040000394855.00Consumer DefensiveUNITED STATESUSNorth AmericaINGLES MARKETSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30IMKTA
IWMHIMS2026-09-170.2000005695718.00Consumer DefensiveUNITED STATESUSNorth AmericaHIMS & HERS HEALTHstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30HIMS
IWMGO2026-09-170.0400002492004.00Consumer DefensiveUNITED STATESUSNorth AmericaGROCERY OUTLET HOLDINGstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30GO
IWMGHC2026-09-170.12000085087.00Consumer DefensiveUNITED STATESUSNorth AmericaGRAHAM HOLDINGSstockfalse——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30GHC
IWMFLO2026-09-170.0400005065202.00Consumer DefensiveUNITED STATESUSNorth AmericaFLOWERS FOODSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30FLO
IWMEPC2026-09-170.0400001256437.00Consumer DefensiveUNITED STATESUSNorth AmericaEDGEWELL PERSONAL CAREstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30EPC
IWMCOUR2026-09-170.0400005820833.00Consumer DefensiveUNITED STATESUSNorth AmericaCOURSERAstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30COUR
IWMCOTY2026-09-170.0300009397472.00Consumer DefensiveUNITED STATESUSNorth AmericaCOTYstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30COTY
IWMCOCO2026-09-170.0900001295633.00Consumer DefensiveUNITED STATESUSNorth AmericaVITA COCO COMPANYstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30COCO
IWMCHEF2026-09-170.130000983142.00Consumer DefensiveUNITED STATESUSNorth AmericaCHEFS' WAREHOUSEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CHEF
IWMCALM2026-09-170.1100001164986.00Consumer DefensiveUNITED STATESUSNorth AmericaCAL-MAINE FOODSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CALM
IWMBRBR2026-09-170.0400003135250.00Consumer DefensiveUNITED STATESUSNorth AmericaBELLRING BRANDSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30BRBR
IWMAPEI2026-09-170.030000481294.00Consumer DefensiveUNITED STATESUSNorth AmericaAMERICAN PUBLIC EDUCATIONstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30APEI
IWMANDE2026-09-170.080000892505.00Consumer DefensiveUNITED STATESUSNorth AmericaANDERSONSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30ANDE
SPYWMT2026-09-140.72778653414735.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30WMT
SPYTSN2026-09-140.0228533441559.00Consumer DefensiveUNITED STATESUSNorth AmericaTYSON FOODSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30TSN
SPYTGT2026-09-140.1096295530308.00Consumer DefensiveUNITED STATESUSNorth AmericaTARGETstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30TGT
SPYTAP2026-09-140.0095531957036.00Consumer DefensiveUNITED STATESUSNorth AmericaMOLSON COORS BEVERAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30TAP
SPYSYY2026-09-140.0608685833057.00Consumer DefensiveUNITED STATESUSNorth AmericaSYSCOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30SYY
SPYSTZ2026-09-140.0265641701321.00Consumer DefensiveUNITED STATESUSNorth AmericaCONSTELLATION BRANDSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30STZ
SPYSJM2026-09-140.0197141301141.00Consumer DefensiveUNITED STATESUSNorth AmericaJ M SMUCKERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30SJM
SPYPM2026-09-140.46211418985784.00Consumer DefensiveUNITED STATESUSNorth AmericaPHILIP MORRIS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30PM
SPYPG2026-09-140.51776028365575.00Consumer DefensiveUNITED STATESUSNorth AmericaPROCTER & GAMBLEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30PG
SPYPEP2026-09-140.28357516651232.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30PEP