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×

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-160.0697787467200.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30XEL
SPYWEC2026-09-160.0517633895924.00UtilitiesUNITED STATESUSNorth AmericaWEC ENERGY GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WEC
SPYVST2026-09-160.0684013791010.00UtilitiesUNITED STATESUSNorth AmericaVISTRAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VST
SPYSRE2026-09-160.0821017819068.00UtilitiesUNITED STATESUSNorth AmericaSEMPRAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SRE
SPYSO2026-09-160.14908313452413.00UtilitiesUNITED STATESUSNorth AmericaSOUTHERNstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SO
SPYPPL2026-09-160.0386388998480.00UtilitiesUNITED STATESUSNorth AmericaPPLstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PPL
SPYPNW2026-09-160.0177071450409.00UtilitiesUNITED STATESUSNorth AmericaPINNACLE WEST CAPITALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PNW
SPYPEG2026-09-160.0539195960216.00UtilitiesUNITED STATESUSNorth AmericaPUBLIC SERVICE ENTERPRISE GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PEG
SPYPCG2026-09-160.04519326340079.00UtilitiesUNITED STATESUSNorth AmericaPG&Estocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PCG
SPYNRG2026-09-160.0348242523382.00UtilitiesUNITED STATESUSNorth AmericaNRG ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NRG
SPYNI2026-09-160.0298795717863.00UtilitiesUNITED STATESUSNorth AmericaNISOURCEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NI
SPYNEE2026-09-160.25728124908316.00UtilitiesUNITED STATESUSNorth AmericaNEXTERA ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NEE
SPYLNT2026-09-160.0260953071300.00UtilitiesUNITED STATESUSNorth AmericaALLIANT ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LNT
SPYGEV2026-09-160.3818363211617.00Utilities———GE Vernovastocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GEV
SPYFE2026-09-160.0363166226715.00UtilitiesUNITED STATESUSNorth AmericaFIRSTENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FE
SPYEXC2026-09-160.06675412238598.00UtilitiesUNITED STATESUSNorth AmericaEXELONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30EXC
SPYEVRG2026-09-160.0284932757818.00UtilitiesUNITED STATESUSNorth AmericaEVERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30EVRG
SPYETR2026-09-160.0720165476425.00UtilitiesUNITED STATESUSNorth AmericaENTERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ETR
SPYES2026-09-160.0391724491462.00UtilitiesUNITED STATESUSNorth AmericaEVERSOURCE ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ES
SPYEIX2026-09-160.0324204602325.00UtilitiesUNITED STATESUSNorth AmericaEDISON INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30EIX
SPYED2026-09-160.0597314408638.00UtilitiesUNITED STATESUSNorth AmericaCONSOLIDATED EDISONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ED
SPYDUK2026-09-160.1407809301919.00UtilitiesUNITED STATESUSNorth AmericaDUKE ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DUK
SPYDTE2026-09-160.0418022488561.00UtilitiesUNITED STATESUSNorth AmericaDTE ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DTE
SPYD2026-09-160.08586310519524.00UtilitiesUNITED STATESUSNorth AmericaDOMINION ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30D
SPYCNP2026-09-160.0385287821191.00UtilitiesUNITED STATESUSNorth AmericaCENTERPOINT ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CNP
SPYCMS2026-09-160.0311883677388.00UtilitiesUNITED STATESUSNorth AmericaCMS ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CMS
SPYCEG2026-09-160.1275303823438.00UtilitiesUNITED STATESUSNorth AmericaCONSTELLATION ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CEG
SPYAWK2026-09-160.0413502335544.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN WATER WORKS COMPANYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AWK
SPYATO2026-09-160.0413281985508.00UtilitiesUNITED STATESUSNorth AmericaATMOS ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ATO
SPYAES2026-09-160.0162358529585.00UtilitiesUNITED STATESUSNorth AmericaAESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AES
SPYAEP2026-09-160.1009416507661.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN ELECTRIC POWER COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AEP
SPYAEE2026-09-160.0438223309162.00UtilitiesUNITED STATESUSNorth AmericaAMERENstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AEE
SPYXEL2026-09-150.0692587514852.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30XEL
SPYWEC2026-09-150.0515993920872.00UtilitiesUNITED STATESUSNorth AmericaWEC ENERGY GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30WEC
SPYVST2026-09-150.0686523815298.00UtilitiesUNITED STATESUSNorth AmericaVISTRAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30VST
SPYSRE2026-09-150.0812367868964.00UtilitiesUNITED STATESUSNorth AmericaSEMPRAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SRE
SPYSO2026-09-150.14794313538609.00UtilitiesUNITED STATESUSNorth AmericaSOUTHERNstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SO
SPYPPL2026-09-150.0382609056032.00UtilitiesUNITED STATESUSNorth AmericaPPLstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PPL
SPYPNW2026-09-150.0176111459649.00UtilitiesUNITED STATESUSNorth AmericaPINNACLE WEST CAPITALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PNW
SPYPEG2026-09-150.0537045998364.00UtilitiesUNITED STATESUSNorth AmericaPUBLIC SERVICE ENTERPRISE GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PEG
SPYPCG2026-09-150.04431826508379.00UtilitiesUNITED STATESUSNorth AmericaPG&Estocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PCG
SPYNRG2026-09-150.0342202539486.00UtilitiesUNITED STATESUSNorth AmericaNRG ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30NRG
SPYNI2026-09-150.0296965754559.00UtilitiesUNITED STATESUSNorth AmericaNISOURCEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30NI
SPYNEE2026-09-150.25837325067640.00UtilitiesUNITED STATESUSNorth AmericaNEXTERA ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30NEE
SPYLNT2026-09-150.0259343091100.00UtilitiesUNITED STATESUSNorth AmericaALLIANT ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30LNT
SPYGEV2026-09-150.3627783232209.00Utilities———GE Vernovastocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30GEV
SPYFE2026-09-150.0361146266447.00UtilitiesUNITED STATESUSNorth AmericaFIRSTENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30FE
SPYEXC2026-09-150.06607412316742.00UtilitiesUNITED STATESUSNorth AmericaEXELONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30EXC
SPYEVRG2026-09-150.0282992775374.00UtilitiesUNITED STATESUSNorth AmericaEVERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30EVRG
SPYETR2026-09-150.0721175511405.00UtilitiesUNITED STATESUSNorth AmericaENTERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30ETR