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×etf = SPY×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
SPYZTS2026-09-030.0479515122345.00HealthcareUNITED STATESUSNorth AmericaZOETISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ZTS
SPYZBRA2026-09-030.025543582290.00TechnologyUNITED STATESUSNorth AmericaZEBRA TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ZBRA
SPYZBH2026-09-030.0286902363690.00HealthcareUNITED STATESUSNorth AmericaZIMMER BIOMET HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ZBH
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
SPYXYL2026-09-030.0384502904367.00IndustrialsUNITED STATESUSNorth AmericaXYLEMstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XYL
SPYXOM2026-09-031.00686950586328.00EnergyUNITED STATESUSNorth AmericaEXXON MOBILstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XOM
SPYXEL2026-09-030.0714527627845.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XEL
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
SPYWY2026-09-030.0244948743663.00Real EstateUNITED STATESUSNorth AmericaWEYERHAEUSERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WY
SPYWST2026-09-030.036302863199.00HealthcareUNITED STATESUSNorth AmericaWEST PHARMACEUTICAL SERVICESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WST
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
SPYWRB2026-09-030.0306423593070.00Financial ServicesUNITED STATESUSNorth AmericaBERKLEY W Rstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WRB
SPYWMT2026-09-030.71176053501027.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WMT
SPYWMB2026-09-030.13554514917470.00EnergyUNITED STATESUSNorth AmericaWILLIAMS COMPANIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WMB
SPYWM2026-09-030.1228094514016.00IndustrialsUNITED STATESUSNorth AmericaWASTE MANAGEMENTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WM
SPYWFC2026-09-030.40861437336635.00Financial ServicesUNITED STATESUSNorth AmericaWELLS FARGOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WFC
SPYWELL2026-09-030.2548228612754.00Real EstateUNITED STATESUSNorth AmericaWELLTOWERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WELL
SPYWEC2026-09-030.0521093980029.00UtilitiesUNITED STATESUSNorth AmericaWEC ENERGY GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WEC
SPYWDC2026-09-030.2277944204174.00TechnologyUNITED STATESUSNorth AmericaWESTERN DIGITALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WDC
SPYWDAY2026-09-030.0631942488935.00TechnologyUNITED STATESUSNorth AmericaWORKDAYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WDAY
SPYWBD2026-09-030.10541530281710.00Communication ServicesUNITED STATESUSNorth AmericaWARNER BROS DISCOVERYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WBD
SPYWAT2026-09-030.0608001198120.00HealthcareUNITED STATESUSNorth AmericaWATERSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WAT
SPYWAB2026-09-030.0714302072885.00IndustrialsUNITED STATESUSNorth AmericaWESTINGHOUSE AIR BRAKE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WAB
SPYVZ2026-09-030.31630550954051.00Communication ServicesUNITED STATESUSNorth AmericaVERIZON COMMUNICATIONSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VZ
SPYVTRS2026-09-030.02954514213738.00HealthcareUNITED STATESUSNorth AmericaVIATRISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VTRS
SPYVTR2026-09-030.0671425940560.00Real EstateUNITED STATESUSNorth AmericaVENTASstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VTR
SPYVST2026-09-030.0685373872890.00UtilitiesUNITED STATESUSNorth AmericaVISTRAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VST
SPYVRTX2026-09-030.2118913094899.00HealthcareUNITED STATESUSNorth AmericaVERTEX PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VRTX
SPYVRT2026-09-030.1547244690488.00IndustrialsUNITED STATESUSNorth AmericaVERTIV HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VRT
SPYVRSN2026-09-030.0360061000281.00TechnologyUNITED STATESUSNorth AmericaVERISIGNstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VRSN
SPYVRSK2026-09-030.0374421600933.00IndustrialsUNITED STATESUSNorth AmericaVERISK ANALYTICSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VRSK
SPYVMC2026-09-030.0506191585239.00Basic MaterialsUNITED STATESUSNorth AmericaVULCAN MATERIALSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VMC
SPYVLO2026-09-030.1646413619640.00EnergyUNITED STATESUSNorth AmericaVALERO ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VLO
SPYVICI2026-09-030.04198213338567.00Real EstateUNITED STATESUSNorth AmericaVICI PROPERTIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VICI
SPYVEEV2026-09-030.0640131834449.00HealthcareUNITED STATESUSNorth AmericaVEEVA SYSTEMSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VEEV
SPYV2026-09-030.94128920253865.00Financial ServicesUNITED STATESUSNorth AmericaVISAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27V
SPYUSB2026-09-030.14751718923517.00Financial ServicesUNITED STATESUSNorth AmericaUS BANCORPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27USB
SPYURI2026-09-030.093319765204.00IndustrialsUNITED STATESUSNorth AmericaUNITED RENTALSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27URI
SPYUPS2026-09-030.1158539122324.00IndustrialsUNITED STATESUSNorth AmericaUNITED PARCEL SERVICEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UPS
SPYUNP2026-09-030.2570317244368.00IndustrialsUNITED STATESUSNorth AmericaUNION PACIFICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UNP
SPYUNH2026-09-030.54517711081427.00HealthcareUNITED STATESUSNorth AmericaUNITEDHEALTH GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UNH
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
SPYUHS2026-09-030.013521651220.00HealthcareUNITED STATESUSNorth AmericaUNIVERSAL HEALTH SERVICESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UHS
SPYUDR2026-09-030.0161213612333.00Real EstateUNITED STATESUSNorth AmericaUDRstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UDR
SPYUBER2026-09-030.23149024836157.00TechnologyUNITED STATESUSNorth AmericaUBERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UBER
SPYUAL2026-09-030.0528743965645.00IndustrialsUNITED STATESUSNorth AmericaUNITED AIRLINES HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27UAL
SPYTYL2026-09-030.023961514872.00TechnologyUNITED STATESUSNorth AmericaTYLER TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TYL
SPYTXT2026-09-030.0206482120066.00IndustrialsUNITED STATESUSNorth AmericaTEXTRONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TXT
SPYTXN2026-09-030.34595311107398.00TechnologyUNITED STATESUSNorth AmericaTEXAS INSTRUMENTSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TXN
SPYTTWO2026-09-030.0558842126885.00Communication ServicesUNITED STATESUSNorth AmericaTAKE TWO INTERACTIVE stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TTWO