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:sector = Utilities×sorted by as_of ↑×

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
XLUCEG2026-07-315.8630005279029.00UtilitiesUNITED STATESUSNorth AmericaCONSTELLATION ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CEG
XLUCEG2026-06-305.6127935222837.00UtilitiesUNITED STATESUSNorth AmericaCONSTELLATION ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CEG
XLUAWK2026-07-311.9170003224735.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN WATER WORKS COMPANYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AWK
XLUAWK2026-06-301.8164573190522.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN WATER WORKS COMPANYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AWK
XLUATO2026-07-312.1090002756422.00UtilitiesUNITED STATESUSNorth AmericaATMOS ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ATO
XLUATO2026-06-302.0327172727055.00UtilitiesUNITED STATESUSNorth AmericaATMOS ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ATO
XLUAES2026-07-310.75100011776808.00UtilitiesUNITED STATESUSNorth AmericaAESstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AES
XLUAES2026-06-300.73907411651466.00UtilitiesUNITED STATESUSNorth AmericaAESstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AES
XLUAEP2026-07-315.0060008985094.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN ELECTRIC POWER COstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AEP
XLUAEP2026-06-305.2621648889413.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN ELECTRIC POWER COstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AEP
XLUAEE2026-07-312.1640004570184.00UtilitiesUNITED STATESUSNorth AmericaAMERENstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AEE
XLUAEE2026-06-302.2115264521541.00UtilitiesUNITED STATESUSNorth AmericaAMERENstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AEE
XLIGEV2026-06-305.4577791577783.00Utilities———GE Vernovastocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GEV
SPYXEL2026-09-030.0714527627845.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XEL
SPYWEC2026-09-030.0521093980029.00UtilitiesUNITED STATESUSNorth AmericaWEC ENERGY GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WEC
SPYVST2026-09-030.0685373872890.00UtilitiesUNITED STATESUSNorth AmericaVISTRAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VST
SPYSRE2026-09-030.0828857987278.00UtilitiesUNITED STATESUSNorth AmericaSEMPRAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SRE
SPYSO2026-09-030.14969613742998.00UtilitiesUNITED STATESUSNorth AmericaSOUTHERNstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SO
SPYPPL2026-09-030.0396039192500.00UtilitiesUNITED STATESUSNorth AmericaPPLstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PPL
SPYPNW2026-09-030.0178161481559.00UtilitiesUNITED STATESUSNorth AmericaPINNACLE WEST CAPITALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PNW
SPYPEG2026-09-030.0551466088821.00UtilitiesUNITED STATESUSNorth AmericaPUBLIC SERVICE ENTERPRISE GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PEG
SPYPCG2026-09-030.04609126907454.00UtilitiesUNITED STATESUSNorth AmericaPG&Estocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PCG
SPYNRG2026-09-030.0353742577672.00UtilitiesUNITED STATESUSNorth AmericaNRG ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NRG
SPYNI2026-09-030.0298615841573.00UtilitiesUNITED STATESUSNorth AmericaNISOURCEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NI
SPYNEE2026-09-030.26245925445431.00UtilitiesUNITED STATESUSNorth AmericaNEXTERA ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NEE
SPYLNT2026-09-030.0261843138050.00UtilitiesUNITED STATESUSNorth AmericaALLIANT ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LNT
SPYGEV2026-09-030.3791853281037.00Utilities———GE Vernovastocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GEV
SPYFE2026-09-030.0367146360660.00UtilitiesUNITED STATESUSNorth AmericaFIRSTENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27FE
SPYEXC2026-09-030.06766812502038.00UtilitiesUNITED STATESUSNorth AmericaEXELONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EXC
SPYEVRG2026-09-030.0283202817003.00UtilitiesUNITED STATESUSNorth AmericaEVERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EVRG
SPYETR2026-09-030.0739865594350.00UtilitiesUNITED STATESUSNorth AmericaENTERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ETR
SPYES2026-09-030.0402404588472.00UtilitiesUNITED STATESUSNorth AmericaEVERSOURCE ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ES
SPYEIX2026-09-030.0324804701560.00UtilitiesUNITED STATESUSNorth AmericaEDISON INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EIX
SPYED2026-09-030.0600944503423.00UtilitiesUNITED STATESUSNorth AmericaCONSOLIDATED EDISONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ED
SPYDUK2026-09-030.1415559502614.00UtilitiesUNITED STATESUSNorth AmericaDUKE ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DUK
SPYDTE2026-09-030.0427542541961.00UtilitiesUNITED STATESUSNorth AmericaDTE ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DTE
SPYD2026-09-030.08718910746029.00UtilitiesUNITED STATESUSNorth AmericaDOMINION ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27D
SPYCNP2026-09-030.0391967989846.00UtilitiesUNITED STATESUSNorth AmericaCENTERPOINT ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CNP
SPYCMS2026-09-030.0316213757043.00UtilitiesUNITED STATESUSNorth AmericaCMS ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CMS
SPYCEG2026-09-030.1366123905763.00UtilitiesUNITED STATESUSNorth AmericaCONSTELLATION ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CEG
SPYAWK2026-09-030.0412462385829.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN WATER WORKS COMPANYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AWK
SPYATO2026-09-030.0420992028673.00UtilitiesUNITED STATESUSNorth AmericaATMOS ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ATO
SPYAES2026-09-030.0158028713370.00UtilitiesUNITED STATESUSNorth AmericaAESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AES
SPYAEP2026-09-030.1017296647836.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN ELECTRIC POWER COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AEP
SPYAEE2026-09-030.0441383380362.00UtilitiesUNITED STATESUSNorth AmericaAMERENstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AEE
QQQXEL2026-09-030.20943013432613.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XEL
QQQEXC2026-09-030.20022622016094.00UtilitiesUNITED STATESUSNorth AmericaEXELONstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EXC
QQQCEG2026-09-030.4531017771399.00UtilitiesUNITED STATESUSNorth AmericaCONSTELLATION ENERGYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CEG
QQQAEP2026-09-030.30043611706995.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN ELECTRIC POWER COstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AEP
IWMZWS2026-09-050.2300003866070.00UtilitiesUNITED STATESUSNorth AmericaZURN ELKAY WATER SOLUTIONSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ZWS