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 = Healthcare×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
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
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
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
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
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
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
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
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
SPYTMO2026-09-030.3441504535189.00HealthcareUNITED STATESUSNorth AmericaTHERMO FISHER SCIENTIFICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TMO
SPYTECH2026-09-030.0170351916248.00HealthcareUNITED STATESUSNorth AmericaBIO-TECHNEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TECH
SPYSYK2026-09-030.1589834206793.00HealthcareUNITED STATESUSNorth AmericaSTRYKERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SYK
SPYSTE2026-09-030.0332541198407.00HealthcareIRELANDIEEuropeSTERISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27STE
SPYSOLV2026-09-030.0203981798283.00Healthcare———Solventum Corporationstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SOLV
SPYRVTY2026-09-030.0218531363355.00Healthcare———REVVITYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27RVTY
SPYRMD2026-09-030.0498411772273.00HealthcareUNITED STATESUSNorth AmericaRESMEDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27RMD
SPYREGN2026-09-030.1263671220959.00HealthcareUNITED STATESUSNorth AmericaREGENERON PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27REGN
SPYPODD2026-09-030.015636846218.00HealthcareUNITED STATESUSNorth AmericaINSULETstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PODD
SPYPFE2026-09-030.24572969510635.00HealthcareUNITED STATESUSNorth AmericaPFIZERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PFE
SPYMTD2026-09-030.040867245569.00HealthcareUNITED STATESUSNorth AmericaMETTLER TOLEDO INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MTD
SPYMRNA2026-09-030.0788264315205.00HealthcareUNITED STATESUSNorth AmericaMODERNAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MRNA
SPYMRK2026-09-030.56353230146848.00HealthcareUNITED STATESUSNorth AmericaMERCK & COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MRK
SPYMDT2026-09-030.17883115654176.00HealthcareIRELANDIEEuropeMEDTRONICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MDT
SPYMCK2026-09-030.1657481466043.00HealthcareUNITED STATESUSNorth AmericaMCKESSONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MCK
SPYLLY2026-09-031.3737909654944.00HealthcareUNITED STATESUSNorth AmericaELI LILLYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LLY
SPYLH2026-09-030.0407701002299.00HealthcareUNITED STATESUSNorth AmericaLABORATORY CORP OF AMERICA HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LH
SPYJNJ2026-09-031.00369529378082.00HealthcareUNITED STATESUSNorth AmericaJOHNSON & JOHNSONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27JNJ
SPYISRG2026-09-030.1959984319040.00HealthcareUNITED STATESUSNorth AmericaINTUITIVE SURGICALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ISRG
SPYIQV2026-09-030.0679742039464.00HealthcareUNITED STATESUSNorth AmericaIQVIA HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IQV
SPYINCY2026-09-030.0319792036084.00HealthcareUNITED STATESUSNorth AmericaINCYTEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27INCY
SPYIDXX2026-09-030.062611964033.00HealthcareUNITED STATESUSNorth AmericaIDEXX LABORATORIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IDXX
SPYHUM2026-09-030.0731931467321.00HealthcareUNITED STATESUSNorth AmericaHUMANAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HUM
SPYHSIC2026-09-030.0131891182975.00HealthcareUNITED STATESUSNorth AmericaHENRY SCHEINstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HSIC
SPYHCA2026-09-030.0952681897360.00HealthcareUNITED STATESUSNorth AmericaHCA HEALTHCAREstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HCA
SPYGILD2026-09-030.28109615148958.00HealthcareUNITED STATESUSNorth AmericaGILEAD SCIENCESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GILD
SPYGEHC2026-09-030.0475525558357.00HealthcareUNITED STATESUSNorth AmericaGE HEALTHCARE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GEHC
SPYEW2026-09-030.0775077035557.00HealthcareUNITED STATESUSNorth AmericaEDWARDS LIFESCIENCESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EW
SPYELV2026-09-030.1350502653470.00HealthcareUNITED STATESUSNorth AmericaELEVANCE HEALTHstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ELV
SPYDXCM2026-09-030.0517274699096.00HealthcareUNITED STATESUSNorth AmericaDEXCOMstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DXCM
SPYDVA2026-09-030.008748392471.00HealthcareUNITED STATESUSNorth AmericaDAVITAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DVA
SPYDHR2026-09-030.1988997681128.00HealthcareUNITED STATESUSNorth AmericaDANAHERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DHR
SPYDGX2026-09-030.0397281352403.00HealthcareUNITED STATESUSNorth AmericaQUEST DIAGNOSTICSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DGX
SPYCVS2026-09-030.18556015558035.00HealthcareUNITED STATESUSNorth AmericaCVS stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CVS
SPYCRL2026-09-030.021185588550.00HealthcareUNITED STATESUSNorth AmericaCHARLES RIVER LABORATORIES INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CRL
SPYCOR2026-09-030.0983742377420.00Healthcare———CENCORA INCstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27COR
SPYCOO2026-09-030.0206592383396.00HealthcareUNITED STATESUSNorth AmericaCOOPER COMPANIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27COO
SPYCNC2026-09-030.0477735723734.00HealthcareUNITED STATESUSNorth AmericaCENTENEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CNC
SPYCI2026-09-030.1135233231920.00HealthcareUNITED STATESUSNorth AmericaCIGNA GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CI
SPYCAH2026-09-030.0873022861842.00HealthcareUNITED STATESUSNorth AmericaCARDINAL HEALTHstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CAH
SPYBSX2026-09-030.10462218160470.00HealthcareUNITED STATESUSNorth AmericaBOSTON SCIENTIFICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BSX