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:country_code = US×sector = Utilities×source = uw_etf_holdings×

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
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
QQQXEL2026-09-160.20504813296476.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30XEL
QQQEXC2026-09-160.19453321787593.00UtilitiesUNITED STATESUSNorth AmericaEXELONstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30EXC
QQQCEG2026-09-160.4200447693068.00UtilitiesUNITED STATESUSNorth AmericaCONSTELLATION ENERGYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CEG
QQQAEP2026-09-160.29425711589028.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN ELECTRIC POWER COstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AEP
IWMZWS2026-09-180.2300003897354.00UtilitiesUNITED STATESUSNorth AmericaZURN ELKAY WATER SOLUTIONSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ZWS
IWMVIA2026-09-180.0500001363706.00UtilitiesUNITED STATESUSNorth AmericaVIA RENEWABLESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VIA
IWMUTL2026-09-180.030000454267.00UtilitiesUNITED STATESUSNorth AmericaUNITILstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UTL
IWMSWX2026-09-180.2100001927175.00UtilitiesUNITED STATESUSNorth AmericaSOUTHWEST GAS HOLDINGSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SWX
IWMSR2026-09-180.1600001532869.00UtilitiesUNITED STATESUSNorth AmericaSPIREstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SR
IWMPOR2026-09-180.1900003100299.00UtilitiesUNITED STATESUSNorth AmericaPORTLAND GENERAL ELECTRICstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30POR
IWMOTTR2026-09-180.1200001013044.00UtilitiesUNITED STATESUSNorth AmericaOTTER TAILstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30OTTR
IWMORA2026-09-180.1900001622603.00UtilitiesUNITED STATESUSNorth AmericaORMAT TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ORA
IWMOGS2026-09-180.1600001661580.00UtilitiesUNITED STATESUSNorth AmericaONE GASstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30OGS
IWMNWN2026-09-180.0700001110799.00UtilitiesUNITED STATESUSNorth AmericaNORTHWEST NATURAL HOLDINGstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NWN
IWMNWE2026-09-180.1400001630862.00UtilitiesUNITED STATESUSNorth AmericaNORTHWESTERNstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NWE
IWMNJR2026-09-180.1800002676645.00UtilitiesUNITED STATESUSNorth AmericaNEW JERSEY RESOURCESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NJR
IWMMSEX2026-09-180.030000474163.00UtilitiesUNITED STATESUSNorth AmericaMIDDLESEX WATERstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MSEX
IWMMGEE2026-09-180.090000959753.00UtilitiesUNITED STATESUSNorth AmericaMGE ENERGYstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MGEE
IWMHE2026-09-180.0600004283178.00UtilitiesUNITED STATESUSNorth AmericaHAWAIIAN ELECTRIC INDUSTRIESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HE