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

Sources in this table

as_ofto
column equals (exact text)
sort
chart against as_of
reset

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
SPYTYL2026-09-160.022449504192.00TechnologyUNITED STATESUSNorth AmericaTYLER TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TYL
SPYTXT2026-09-160.0215252075121.00IndustrialsUNITED STATESUSNorth AmericaTEXTRONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TXT
SPYTXN2026-09-160.36425510872883.00TechnologyUNITED STATESUSNorth AmericaTEXAS INSTRUMENTSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TXN
SPYTTWO2026-09-160.0566742081940.00Communication ServicesUNITED STATESUSNorth AmericaTAKE TWO INTERACTIVE stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TTWO
SPYTTD2026-09-160.0095105106993.00TechnologyUNITED STATESUSNorth AmericaTRADE DESKstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TTD
SPYTT2026-09-160.1429482637709.00IndustrialsIRELANDIEEuropeTRANE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TT
SPYTSN2026-09-160.0226043374566.00Consumer DefensiveUNITED STATESUSNorth AmericaTYSON FOODSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TSN
SPYTSLA2026-09-161.54792733635719.00Consumer CyclicalUNITED STATESUSNorth AmericaTESLAstocktrue——uw_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 SUPPLYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TSCO
SPYTRV2026-09-160.1238532543248.00Financial ServicesUNITED STATESUSNorth AmericaTRAVELERS COMPANIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TRV
SPYTROW2026-09-160.0337262562688.00Financial ServicesUNITED STATESUSNorth AmericaPRICE T ROWE GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TROW
SPYTRMB2026-09-160.0205392788073.00TechnologyUNITED STATESUSNorth AmericaTRIMBLEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TRMB
SPYTRGP2026-09-160.0939532567134.00EnergyUNITED STATESUSNorth AmericaTARGA RESOURCESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TRGP
SPYTPR2026-09-160.0366882420415.00Consumer CyclicalUNITED STATESUSNorth AmericaTAPESTRYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TPR
SPYTPL2026-09-160.031023692502.00EnergyUNITED STATESUSNorth AmericaTEXAS PACIFIC LANDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TPL
SPYTMUS2026-09-160.1260965566465.00Communication ServicesUNITED STATESUSNorth AmericaT-MOBILE USstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TMUS
SPYTMO2026-09-160.3699714439514.00HealthcareUNITED STATESUSNorth AmericaTHERMO FISHER SCIENTIFICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TMO
SPYTKO2026-09-160.018623753035.00Communication Services———TKO GROUP HOLDINGS INCstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TKO
SPYTJX2026-09-160.20851913207946.00Consumer CyclicalUNITED STATESUSNorth AmericaTJX COMPANIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TJX
SPYTGT2026-09-160.1077905422215.00Consumer DefensiveUNITED STATESUSNorth AmericaTARGETstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TGT
SPYTFC2026-09-160.09277114901857.00Financial ServicesUNITED STATESUSNorth AmericaTRUIST FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TFC
SPYTER2026-09-160.0820561871517.00TechnologyUNITED STATESUSNorth AmericaTERADYNEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TER
SPYTEL2026-09-160.0907253491194.00TechnologyIRELANDIEEuropeTE CONNECTIVITYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TEL
SPYTECH2026-09-160.0174371875753.00HealthcareUNITED STATESUSNorth AmericaBIO-TECHNEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TECH
SPYTDY2026-09-160.042810554153.00TechnologyUNITED STATESUSNorth AmericaTELEDYNE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TDY
SPYTDG2026-09-160.092849668866.00IndustrialsUNITED STATESUSNorth AmericaTRANSDIGM GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TDG
SPYTAP2026-09-160.0096451918813.00Consumer DefensiveUNITED STATESUSNorth AmericaMOLSON COORS BEVERAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TAP
SPYT2026-09-160.27582082990325.00Communication ServicesUNITED STATESUSNorth AmericaAT&Tstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30T
SPYSYY2026-09-160.0578545719210.00Consumer DefensiveUNITED STATESUSNorth AmericaSYSCOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SYY
SPYSYK2026-09-160.1507004117793.00HealthcareUNITED STATESUSNorth AmericaSTRYKERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SYK
SPYSYF2026-09-160.0387174023125.00Financial ServicesUNITED STATESUSNorth AmericaSYNCHRONY FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SYF
SPYSWKS2026-09-160.0197871798821.00TechnologyUNITED STATESUSNorth AmericaSKYWORKS SOLUTIONSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SWKS
SPYSWK2026-09-160.0212791859272.00IndustrialsUNITED STATESUSNorth AmericaSTANLEY BLACK & DECKERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SWK
SPYSW2026-09-160.0359656277294.00Consumer Cyclical———SMURFIT WESTROCK PLCstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SW
SPYSTZ2026-09-160.0263751668030.00Consumer DefensiveUNITED STATESUSNorth AmericaCONSTELLATION BRANDSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30STZ
SPYSTX2026-09-160.2695062677544.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30STX
SPYSTT2026-09-160.0778093310136.00Financial ServicesUNITED STATESUSNorth AmericaSTATE STREETstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30STT
SPYSTLD2026-09-160.0496661622148.00Basic MaterialsUNITED STATESUSNorth AmericaSTEEL DYNAMICSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30STLD
SPYSTE2026-09-160.0316441173042.00HealthcareIRELANDIEEuropeSTERISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30STE
SPYSRE2026-09-160.0821017819068.00UtilitiesUNITED STATESUSNorth AmericaSEMPRAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SRE
SPYSPGI2026-09-160.1891803618825.00Financial ServicesUNITED STATESUSNorth AmericaS&P GLOBALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SPGI
SPYSPG2026-09-160.1011593878544.00Real EstateUNITED STATESUSNorth AmericaSIMON PROPERTY GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SPG
SPYSOLV2026-09-160.0200981760458.00Healthcare———Solventum Corporationstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SOLV
SPYSO2026-09-160.14908313452413.00UtilitiesUNITED STATESUSNorth AmericaSOUTHERNstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SO
SPYSNPS2026-09-160.1114452291172.00TechnologyUNITED STATESUSNorth AmericaSYNOPSYSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SNPS
SPYSNDK2026-09-160.3457541769955.00Technology———Sandisk Corporation stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SNDK
SPYSNA2026-09-160.029699619569.00IndustrialsUNITED STATESUSNorth AmericaSNAP-ONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SNA
SPYSMCI2026-09-160.0318766730677.00TechnologyUNITED STATESUSNorth AmericaSUPER MICRO COMPUTERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SMCI
SPYSLB2026-09-160.12019117881424.00EnergyNETHERLANDSNLEuropeSCHLUMBERGERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SLB
SPYSJM2026-09-160.0202571275659.00Consumer DefensiveUNITED STATESUSNorth AmericaJ M SMUCKERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SJM