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×endpoint = /api/etfs/XLV/holdings×

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
XLVINCY2026-08-020.3500001193651.00HealthcareUNITED STATESUSNorth AmericaINCYTEstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27INCY
XLVINCY2026-06-300.3322021189754.00HealthcareUNITED STATESUSNorth AmericaINCYTEstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27INCY
XLVIDXX2026-08-020.748000561078.00HealthcareUNITED STATESUSNorth AmericaIDEXX LABORATORIESstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IDXX
XLVIDXX2026-06-300.725180559257.00HealthcareUNITED STATESUSNorth AmericaIDEXX LABORATORIESstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IDXX
XLVHUM2026-08-020.747000853942.00HealthcareUNITED STATESUSNorth AmericaHUMANAstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HUM
XLVHUM2026-06-300.832800851186.00HealthcareUNITED STATESUSNorth AmericaHUMANAstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HUM
XLVHSIC2026-08-020.140000688715.00HealthcareUNITED STATESUSNorth AmericaHENRY SCHEINstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HSIC
XLVHSIC2026-06-300.141228686509.00HealthcareUNITED STATESUSNorth AmericaHENRY SCHEINstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HSIC
XLVHCA2026-08-021.0430001104555.00HealthcareUNITED STATESUSNorth AmericaHCA HEALTHCAREstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HCA
XLVHCA2026-06-301.0572821100940.00HealthcareUNITED STATESUSNorth AmericaHCA HEALTHCAREstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HCA
XLVGILD2026-08-022.7650008831248.00HealthcareUNITED STATESUSNorth AmericaGILEAD SCIENCESstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GILD
XLVGILD2026-06-302.7392448802472.00HealthcareUNITED STATESUSNorth AmericaGILEAD SCIENCESstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GILD
XLVGEHC2026-08-020.5400003235629.00HealthcareUNITED STATESUSNorth AmericaGE HEALTHCARE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GEHC
XLVGEHC2026-06-300.5084823225097.00HealthcareUNITED STATESUSNorth AmericaGE HEALTHCARE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GEHC
XLVEW2026-08-020.8490004095595.00HealthcareUNITED STATESUSNorth AmericaEDWARDS LIFESCIENCESstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EW
XLVEW2026-06-300.9095814082251.00HealthcareUNITED STATESUSNorth AmericaEDWARDS LIFESCIENCESstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EW
XLVELV2026-08-021.3870001544646.00HealthcareUNITED STATESUSNorth AmericaELEVANCE HEALTHstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ELV
XLVELV2026-06-301.4665801539617.00HealthcareUNITED STATESUSNorth AmericaELEVANCE HEALTHstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ELV
XLVDXCM2026-08-020.4880002744722.00HealthcareUNITED STATESUSNorth AmericaDEXCOMstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DXCM
XLVDXCM2026-06-300.4538292735707.00HealthcareUNITED STATESUSNorth AmericaDEXCOMstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DXCM
XLVDVA2026-08-020.130000228338.00HealthcareUNITED STATESUSNorth AmericaDAVITAstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DVA
XLVDVA2026-06-300.124713227580.00HealthcareUNITED STATESUSNorth AmericaDAVITAstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DVA
XLVDHR2026-08-022.0970004480576.00HealthcareUNITED STATESUSNorth AmericaDANAHERstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DHR
XLVDHR2026-06-302.0953144465957.00HealthcareUNITED STATESUSNorth AmericaDANAHERstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DHR
XLVDGX2026-08-020.440000787327.00HealthcareUNITED STATESUSNorth AmericaQUEST DIAGNOSTICSstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DGX
XLVDGX2026-06-300.409705784788.00HealthcareUNITED STATESUSNorth AmericaQUEST DIAGNOSTICSstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DGX
XLVCVS2026-08-022.2780009075559.00HealthcareUNITED STATESUSNorth AmericaCVS stocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CVS
XLVCVS2026-06-302.3050039045982.00HealthcareUNITED STATESUSNorth AmericaCVS stocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CVS
XLVCRL2026-08-020.192000342584.00HealthcareUNITED STATESUSNorth AmericaCHARLES RIVER LABORATORIES INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CRL
XLVCRL2026-06-300.190755341481.00HealthcareUNITED STATESUSNorth AmericaCHARLES RIVER LABORATORIES INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CRL
XLVCOO2026-08-020.2400001387782.00HealthcareUNITED STATESUSNorth AmericaCOOPER COMPANIESstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27COO
XLVCOO2026-06-300.2443311383290.00HealthcareUNITED STATESUSNorth AmericaCOOPER COMPANIESstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27COO
XLVCNC2026-08-020.4840003336700.00HealthcareUNITED STATESUSNorth AmericaCENTENEstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CNC
XLVCNC2026-06-300.5258483325888.00HealthcareUNITED STATESUSNorth AmericaCENTENEstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CNC
XLVCI2026-08-021.2910001881613.00HealthcareUNITED STATESUSNorth AmericaCIGNA GROUPstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CI
XLVCI2026-06-301.2735051875470.00HealthcareUNITED STATESUSNorth AmericaCIGNA GROUPstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CI
XLVCAH2026-08-020.9020001665924.00HealthcareUNITED STATESUSNorth AmericaCARDINAL HEALTHstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CAH
XLVCAH2026-06-300.9694851660452.00HealthcareUNITED STATESUSNorth AmericaCARDINAL HEALTHstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CAH
XLVBSX2026-08-021.16000010572366.00HealthcareUNITED STATESUSNorth AmericaBOSTON SCIENTIFICstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BSX
XLVBSX2026-06-301.10780810537914.00HealthcareUNITED STATESUSNorth AmericaBOSTON SCIENTIFICstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BSX
XLVBMY2026-08-022.24700014525163.00HealthcareUNITED STATESUSNorth AmericaBRISTOL MYERS SQUIBBstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BMY
XLVBMY2026-06-302.05475514477766.00HealthcareUNITED STATESUSNorth AmericaBRISTOL MYERS SQUIBBstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BMY
XLVBIIB2026-08-020.5210001050108.00HealthcareUNITED STATESUSNorth AmericaBIOGENstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BIIB
XLVBIIB2026-06-300.5570681046763.00HealthcareUNITED STATESUSNorth AmericaBIOGENstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BIIB
XLVBDX2026-08-020.7730001959913.00HealthcareUNITED STATESUSNorth AmericaBECTON DICKINSON &stocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BDX
XLVBDX2026-06-300.7281451953475.00HealthcareUNITED STATESUSNorth AmericaBECTON DICKINSON &stocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BDX
XLVBAX2026-08-020.2340003673646.00HealthcareUNITED STATESUSNorth AmericaBAXTER INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BAX
XLVBAX2026-06-300.1922853661624.00HealthcareUNITED STATESUSNorth AmericaBAXTER INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BAX
XLVAMGN2026-08-023.5500003838904.00HealthcareUNITED STATESUSNorth AmericaAMGENstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AMGN
XLVAMGN2026-06-303.4129263826389.00HealthcareUNITED STATESUSNorth AmericaAMGENstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AMGN