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 = IWM×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_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zonevendor_tickertext
IWMZWS2026-09-180.2300003897354.00UtilitiesUNITED STATESUSNorth AmericaZURN ELKAY WATER SOLUTIONSstocktrueuw_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 RENEWABLESstocktrueuw_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 AmericaUNITILstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UTL
IWMTXNM2026-09-180.2100002817810.00UtilitiesTXNM Energy, Inc.stocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TXNM
IWMSWX2026-09-180.2100001927175.00UtilitiesUNITED STATESUSNorth AmericaSOUTHWEST GAS HOLDINGSstocktrueuw_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 AmericaSPIREstocktrueuw_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 ELECTRICstocktrueuw_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 TAILstocktrueuw_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 TECHNOLOGIESstocktrueuw_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 GASstocktrueuw_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 HOLDINGstocktrueuw_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 AmericaNORTHWESTERNstocktrueuw_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 RESOURCESstocktrueuw_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 WATERstocktrueuw_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 ENERGYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MGEE
IWMHTO2026-09-180.070000915349.00UtilitiesH2O Americastocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HTO
IWMHE2026-09-180.0600004283178.00UtilitiesUNITED STATESUSNorth AmericaHAWAIIAN ELECTRIC INDUSTRIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HE
IWMCWT2026-09-180.1000001563955.00UtilitiesUNITED STATESUSNorth AmericaCALIFORNIA WATER SERVICE GROUPstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CWT
IWMCTRI2026-09-180.0600002284722.00UtilitiesCENTURI HOLDINGS INCstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CTRI
IWMCPK2026-09-180.100000619192.00UtilitiesUNITED STATESUSNorth AmericaCHESAPEAKE UTILITIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CPK
IWMBKH2026-09-180.1800002030706.00UtilitiesUNITED STATESUSNorth AmericaBLACK HILLSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BKH
IWMBIPC2026-09-180.1500003258805.00UtilitiesBROOKFIELD INFRASTRUCTUREstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BIPC
IWMAWR2026-09-180.1100001026283.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN STATES WATERstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AWR
IWMAVA2026-09-180.1000002188104.00UtilitiesUNITED STATESUSNorth AmericaAVISTAstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AVA
IWMZWS2026-09-170.2300003979830.00UtilitiesUNITED STATESUSNorth AmericaZURN ELKAY WATER SOLUTIONSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30ZWS
IWMVIA2026-09-170.0500001392590.00UtilitiesUNITED STATESUSNorth AmericaVIA RENEWABLESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30VIA
IWMUTL2026-09-170.030000463895.00UtilitiesUNITED STATESUSNorth AmericaUNITILstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30UTL
IWMTXNM2026-09-170.2100002877434.00UtilitiesTXNM Energy, Inc.stocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30TXNM
IWMSWX2026-09-170.2100001967891.00UtilitiesUNITED STATESUSNorth AmericaSOUTHWEST GAS HOLDINGSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SWX
IWMSR2026-09-170.1600001565349.00UtilitiesUNITED STATESUSNorth AmericaSPIREstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SR
IWMPOR2026-09-170.1900003165839.00UtilitiesUNITED STATESUSNorth AmericaPORTLAND GENERAL ELECTRICstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30POR
IWMOTTR2026-09-170.1100001034504.00UtilitiesUNITED STATESUSNorth AmericaOTTER TAILstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30OTTR
IWMORA2026-09-170.1900001656939.00UtilitiesUNITED STATESUSNorth AmericaORMAT TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30ORA
IWMOGS2026-09-170.1600001696728.00UtilitiesUNITED STATESUSNorth AmericaONE GASstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30OGS
IWMNWN2026-09-170.0700001134347.00UtilitiesUNITED STATESUSNorth AmericaNORTHWEST NATURAL HOLDINGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30NWN
IWMNWE2026-09-170.1400001665314.00UtilitiesUNITED STATESUSNorth AmericaNORTHWESTERNstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30NWE
IWMNJR2026-09-170.1800002733253.00UtilitiesUNITED STATESUSNorth AmericaNEW JERSEY RESOURCESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30NJR
IWMMSEX2026-09-170.030000484139.00UtilitiesUNITED STATESUSNorth AmericaMIDDLESEX WATERstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MSEX
IWMMGEE2026-09-170.090000980053.00UtilitiesUNITED STATESUSNorth AmericaMGE ENERGYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MGEE
IWMHTO2026-09-170.070000934721.00UtilitiesH2O Americastocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30HTO
IWMHE2026-09-170.0600004373774.00UtilitiesUNITED STATESUSNorth AmericaHAWAIIAN ELECTRIC INDUSTRIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30HE
IWMCWT2026-09-170.1000001597015.00UtilitiesUNITED STATESUSNorth AmericaCALIFORNIA WATER SERVICE GROUPstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CWT
IWMCTRI2026-09-170.0600002333094.00UtilitiesCENTURI HOLDINGS INCstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CTRI
IWMCPK2026-09-170.100000632300.00UtilitiesUNITED STATESUSNorth AmericaCHESAPEAKE UTILITIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CPK
IWMBKH2026-09-170.1800002073626.00UtilitiesUNITED STATESUSNorth AmericaBLACK HILLSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30BKH
IWMBIPC2026-09-170.1500003327709.00UtilitiesBROOKFIELD INFRASTRUCTUREstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30BIPC
IWMAWR2026-09-170.1100001047975.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN STATES WATERstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30AWR
IWMAVA2026-09-170.1000002234388.00UtilitiesUNITED STATESUSNorth AmericaAVISTAstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30AVA
IWMZWS2026-09-160.2300003930771.00UtilitiesUNITED STATESUSNorth AmericaZURN ELKAY WATER SOLUTIONSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30ZWS
IWMVIA2026-09-160.0500001375409.00UtilitiesUNITED STATESUSNorth AmericaVIA RENEWABLESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30VIA