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 = SPY×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
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
SPYXEL2026-09-040.0711287616654.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30XEL
SPYWEC2026-09-040.0519253974170.00UtilitiesUNITED STATESUSNorth AmericaWEC ENERGY GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30WEC
SPYVST2026-09-040.0712073867186.00UtilitiesUNITED STATESUSNorth AmericaVISTRAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30VST
SPYSRE2026-09-040.0826647975560.00UtilitiesUNITED STATESUSNorth AmericaSEMPRAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30SRE
SPYSO2026-09-040.14911913722755.00UtilitiesUNITED STATESUSNorth AmericaSOUTHERNstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30SO
SPYPPL2026-09-040.0397469178984.00UtilitiesUNITED STATESUSNorth AmericaPPLstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30PPL
SPYPNW2026-09-040.0177931479389.00UtilitiesUNITED STATESUSNorth AmericaPINNACLE WEST CAPITALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30PNW
SPYPEG2026-09-040.0552626079862.00UtilitiesUNITED STATESUSNorth AmericaPUBLIC SERVICE ENTERPRISE GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30PEG
SPYPCG2026-09-040.04738526867929.00UtilitiesUNITED STATESUSNorth AmericaPG&Estocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30PCG
SPYNRG2026-09-040.0377812573890.00UtilitiesUNITED STATESUSNorth AmericaNRG ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30NRG
SPYNI2026-09-040.0297755832955.00UtilitiesUNITED STATESUSNorth AmericaNISOURCEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30NI
SPYNEE2026-09-040.26143325408014.00UtilitiesUNITED STATESUSNorth AmericaNEXTERA ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30NEE
SPYLNT2026-09-040.0262663133400.00UtilitiesUNITED STATESUSNorth AmericaALLIANT ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30LNT
SPYGEV2026-09-040.3805983276201.00Utilities———GE Vernovastocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30GEV
SPYFE2026-09-040.0366356351329.00UtilitiesUNITED STATESUSNorth AmericaFIRSTENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30FE
SPYEXC2026-09-040.06718912483686.00UtilitiesUNITED STATESUSNorth AmericaEXELONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30EXC
SPYEVRG2026-09-040.0282872812880.00UtilitiesUNITED STATESUSNorth AmericaEVERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30EVRG
SPYETR2026-09-040.0739025586135.00UtilitiesUNITED STATESUSNorth AmericaENTERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30ETR