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 Cyclical×

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_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zonevendor_tickertext
SPYYUM2026-09-160.0584523296667.00Consumer CyclicalUNITED STATESUSNorth AmericaYUM BRANDSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30YUM
SPYWYNN2026-09-160.0108521002510.00Consumer CyclicalUNITED STATESUSNorth AmericaWYNN RESORTSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WYNN
SPYWSM2026-09-160.0394901408210.00Consumer CyclicalUNITED STATESUSNorth AmericaWILLIAMS SONOMAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WSM
SPYULTA2026-09-160.035518520928.00Consumer CyclicalUNITED STATESUSNorth AmericaULTA BEAUTYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ULTA
SPYTSLA2026-09-161.54792733635719.00Consumer CyclicalUNITED STATESUSNorth AmericaTESLAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TSLA
SPYTSCO2026-09-160.0264266272676.00Consumer CyclicalUNITED STATESUSNorth AmericaTRACTOR SUPPLYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TSCO
SPYTPR2026-09-160.0366882420415.00Consumer CyclicalUNITED STATESUSNorth AmericaTAPESTRYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TPR
SPYTJX2026-09-160.20851913207946.00Consumer CyclicalUNITED STATESUSNorth AmericaTJX COMPANIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TJX
SPYSW2026-09-160.0359656277294.00Consumer CyclicalSMURFIT WESTROCK PLCstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SW
SPYSBUX2026-09-160.17017713603149.00Consumer CyclicalUNITED STATESUSNorth AmericaSTARBUCKSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SBUX
SPYROST2026-09-160.1113223853130.00Consumer CyclicalUNITED STATESUSNorth AmericaROSS STORESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ROST
SPYROL2026-09-160.0151393513058.00Consumer CyclicalUNITED STATESUSNorth AmericaROLLINSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ROL
SPYRL2026-09-160.020164463695.00Consumer CyclicalUNITED STATESUSNorth AmericaRALPH LAURENstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RL
SPYRCL2026-09-160.0968042984023.00Consumer CyclicalUNITED STATESUSNorth AmericaROYAL CARIBBEAN CRUISESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RCL
SPYPKG2026-09-160.0314981058888.00Consumer CyclicalUNITED STATESUSNorth AmericaPACKAGING CORP OF AMERICAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PKG
SPYPHM2026-09-160.0344172278145.00Consumer CyclicalUNITED STATESUSNorth AmericaPULTEGROUPstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PHM
SPYORLY2026-09-160.1065959911672.00Consumer CyclicalUNITED STATESUSNorth AmericaO REILLY AUTOMOTIVEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ORLY
SPYNVR2026-09-160.02541531965.00Consumer CyclicalUNITED STATESUSNorth AmericaNVRstockfalseuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NVR
SPYNKE2026-09-160.06597514347321.00Consumer CyclicalUNITED STATESUSNorth AmericaNIKEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NKE
SPYNCLH2026-09-160.0103275529988.00Consumer CyclicalUNITED STATESUSNorth AmericaNORWEGIAN CRUISE LINEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NCLH
SPYMGM2026-09-160.0111902268062.00Consumer CyclicalUNITED STATESUSNorth AmericaMGM RESORTS stocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MGM
SPYMCD2026-09-160.2711288487370.00Consumer CyclicalUNITED STATESUSNorth AmericaMCDONALDSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MCD
SPYMAR2026-09-160.1126942617732.00Consumer CyclicalUNITED STATESUSNorth AmericaMARRIOTTstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MAR
SPYLVS2026-09-160.0188193566300.00Consumer CyclicalUNITED STATESUSNorth AmericaLAS VEGAS SANDSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LVS
SPYLULU2026-09-160.0154501252517.00Consumer CyclicalCANADACANorth AmericaLULULEMON ATHLETICAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LULU
SPYLOW2026-09-160.1667596684881.00Consumer CyclicalUNITED STATESUSNorth AmericaLOWES COMPANIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LOW
SPYLEN2026-09-160.0259272574519.00Consumer CyclicalUNITED STATESUSNorth AmericaLENNARstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LEN
SPYIP2026-09-160.0276626319295.00Consumer CyclicalUNITED STATESUSNorth AmericaINTERNATIONAL PAPERstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30IP
SPYHLT2026-09-160.1069512722814.00Consumer CyclicalUNITED STATESUSNorth AmericaHILTON WORLDWIDE HOLDINGSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HLT
SPYHD2026-09-160.46242911895790.00Consumer CyclicalUNITED STATESUSNorth AmericaHOME DEPOTstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HD
SPYHAS2026-09-160.0183071595125.00Consumer CyclicalUNITED STATESUSNorth AmericaHASBROstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HAS
SPYGPC2026-09-160.0276121646111.00Consumer CyclicalUNITED STATESUSNorth AmericaGENUINE PARTSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GPC
SPYGM2026-09-160.11683110784822.00Consumer CyclicalUNITED STATESUSNorth AmericaGENERAL MOTORSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GM
SPYF2026-09-160.08031846812490.00Consumer CyclicalUNITED STATESUSNorth AmericaFORDstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30F
SPYEXPE2026-09-160.0505031369344.00Consumer CyclicalUNITED STATESUSNorth AmericaEXPEDIA GROUPstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30EXPE
SPYEBAY2026-09-160.0745075310333.00Consumer CyclicalUNITED STATESUSNorth AmericaEBAYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30EBAY
SPYDRI2026-09-160.0366311369785.00Consumer CyclicalUNITED STATESUSNorth AmericaDARDEN RESTAURANTSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DRI
SPYDPZ2026-09-160.014176366081.00Consumer CyclicalUNITED STATESUSNorth AmericaDOMINOS PIZZAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DPZ
SPYDHI2026-09-160.0560753154373.00Consumer CyclicalUNITED STATESUSNorth AmericaHORTON D Rstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DHI
SPYDECK2026-09-160.0169501691683.00Consumer CyclicalUNITED STATESUSNorth AmericaDECKERS OUTDOORstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DECK
SPYCVNA2026-09-160.0720088567097.00Consumer CyclicalUNITED STATESUSNorth AmericaCARVANAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CVNA
SPYCMG2026-09-160.06640815341929.00Consumer CyclicalUNITED STATESUSNorth AmericaCHIPOTLEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CMG
SPYCCL2026-09-160.04403915331779.00Consumer CyclicalUNITED STATESUSNorth AmericaCARNIVALstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CCL
SPYBKNG2026-09-160.2038649254652.00Consumer CyclicalUNITED STATESUSNorth AmericaBOOKING HOLDINGSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BKNG
SPYBBY2026-09-160.0276582352216.00Consumer CyclicalUNITED STATESUSNorth AmericaBEST BUY COstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BBY
SPYBALL2026-09-160.0250703184311.00Consumer CyclicalUNITED STATESUSNorth AmericaBALLstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BALL
SPYAZO2026-09-160.072046196761.00Consumer CyclicalUNITED STATESUSNorth AmericaAUTOZONEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AZO
SPYAPTV2026-09-160.0141152534132.00Consumer CyclicalSWITZERLANDCHEuropeAPTIVstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30APTV
SPYAMZN2026-09-163.697323116964314.00Consumer CyclicalUNITED STATESUSNorth AmericaAMAZON stocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AMZN
SPYAMCR2026-09-160.0296155490394.00Consumer CyclicalUNITED KINGDOMGBEuropeAMCORstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AMCR