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 = XLU×sector = Utilities×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
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
XLUEVRG2026-06-301.4083953766055.00UtilitiesUNITED STATESUSNorth AmericaEVERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EVRG
XLUETR2026-07-313.5090007561300.00UtilitiesUNITED STATESUSNorth AmericaENTERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ETR
XLUETR2026-06-303.7178537480833.00UtilitiesUNITED STATESUSNorth AmericaENTERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ETR
XLUES2026-07-311.9990006210429.00UtilitiesUNITED STATESUSNorth AmericaEVERSOURCE ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ES
XLUES2026-06-301.9213476144327.00UtilitiesUNITED STATESUSNorth AmericaEVERSOURCE ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ES
XLUEIX2026-07-312.1510006354322.00UtilitiesUNITED STATESUSNorth AmericaEDISON INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EIX
XLUEIX2026-06-302.0251696286706.00UtilitiesUNITED STATESUSNorth AmericaEDISON INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EIX
XLUED2026-07-312.9410006085707.00UtilitiesUNITED STATESUSNorth AmericaCONSOLIDATED EDISONstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ED
XLUED2026-06-302.8821006020917.00UtilitiesUNITED STATESUSNorth AmericaCONSOLIDATED EDISONstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ED
XLUDUK2026-07-317.15500012873846.00UtilitiesUNITED STATESUSNorth AmericaDUKE ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DUK
XLUDUK2026-06-306.97587612736797.00UtilitiesUNITED STATESUSNorth AmericaDUKE ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DUK
XLUDTE2026-07-312.1230003435294.00UtilitiesUNITED STATESUSNorth AmericaDTE ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DTE
XLUDTE2026-06-302.2406853398661.00UtilitiesUNITED STATESUSNorth AmericaDTE ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DTE
XLUD2026-07-314.41100014522871.00UtilitiesUNITED STATESUSNorth AmericaDOMINION ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27D
XLUD2026-06-304.24558814368362.00UtilitiesUNITED STATESUSNorth AmericaDOMINION ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27D
XLUCNP2026-07-311.99700010802642.00UtilitiesUNITED STATESUSNorth AmericaCENTERPOINT ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CNP
XLUCNP2026-06-302.03657610687594.00UtilitiesUNITED STATESUSNorth AmericaCENTERPOINT ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CNP
XLUCMS2026-07-311.6330005101371.00UtilitiesUNITED STATESUSNorth AmericaCMS ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CMS
XLUCMS2026-06-301.6706095047076.00UtilitiesUNITED STATESUSNorth AmericaCMS ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CMS