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:continent = North America×source = uw_etf_holdings×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
XLYYUM2026-06-301.0991891553513.00Consumer CyclicalUNITED STATESUSNorth AmericaYUM BRANDSstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27YUM
XLYWYNN2026-06-300.203090472603.00Consumer CyclicalUNITED STATESUSNorth AmericaWYNN RESORTSstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WYNN
XLYWSM2026-06-300.684704663656.00Consumer CyclicalUNITED STATESUSNorth AmericaWILLIAMS SONOMAstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WSM
XLYULTA2026-06-300.489990245478.00Consumer CyclicalUNITED STATESUSNorth AmericaULTA BEAUTYstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ULTA
XLYTSLA2026-06-3019.69125910577584.00Consumer CyclicalUNITED STATESUSNorth AmericaTESLAstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TSLA
XLYTSCO2026-06-300.4134712955311.00Consumer CyclicalUNITED STATESUSNorth AmericaTRACTOR SUPPLYstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TSCO
XLYTPR2026-06-300.7378221138813.00Consumer CyclicalUNITED STATESUSNorth AmericaTAPESTRYstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TPR
XLYTJX2026-06-303.9332505865718.00Consumer CyclicalUNITED STATESUSNorth AmericaTJX COMPANIESstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TJX
XLYSBUX2026-06-302.9053766423567.00Consumer CyclicalUNITED STATESUSNorth AmericaSTARBUCKSstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SBUX
XLYROST2026-06-301.7105731815726.00Consumer CyclicalUNITED STATESUSNorth AmericaROSS STORESstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ROST
XLYRL2026-06-300.386969217806.00Consumer CyclicalUNITED STATESUSNorth AmericaRALPH LAURENstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27RL
XLYRCL2026-06-301.9756951405780.00Consumer CyclicalUNITED STATESUSNorth AmericaROYAL CARIBBEAN CRUISESstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27RCL
XLYPHM2026-06-300.6518721073393.00Consumer CyclicalUNITED STATESUSNorth AmericaPULTEGROUPstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PHM
XLYORLY2026-06-301.9038244670857.00Consumer CyclicalUNITED STATESUSNorth AmericaO REILLY AUTOMOTIVEstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ORLY
XLYNVR2026-06-300.45871115211.00Consumer CyclicalUNITED STATESUSNorth AmericaNVRstockfalse——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NVR
XLYNKE2026-06-301.2283606760747.00Consumer CyclicalUNITED STATESUSNorth AmericaNIKEstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NKE
XLYNCLH2026-06-300.2417272587133.00Consumer CyclicalUNITED STATESUSNorth AmericaNORWEGIAN CRUISE LINEstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NCLH
XLYMGM2026-06-300.2288131081293.00Consumer CyclicalUNITED STATESUSNorth AmericaMGM RESORTS stocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MGM
XLYMCD2026-06-304.1646743480977.00Consumer CyclicalUNITED STATESUSNorth AmericaMCDONALDSstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MCD
XLYMAR2026-06-302.0233661233568.00Consumer CyclicalUNITED STATESUSNorth AmericaMARRIOTTstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MAR
XLYLVS2026-06-300.3435081680237.00Consumer CyclicalUNITED STATESUSNorth AmericaLAS VEGAS SANDSstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LVS
XLYLULU2026-06-300.298211590086.00Consumer CyclicalCANADACANorth AmericaLULULEMON ATHLETICAstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LULU
XLYLOW2026-06-303.0805453156610.00Consumer CyclicalUNITED STATESUSNorth AmericaLOWES COMPANIESstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LOW
XLYLEN2026-06-300.4857841212900.00Consumer CyclicalUNITED STATESUSNorth AmericaLENNARstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LEN
XLYHLT2026-06-301.8767081283099.00Consumer CyclicalUNITED STATESUSNorth AmericaHILTON WORLDWIDE HOLDINGSstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HLT
XLYHD2026-06-305.8416223742268.00Consumer CyclicalUNITED STATESUSNorth AmericaHOME DEPOTstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HD
XLYHAS2026-06-300.276879757433.00Consumer CyclicalUNITED STATESUSNorth AmericaHASBROstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HAS
XLYGPC2026-06-300.404970775526.00Consumer CyclicalUNITED STATESUSNorth AmericaGENUINE PARTSstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GPC
XLYGM2026-06-301.7337815082002.00Consumer CyclicalUNITED STATESUSNorth AmericaGENERAL MOTORSstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GM
XLYF2026-06-301.35715322059534.00Consumer CyclicalUNITED STATESUSNorth AmericaFORDstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27F
XLYEXPE2026-06-300.730893645357.00Consumer CyclicalUNITED STATESUSNorth AmericaEXPEDIA GROUPstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EXPE
XLYEBAY2026-06-301.2377912502546.00Consumer CyclicalUNITED STATESUSNorth AmericaEBAYstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EBAY
XLYDRI2026-06-300.588486645402.00Consumer CyclicalUNITED STATESUSNorth AmericaDARDEN RESTAURANTSstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DRI
XLYDPZ2026-06-300.225961172451.00Consumer CyclicalUNITED STATESUSNorth AmericaDOMINOS PIZZAstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DPZ
XLYDHI2026-06-301.0716131486458.00Consumer CyclicalUNITED STATESUSNorth AmericaHORTON D Rstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DHI
XLYDECK2026-06-300.351521799885.00Consumer CyclicalUNITED STATESUSNorth AmericaDECKERS OUTDOORstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DECK
XLYDASH2026-06-301.7420582132936.00Communication ServicesUNITED STATESUSNorth AmericaDOORDASHstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DASH
XLYCVNA2026-06-301.1761394037226.00Consumer CyclicalUNITED STATESUSNorth AmericaCARVANAstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CVNA
XLYCMG2026-06-301.0880077229946.00Consumer CyclicalUNITED STATESUSNorth AmericaCHIPOTLEstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CMG
XLYCCL2026-06-300.9168977250910.00Consumer CyclicalUNITED STATESUSNorth AmericaCARNIVALstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CCL
XLYBKNG2026-06-303.4454084367348.00Consumer CyclicalUNITED STATESUSNorth AmericaBOOKING HOLDINGSstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BKNG
XLYBBY2026-06-300.3708331104164.00Consumer CyclicalUNITED STATESUSNorth AmericaBEST BUY COstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BBY
XLYAZO2026-06-301.31363092866.00Consumer CyclicalUNITED STATESUSNorth AmericaAUTOZONEstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AZO
XLYAMZN2026-06-3022.27924921119610.00Consumer CyclicalUNITED STATESUSNorth AmericaAMAZON stocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AMZN
XLYABNB2026-06-301.4919602355590.00Consumer CyclicalUNITED STATESUSNorth AmericaAIRBNBstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ABNB
XLVZTS2026-08-020.5410002981989.00HealthcareUNITED STATESUSNorth AmericaZOETISstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ZTS
XLVZTS2026-06-300.5260752972182.00HealthcareUNITED STATESUSNorth AmericaZOETISstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ZTS
XLVZBH2026-08-020.3120001376041.00HealthcareUNITED STATESUSNorth AmericaZIMMER BIOMET HOLDINGSstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ZBH
XLVZBH2026-06-300.2908541371629.00HealthcareUNITED STATESUSNorth AmericaZIMMER BIOMET HOLDINGSstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ZBH
XLVWST2026-08-020.407000502519.00HealthcareUNITED STATESUSNorth AmericaWEST PHARMACEUTICAL SERVICESstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WST