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:etf = SPY×sector = Consumer Cyclical×sorted by as_of ↑×

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
SPYYUM2026-09-030.0630383367867.00Consumer CyclicalUNITED STATESUSNorth AmericaYUM BRANDSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27YUM
SPYWYNN2026-09-030.0115081024315.00Consumer CyclicalUNITED STATESUSNorth AmericaWYNN RESORTSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WYNN
SPYWSM2026-09-030.0393191438470.00Consumer CyclicalUNITED STATESUSNorth AmericaWILLIAMS SONOMAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WSM
SPYULTA2026-09-030.036371532053.00Consumer CyclicalUNITED STATESUSNorth AmericaULTA BEAUTYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ULTA
SPYTSLA2026-09-031.58685934361069.00Consumer CyclicalUNITED STATESUSNorth AmericaTESLAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TSLA
SPYTSCO2026-09-030.0272066407956.00Consumer CyclicalUNITED STATESUSNorth AmericaTRACTOR SUPPLYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TSCO
SPYTPR2026-09-030.0370552472480.00Consumer CyclicalUNITED STATESUSNorth AmericaTAPESTRYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TPR
SPYTJX2026-09-030.21885713492746.00Consumer CyclicalUNITED STATESUSNorth AmericaTJX COMPANIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TJX
SPYSW2026-09-030.0356136412574.00Consumer Cyclical———SMURFIT WESTROCK PLCstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SW
SPYSBUX2026-09-030.18044613896849.00Consumer CyclicalUNITED STATESUSNorth AmericaSTARBUCKSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SBUX
SPYROST2026-09-030.1118993936345.00Consumer CyclicalUNITED STATESUSNorth AmericaROSS STORESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ROST
SPYROL2026-09-030.0157253588708.00Consumer CyclicalUNITED STATESUSNorth AmericaROLLINSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ROL
SPYRL2026-09-030.019998473485.00Consumer CyclicalUNITED STATESUSNorth AmericaRALPH LAURENstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27RL
SPYRCL2026-09-030.0993203048103.00Consumer CyclicalUNITED STATESUSNorth AmericaROYAL CARIBBEAN CRUISESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27RCL
SPYPKG2026-09-030.0311311081583.00Consumer CyclicalUNITED STATESUSNorth AmericaPACKAGING CORP OF AMERICAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PKG
SPYPHM2026-09-030.0354962327095.00Consumer CyclicalUNITED STATESUSNorth AmericaPULTEGROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PHM
SPYORLY2026-09-030.10856310125272.00Consumer CyclicalUNITED STATESUSNorth AmericaO REILLY AUTOMOTIVEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ORLY
SPYNVR2026-09-030.02569632855.00Consumer CyclicalUNITED STATESUSNorth AmericaNVRstockfalse——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NVR
SPYNKE2026-09-030.06972314656151.00Consumer CyclicalUNITED STATESUSNorth AmericaNIKEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NKE
SPYNCLH2026-09-030.0108055648358.00Consumer CyclicalUNITED STATESUSNorth AmericaNORWEGIAN CRUISE LINEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NCLH
SPYMGM2026-09-030.0116962317457.00Consumer CyclicalUNITED STATESUSNorth AmericaMGM RESORTS stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MGM
SPYMCD2026-09-030.2762168670265.00Consumer CyclicalUNITED STATESUSNorth AmericaMCDONALDSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MCD
SPYMAR2026-09-030.1102792674247.00Consumer CyclicalUNITED STATESUSNorth AmericaMARRIOTTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MAR
SPYLVS2026-09-030.0198983643285.00Consumer CyclicalUNITED STATESUSNorth AmericaLAS VEGAS SANDSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LVS
SPYLULU2026-09-030.0191201279662.00Consumer CyclicalCANADACANorth AmericaLULULEMON ATHLETICAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LULU
SPYLOW2026-09-030.1691846829061.00Consumer CyclicalUNITED STATESUSNorth AmericaLOWES COMPANIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LOW
SPYLEN2026-09-030.0272552630144.00Consumer CyclicalUNITED STATESUSNorth AmericaLENNARstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LEN
SPYIP2026-09-030.0288676455910.00Consumer CyclicalUNITED STATESUSNorth AmericaINTERNATIONAL PAPERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IP
SPYHLT2026-09-030.1072912781554.00Consumer CyclicalUNITED STATESUSNorth AmericaHILTON WORLDWIDE HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HLT
SPYHD2026-09-030.47429912152555.00Consumer CyclicalUNITED STATESUSNorth AmericaHOME DEPOTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HD
SPYHAS2026-09-030.0185991629835.00Consumer CyclicalUNITED STATESUSNorth AmericaHASBROstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HAS
SPYGPC2026-09-030.0281791681711.00Consumer CyclicalUNITED STATESUSNorth AmericaGENUINE PARTSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GPC
SPYGM2026-09-030.11766511017112.00Consumer CyclicalUNITED STATESUSNorth AmericaGENERAL MOTORSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GM
SPYF2026-09-030.08455647820860.00Consumer CyclicalUNITED STATESUSNorth AmericaFORDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27F
SPYEXPE2026-09-030.0520281398714.00Consumer CyclicalUNITED STATESUSNorth AmericaEXPEDIA GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EXPE
SPYEBAY2026-09-030.0704645424698.00Consumer CyclicalUNITED STATESUSNorth AmericaEBAYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EBAY
SPYDRI2026-09-030.0374341399155.00Consumer CyclicalUNITED STATESUSNorth AmericaDARDEN RESTAURANTSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DRI
SPYDPZ2026-09-030.015930374091.00Consumer CyclicalUNITED STATESUSNorth AmericaDOMINOS PIZZAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DPZ
SPYDHI2026-09-030.0571013222458.00Consumer CyclicalUNITED STATESUSNorth AmericaHORTON D Rstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DHI
SPYDECK2026-09-030.0179191728173.00Consumer CyclicalUNITED STATESUSNorth AmericaDECKERS OUTDOORstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DECK
SPYCVNA2026-09-030.0788558751772.00Consumer CyclicalUNITED STATESUSNorth AmericaCARVANAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CVNA
SPYCMG2026-09-030.07225115672564.00Consumer CyclicalUNITED STATESUSNorth AmericaCHIPOTLEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CMG
SPYCCL2026-09-030.04512815663304.00Consumer CyclicalUNITED STATESUSNorth AmericaCARNIVALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CCL
SPYBKNG2026-09-030.2263729454457.00Consumer CyclicalUNITED STATESUSNorth AmericaBOOKING HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BKNG
SPYBBY2026-09-030.0257922402501.00Consumer CyclicalUNITED STATESUSNorth AmericaBEST BUY COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BBY
SPYBALL2026-09-030.0251183252841.00Consumer CyclicalUNITED STATESUSNorth AmericaBALLstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BALL
SPYAZO2026-09-030.073280201211.00Consumer CyclicalUNITED STATESUSNorth AmericaAUTOZONEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AZO
SPYAPTV2026-09-030.0147812588867.00Consumer CyclicalSWITZERLANDCHEuropeAPTIVstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27APTV
SPYAMZN2026-09-033.795875119486129.00Consumer CyclicalUNITED STATESUSNorth AmericaAMAZON stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AMZN
SPYAMCR2026-09-030.0311405609654.00Consumer CyclicalUNITED KINGDOMGBEuropeAMCORstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AMCR