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×

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
SPYZTS2026-09-160.0470435014210.00HealthcareUNITED STATESUSNorth AmericaZOETISstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ZTS
SPYZBRA2026-09-160.024986569830.00TechnologyUNITED STATESUSNorth AmericaZEBRA TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ZBRA
SPYZBH2026-09-160.0287802313850.00HealthcareUNITED STATESUSNorth AmericaZIMMER BIOMET HOLDINGSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ZBH
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
SPYXYZ2026-09-160.0630426401158.00TechnologyBlockstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30XYZ
SPYXYL2026-09-160.0391942842957.00IndustrialsUNITED STATESUSNorth AmericaXYLEMstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30XYL
SPYXOM2026-09-161.03938149518328.00EnergyUNITED STATESUSNorth AmericaEXXON MOBILstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30XOM
SPYXEL2026-09-160.0697787467200.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30XEL
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
SPYWY2026-09-160.0239888558098.00Real EstateUNITED STATESUSNorth AmericaWEYERHAEUSERstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WY
SPYWTW2026-09-160.0454321129736.00Financial ServicesUNITED KINGDOMGBEuropeWILLIS TOWERS WATSONstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WTW
SPYWST2026-09-160.039312844954.00HealthcareUNITED STATESUSNorth AmericaWEST PHARMACEUTICAL SERVICESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WST
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
SPYWRB2026-09-160.0316213517420.00Financial ServicesUNITED STATESUSNorth AmericaBERKLEY W Rstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WRB
SPYWMT2026-09-160.72355952371617.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WMT
SPYWMB2026-09-160.13305814602410.00EnergyUNITED STATESUSNorth AmericaWILLIAMS COMPANIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WMB
SPYWM2026-09-160.1215314418786.00IndustrialsUNITED STATESUSNorth AmericaWASTE MANAGEMENTstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WM
SPYWFC2026-09-160.40888736548095.00Financial ServicesUNITED STATESUSNorth AmericaWELLS FARGOstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WFC
SPYWELL2026-09-160.2540858430749.00Real EstateUNITED STATESUSNorth AmericaWELLTOWERstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WELL
SPYWEC2026-09-160.0517633895924.00UtilitiesUNITED STATESUSNorth AmericaWEC ENERGY GROUPstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WEC
SPYWDC2026-09-160.2205274115174.00TechnologyUNITED STATESUSNorth AmericaWESTERN DIGITALstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WDC
SPYWDAY2026-09-160.0587932436425.00TechnologyUNITED STATESUSNorth AmericaWORKDAYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WDAY
SPYWBD2026-09-160.10693929643135.00Communication ServicesUNITED STATESUSNorth AmericaWARNER BROS DISCOVERYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WBD
SPYWAT2026-09-160.0630981172755.00HealthcareUNITED STATESUSNorth AmericaWATERSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WAT
SPYWAB2026-09-160.0720782029275.00IndustrialsUNITED STATESUSNorth AmericaWESTINGHOUSE AIR BRAKE TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WAB
SPYVZ2026-09-160.31898049878486.00Communication ServicesUNITED STATESUSNorth AmericaVERIZON COMMUNICATIONSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VZ
SPYVTRS2026-09-160.03043513913808.00HealthcareUNITED STATESUSNorth AmericaVIATRISstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VTRS
SPYVTR2026-09-160.0659295815515.00Real EstateUNITED STATESUSNorth AmericaVENTASstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VTR
SPYVST2026-09-160.0684013791010.00UtilitiesUNITED STATESUSNorth AmericaVISTRAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VST
SPYVRTX2026-09-160.1998373029484.00HealthcareUNITED STATESUSNorth AmericaVERTEX PHARMACEUTICALSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VRTX
SPYVRT2026-09-160.1412814591698.00IndustrialsUNITED STATESUSNorth AmericaVERTIV HOLDINGSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VRT
SPYVRSN2026-09-160.037566979366.00TechnologyUNITED STATESUSNorth AmericaVERISIGNstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VRSN
SPYVRSK2026-09-160.0366051567113.00IndustrialsUNITED STATESUSNorth AmericaVERISK ANALYTICSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VRSK
SPYVMRK2026-09-160.0704928707649.00Real EstateVivmark Residentialstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VMRK
SPYVMC2026-09-160.0487241551864.00Basic MaterialsUNITED STATESUSNorth AmericaVULCAN MATERIALSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VMC
SPYVLTO2026-09-160.0361462937342.00IndustrialsVERALTO CORPstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VLTO
SPYVLO2026-09-160.1836373543100.00EnergyUNITED STATESUSNorth AmericaVALERO ENERGYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VLO
SPYVICI2026-09-160.04039113056882.00Real EstateUNITED STATESUSNorth AmericaVICI PROPERTIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VICI
SPYVEEV2026-09-160.0611361795734.00HealthcareUNITED STATESUSNorth AmericaVEEVA SYSTEMSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VEEV
SPYV2026-09-160.94515219826220.00Financial ServicesUNITED STATESUSNorth AmericaVISAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30V
SPYUSB2026-09-160.14219518523462.00Financial ServicesUNITED STATESUSNorth AmericaUS BANCORPstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30USB
SPYURI2026-09-160.096887749184.00IndustrialsUNITED STATESUSNorth AmericaUNITED RENTALSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30URI
SPYUPS2026-09-160.1133578930084.00IndustrialsUNITED STATESUSNorth AmericaUNITED PARCEL SERVICEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UPS
SPYUNP2026-09-160.2560227091288.00IndustrialsUNITED STATESUSNorth AmericaUNION PACIFICstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UNP
SPYUNH2026-09-160.52314910847357.00HealthcareUNITED STATESUSNorth AmericaUNITEDHEALTH GROUPstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UNH
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
SPYUHS2026-09-160.014845637425.00HealthcareUNITED STATESUSNorth AmericaUNIVERSAL HEALTH SERVICESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UHS
SPYUDR2026-09-160.0156343536238.00Real EstateUNITED STATESUSNorth AmericaUDRstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UDR
SPYUBER2026-09-160.22174624311502.00TechnologyUNITED STATESUSNorth AmericaUBERstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UBER
SPYUAL2026-09-160.0530343881985.00IndustrialsUNITED STATESUSNorth AmericaUNITED AIRLINES HOLDINGSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UAL