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

Sources in this table

as_ofto
column equals (exact text)
sort
chart against as_of
reset
active:sorted by as_of ↑×

as_of leads no index, so this sort reads every matching row and keeps only the top 200 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
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
XLVALGN2026-08-020.196000473737.00HealthcareUNITED STATESUSNorth AmericaALIGN TECHNOLOGYstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ALGN
XLVALGN2026-06-300.196170472209.00HealthcareUNITED STATESUSNorth AmericaALIGN TECHNOLOGYstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ALGN
XLVABT2026-08-023.12100012389353.00HealthcareUNITED STATESUSNorth AmericaABBOTT LABORATORIESstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ABT
XLVABT2026-06-302.76003812348978.00HealthcareUNITED STATESUSNorth AmericaABBOTT LABORATORIESstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ABT
XLVABBV2026-08-027.71600012567115.00HealthcareUNITED STATESUSNorth AmericaABBVIEstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ABBV
XLVABBV2026-06-307.76396412526178.00HealthcareUNITED STATESUSNorth AmericaABBVIEstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ABBV
XLVA2026-08-020.6650002010121.00HealthcareUNITED STATESUSNorth AmericaAGILENT TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27A
XLVA2026-06-300.6555282003593.00HealthcareUNITED STATESUSNorth AmericaAGILENT TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27A
XLV$CASH:US DOLLAR2026-06-30-0.097290—————US DOLLARcash———uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27—
XLV$CASH:SSI US GOV MONEY MARKET CLASS2026-06-300.250755—————SSI US GOV MONEY MARKET CLASScash———uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27—
XLUXEL2026-07-313.49500010308895.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XEL
XLUXEL2026-06-303.54364810199095.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XEL
XLUWEC2026-07-312.5770005378843.00UtilitiesUNITED STATESUSNorth AmericaWEC ENERGY GROUPstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WEC
XLUWEC2026-06-302.6886885321521.00UtilitiesUNITED STATESUSNorth AmericaWEC ENERGY GROUPstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WEC
XLUVST2026-07-313.2180005233954.00UtilitiesUNITED STATESUSNorth AmericaVISTRAstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VST
XLUVST2026-06-303.5541965178246.00UtilitiesUNITED STATESUSNorth AmericaVISTRAstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VST
XLUSRE2026-07-314.12800010794718.00UtilitiesUNITED STATESUSNorth AmericaSEMPRAstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SRE
XLUSRE2026-06-304.28412310679771.00UtilitiesUNITED STATESUSNorth AmericaSEMPRAstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SRE
XLUSO2026-07-317.69800018615763.00UtilitiesUNITED STATESUSNorth AmericaSOUTHERNstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SO
XLUSO2026-06-307.62714918417534.00UtilitiesUNITED STATESUSNorth AmericaSOUTHERNstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SO
XLUPPL2026-07-311.91000012423943.00UtilitiesUNITED STATESUSNorth AmericaPPLstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PPL
XLUPPL2026-06-301.93326412291738.00UtilitiesUNITED STATESUSNorth AmericaPPLstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PPL
XLUPNW2026-07-310.8810002001273.00UtilitiesUNITED STATESUSNorth AmericaPINNACLE WEST CAPITALstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PNW
XLUPNW2026-06-300.9166341979879.00UtilitiesUNITED STATESUSNorth AmericaPINNACLE WEST CAPITALstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PNW
XLUPEG2026-07-312.7550008229000.00UtilitiesUNITED STATESUSNorth AmericaPUBLIC SERVICE ENTERPRISE GROUPstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PEG
XLUPEG2026-06-302.8590388141502.00UtilitiesUNITED STATESUSNorth AmericaPUBLIC SERVICE ENTERPRISE GROUPstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PEG
XLUPCG2026-07-312.77300036366521.00UtilitiesUNITED STATESUSNorth AmericaPG&Estocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PCG
XLUPCG2026-06-302.61849635979284.00UtilitiesUNITED STATESUSNorth AmericaPG&Estocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PCG
XLUNRG2026-07-311.8640003484097.00UtilitiesUNITED STATESUSNorth AmericaNRG ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NRG
XLUNRG2026-06-302.1784793447059.00UtilitiesUNITED STATESUSNorth AmericaNRG ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NRG
XLUNI2026-07-311.5270007917240.00UtilitiesUNITED STATESUSNorth AmericaNISOURCEstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NI
XLUNI2026-06-301.6115757832972.00UtilitiesUNITED STATESUSNorth AmericaNISOURCEstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NI
XLUNEE2026-07-3113.11600034436360.00UtilitiesUNITED STATESUSNorth AmericaNEXTERA ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NEE
XLUNEE2026-06-3012.93863634069753.00UtilitiesUNITED STATESUSNorth AmericaNEXTERA ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NEE
XLULNT2026-07-311.3220004265062.00UtilitiesUNITED STATESUSNorth AmericaALLIANT ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LNT
XLULNT2026-06-301.3928914219648.00UtilitiesUNITED STATESUSNorth AmericaALLIANT ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LNT
XLUFE2026-07-311.8180008596744.00UtilitiesUNITED STATESUSNorth AmericaFIRSTENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27FE
XLUFE2026-06-301.7495158505210.00UtilitiesUNITED STATESUSNorth AmericaFIRSTENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27FE
XLUEXC2026-07-313.42100016896822.00UtilitiesUNITED STATESUSNorth AmericaEXELONstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EXC
XLUEXC2026-06-303.37210416716883.00UtilitiesUNITED STATESUSNorth AmericaEXELONstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EXC
XLUEVRG2026-07-311.3770003806624.00UtilitiesUNITED STATESUSNorth AmericaEVERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EVRG