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 = Energy×

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_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zonevendor_tickertext
IWMNEXT2026-09-180.0400004332727.00EnergyUNITED STATESUSNorth AmericaNEXTDECADEstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NEXT
IWMNESR2026-09-180.0600001597019.00EnergyUNITED STATESUSNorth AmericaNATIONAL ENERGY SERVICES REUNITEDstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NESR
IWMNE2026-09-180.1900003329024.00EnergyUNITED STATESUSNorth AmericaNOBLE CORPstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NE
IWMNBR2026-09-180.040000376510.00EnergyBERMUDABMNorth AmericaNABORS INDUSTRIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NBR
IWMMUR2026-09-180.1800003598501.00EnergyUNITED STATESUSNorth AmericaMURPHY OILstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MUR
IWMMGY2026-09-180.2000006013535.00EnergyUNITED STATESUSNorth AmericaMAGNOLIA OIL & GASstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MGY
IWMLPG2026-09-180.070000978960.00EnergyUNITED STATESUSNorth AmericaDORIAN LPGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LPG
IWMLEU2026-09-180.090000482548.00EnergyUNITED STATESUSNorth AmericaCENTRUS ENERGYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LEU
IWMLBRT2026-09-180.1000004174160.00EnergyUNITED STATESUSNorth AmericaLIBERTY ENERGYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LBRT
IWMKOS2026-09-180.06000015390443.00EnergyUNITED STATESUSNorth AmericaKOSMOS ENERGYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KOS
IWMKNTK2026-09-180.0900001342457.00EnergyUNITED STATESUSNorth AmericaKINETIK HOLDINGSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KNTK
IWMKGS2026-09-180.2000002609517.00EnergyKODIAK GAS SERVICESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KGS
IWMINVX2026-09-180.0400001174744.00EnergyInnovex Internationalstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30INVX
IWMHP2026-09-180.1400002547051.00EnergyUNITED STATESUSNorth AmericaHELMERICH & PAYNEstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HP
IWMHOS2026-09-180.0400003563548.00EnergyHornbeck Offshore Servicesstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HOS
IWMGPOR2026-09-180.090000412391.00EnergyUNITED STATESUSNorth AmericaGULFPORT ENERGYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GPOR
IWMGLNG2026-09-180.1600002536591.00EnergyBERMUDABMNorth AmericaGOLAR LNGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GLNG
IWMFLNG2026-09-180.030000817518.00EnergyBERMUDABMNorth AmericaFLEX LNGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FLNG
IWMFET2026-09-180.030000279907.00EnergyUNITED STATESUSNorth AmericaFORUM ENERGY TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FET
IWMEE2026-09-180.030000630480.00EnergyUNITED STATESUSNorth AmericaEXCELERATE ENERGYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30EE
IWMDNOW2026-09-180.1000004832273.00EnergyUNITED STATESUSNorth AmericaNOWstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DNOW
IWMDK2026-09-180.1600001581725.00EnergyUNITED STATESUSNorth AmericaDELEK US HOLDINGSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DK
IWMDHT2026-09-180.1100003815429.00EnergyBERMUDABMNorth AmericaDHT HOLDINGSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DHT
IWMDEC2026-09-180.0300001832462.00EnergyDIVERSIFIED ENERGY CO PLCstockfalseuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DEC
IWMCVI2026-09-180.050000785110.00EnergyUNITED STATESUSNorth AmericaCVR ENERGYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CVI
IWMCRK2026-09-180.0300001840483.00EnergyUNITED STATESUSNorth AmericaCOMSTOCK RESOURCESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CRK
IWMCRGY2026-09-180.1200006732714.00EnergyUNITED STATESUSNorth AmericaCRESCENT ENERGYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CRGY
IWMCRC2026-09-180.1300001902190.00EnergyUNITED STATESUSNorth AmericaCALIFORNIA RESOURCESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CRC
IWMCNX2026-09-180.1600003582965.00EnergyUNITED STATESUSNorth AmericaCNX RESOURCESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CNX
IWMCLMT2026-09-180.1300001792847.00EnergyUNITED STATESUSNorth AmericaCALUMET SPECIALTY PRODUCTS PARTNERS LPstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CLMT
IWMBTU2026-09-180.1100003206349.00EnergyUNITED STATESUSNorth AmericaPEABODY ENERGYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BTU
IWMBORR2026-09-180.0300006195895.00EnergyBERMUDABMNorth AmericaBORR DRILLINGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BORR
IWMAROC2026-09-180.1800004506477.00EnergyUNITED STATESUSNorth AmericaARCHROCKstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AROC
IWMAESI2026-09-180.0400002141336.00EnergyUNITED STATESUSNorth AmericaATLAS ENERGY SOLUTIONSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AESI
SPYXOM2026-09-151.07279749835128.00EnergyUNITED STATESUSNorth AmericaEXXON MOBILstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30XOM
SPYWMB2026-09-150.13383314695866.00EnergyUNITED STATESUSNorth AmericaWILLIAMS COMPANIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30WMB
SPYVLO2026-09-150.1799973565804.00EnergyUNITED STATESUSNorth AmericaVALERO ENERGYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30VLO
SPYTRGP2026-09-150.0938342583502.00EnergyUNITED STATESUSNorth AmericaTARGA RESOURCESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30TRGP
SPYTPL2026-09-150.032931696990.00EnergyUNITED STATESUSNorth AmericaTEXAS PACIFIC LANDstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30TPL
SPYSLB2026-09-150.12400617995736.00EnergyNETHERLANDSNLEuropeSCHLUMBERGERstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SLB
SPYPSX2026-09-150.1625494825910.00EnergyUNITED STATESUSNorth AmericaPHILLIPS 66stocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PSX
SPYOXY2026-09-150.0705858740367.00EnergyUNITED STATESUSNorth AmericaOCCIDENTAL PETROLEUMstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30OXY
SPYOKE2026-09-150.0913257583580.00EnergyUNITED STATESUSNorth AmericaONEOKstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30OKE
SPYMPC2026-09-150.1831303506002.00EnergyUNITED STATESUSNorth AmericaMARATHON PETROLEUMstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MPC
SPYKMI2026-09-150.09219423566822.00EnergyUNITED STATESUSNorth AmericaKINDER MORGANstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30KMI
SPYHAL2026-09-150.04558710052320.00EnergyUNITED STATESUSNorth AmericaHALLIBURTONstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30HAL
SPYFANG2026-09-150.0628292336262.00EnergyUNITED STATESUSNorth AmericaDIAMONDBACK ENERGYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30FANG
SPYEXE2026-09-150.0345252881815.00EnergyExpand Energystocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30EXE
SPYEQT2026-09-150.0508457528616.00EnergyUNITED STATESUSNorth AmericaEQTstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30EQT
SPYEOG2026-09-150.1253246411695.00EnergyUNITED STATESUSNorth AmericaEOG RESOURCESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30EOG