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×country_name = UNITED STATES×sector = Healthcare×

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-160.0470435014210.00HealthcareUNITED STATESUSNorth AmericaZOETISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ZTS
SPYZBH2026-09-160.0287802313850.00HealthcareUNITED STATESUSNorth AmericaZIMMER BIOMET HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ZBH
SPYWST2026-09-160.039312844954.00HealthcareUNITED STATESUSNorth AmericaWEST PHARMACEUTICAL SERVICESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WST
SPYWAT2026-09-160.0630981172755.00HealthcareUNITED STATESUSNorth AmericaWATERSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WAT
SPYVTRS2026-09-160.03043513913808.00HealthcareUNITED STATESUSNorth AmericaVIATRISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VTRS
SPYVRTX2026-09-160.1998373029484.00HealthcareUNITED STATESUSNorth AmericaVERTEX PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VRTX
SPYVEEV2026-09-160.0611361795734.00HealthcareUNITED STATESUSNorth AmericaVEEVA SYSTEMSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VEEV
SPYUNH2026-09-160.52314910847357.00HealthcareUNITED STATESUSNorth AmericaUNITEDHEALTH GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UNH
SPYUHS2026-09-160.014845637425.00HealthcareUNITED STATESUSNorth AmericaUNIVERSAL HEALTH SERVICESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UHS
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
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
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
SPYRMD2026-09-160.0508921734893.00HealthcareUNITED STATESUSNorth AmericaRESMEDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RMD
SPYREGN2026-09-160.1189801195149.00HealthcareUNITED STATESUSNorth AmericaREGENERON PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30REGN
SPYPODD2026-09-160.014969828418.00HealthcareUNITED STATESUSNorth AmericaINSULETstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PODD
SPYPFE2026-09-160.24013168042135.00HealthcareUNITED STATESUSNorth AmericaPFIZERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PFE
SPYMTD2026-09-160.042566240229.00HealthcareUNITED STATESUSNorth AmericaMETTLER TOLEDO INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MTD
SPYMRNA2026-09-160.0790604224425.00HealthcareUNITED STATESUSNorth AmericaMODERNAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MRNA
SPYMRK2026-09-160.54959729510498.00HealthcareUNITED STATESUSNorth AmericaMERCK & COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MRK
SPYMCK2026-09-160.1636271434893.00HealthcareUNITED STATESUSNorth AmericaMCKESSONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MCK
SPYLLY2026-09-161.3820619451134.00HealthcareUNITED STATESUSNorth AmericaELI LILLYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LLY
SPYLH2026-09-160.040930981384.00HealthcareUNITED STATESUSNorth AmericaLABORATORY CORP OF AMERICA HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LH
SPYJNJ2026-09-160.98785028757752.00HealthcareUNITED STATESUSNorth AmericaJOHNSON & JOHNSONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30JNJ
SPYISRG2026-09-160.2077204227815.00HealthcareUNITED STATESUSNorth AmericaINTUITIVE SURGICALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ISRG
SPYIQV2026-09-160.0689691996299.00HealthcareUNITED STATESUSNorth AmericaIQVIA HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30IQV
SPYINCY2026-09-160.0319521992919.00HealthcareUNITED STATESUSNorth AmericaINCYTEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30INCY
SPYIDXX2026-09-160.062285943563.00HealthcareUNITED STATESUSNorth AmericaIDEXX LABORATORIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30IDXX
SPYHUM2026-09-160.0710101436171.00HealthcareUNITED STATESUSNorth AmericaHUMANAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HUM
SPYHSIC2026-09-160.0129141158055.00HealthcareUNITED STATESUSNorth AmericaHENRY SCHEINstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HSIC
SPYHCA2026-09-160.1027441857310.00HealthcareUNITED STATESUSNorth AmericaHCA HEALTHCAREstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HCA
SPYGILD2026-09-160.28145114829003.00HealthcareUNITED STATESUSNorth AmericaGILEAD SCIENCESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GILD
SPYGEHC2026-09-160.0444005441322.00HealthcareUNITED STATESUSNorth AmericaGE HEALTHCARE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GEHC
SPYEW2026-09-160.0790276887372.00HealthcareUNITED STATESUSNorth AmericaEDWARDS LIFESCIENCESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30EW
SPYELV2026-09-160.1377202597400.00HealthcareUNITED STATESUSNorth AmericaELEVANCE HEALTHstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ELV
SPYDXCM2026-09-160.0516334599861.00HealthcareUNITED STATESUSNorth AmericaDEXCOMstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DXCM
SPYDVA2026-09-160.009568384016.00HealthcareUNITED STATESUSNorth AmericaDAVITAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DVA
SPYDHR2026-09-160.2013397518703.00HealthcareUNITED STATESUSNorth AmericaDANAHERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DHR
SPYDGX2026-09-160.0420411323923.00HealthcareUNITED STATESUSNorth AmericaQUEST DIAGNOSTICSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DGX
SPYCVS2026-09-160.17951915229180.00HealthcareUNITED STATESUSNorth AmericaCVS stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CVS
SPYCRL2026-09-160.020243576090.00HealthcareUNITED STATESUSNorth AmericaCHARLES RIVER LABORATORIES INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CRL
SPYCOO2026-09-160.0163752333111.00HealthcareUNITED STATESUSNorth AmericaCOOPER COMPANIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30COO
SPYCNC2026-09-160.0475315602694.00HealthcareUNITED STATESUSNorth AmericaCENTENEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CNC
SPYCI2026-09-160.1140353163835.00HealthcareUNITED STATESUSNorth AmericaCIGNA GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CI
SPYCAH2026-09-160.0837202801322.00HealthcareUNITED STATESUSNorth AmericaCARDINAL HEALTHstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CAH
SPYBSX2026-09-160.10032317777325.00HealthcareUNITED STATESUSNorth AmericaBOSTON SCIENTIFICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BSX
SPYBMY2026-09-160.19924224375516.00HealthcareUNITED STATESUSNorth AmericaBRISTOL MYERS SQUIBBstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BMY
SPYBIIB2026-09-160.0491041768795.00HealthcareUNITED STATESUSNorth AmericaBIOGENstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BIIB
SPYBDX2026-09-160.0770243295669.00HealthcareUNITED STATESUSNorth AmericaBECTON DICKINSON &stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BDX
SPYBAX2026-09-160.0187686206343.00HealthcareUNITED STATESUSNorth AmericaBAXTER INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BAX
SPYAMGN2026-09-160.3119356449158.00HealthcareUNITED STATESUSNorth AmericaAMGENstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AMGN