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:continent = North America×country_name = UNITED STATES×sector = Energy×

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
SPYXOM2026-09-161.03938149518328.00EnergyUNITED STATESUSNorth AmericaEXXON MOBILstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30XOM
SPYWMB2026-09-160.13305814602410.00EnergyUNITED STATESUSNorth AmericaWILLIAMS COMPANIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WMB
SPYVLO2026-09-160.1836373543100.00EnergyUNITED STATESUSNorth AmericaVALERO ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VLO
SPYTRGP2026-09-160.0939532567134.00EnergyUNITED STATESUSNorth AmericaTARGA RESOURCESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TRGP
SPYTPL2026-09-160.031023692502.00EnergyUNITED STATESUSNorth AmericaTEXAS PACIFIC LANDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TPL
SPYPSX2026-09-160.1630884795286.00EnergyUNITED STATESUSNorth AmericaPHILLIPS 66stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PSX
SPYOXY2026-09-160.0662578684927.00EnergyUNITED STATESUSNorth AmericaOCCIDENTAL PETROLEUMstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30OXY
SPYOKE2026-09-160.0897757535400.00EnergyUNITED STATESUSNorth AmericaONEOKstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30OKE
SPYMPC2026-09-160.1853223483694.00EnergyUNITED STATESUSNorth AmericaMARATHON PETROLEUMstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MPC
SPYKMI2026-09-160.09248423417134.00EnergyUNITED STATESUSNorth AmericaKINDER MORGANstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KMI
SPYHAL2026-09-160.0443019988432.00EnergyUNITED STATESUSNorth AmericaHALLIBURTONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HAL
SPYFANG2026-09-160.0580422321478.00EnergyUNITED STATESUSNorth AmericaDIAMONDBACK ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FANG
SPYEQT2026-09-160.0484667480832.00EnergyUNITED STATESUSNorth AmericaEQTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30EQT
SPYEOG2026-09-160.1186696371039.00EnergyUNITED STATESUSNorth AmericaEOG RESOURCESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30EOG
SPYDVN2026-09-160.08559313748795.00EnergyUNITED STATESUSNorth AmericaDEVON ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DVN
SPYCVX2026-09-160.60795122361779.00EnergyUNITED STATESUSNorth AmericaCHEVRONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CVX
SPYCOP2026-09-160.24784814550202.00EnergyUNITED STATESUSNorth AmericaCONOCOPHILLIPSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30COP
SPYBKR2026-09-160.08590411868076.00EnergyUNITED STATESUSNorth AmericaBAKER HUGHESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BKR
SPYAPA2026-09-160.0243364227675.00EnergyUNITED STATESUSNorth AmericaAPAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30APA
QQQFANG2026-09-160.2452285991747.00EnergyUNITED STATESUSNorth AmericaDIAMONDBACK ENERGYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FANG
QQQBKR2026-09-160.25036621130281.00EnergyUNITED STATESUSNorth AmericaBAKER HUGHESstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BKR
IWMXPRO2026-09-180.0500002150232.00EnergyUNITED STATESUSNorth AmericaEXPRO GROUP HOLDINGS NVstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30XPRO
IWMWTTR2026-09-180.0800002948097.00EnergyUNITED STATESUSNorth AmericaSELECT WATER SOLUTIONSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WTTR
IWMWHD2026-09-180.1600001820983.00EnergyUNITED STATESUSNorth AmericaCACTUSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WHD
IWMVTOL2026-09-180.040000685274.00EnergyUNITED STATESUSNorth AmericaBRISTOW GROUPstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VTOL
IWMUUUU2026-09-180.1000006743540.00EnergyUNITED STATESUSNorth AmericaENERGY FUELSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UUUU
IWMUEC2026-09-180.17000012777827.00EnergyUNITED STATESUSNorth AmericaURANIUM ENERGYstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UEC
IWMTTI2026-09-180.0300003365423.00EnergyUNITED STATESUSNorth AmericaTETRA TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TTI
IWMTH2026-09-180.0300001063167.00EnergyUNITED STATESUSNorth AmericaTARGET HOSPITALITYstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TH
IWMTDW2026-09-180.1500001294491.00EnergyUNITED STATESUSNorth AmericaTIDEWATERstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TDW
IWMTALO2026-09-180.0700003295630.00EnergyUNITED STATESUSNorth AmericaTALOS ENERGYstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TALO
IWMSM2026-09-180.3100006309561.00EnergyUNITED STATESUSNorth AmericaSM ENERGYstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SM
IWMREX2026-09-180.040000748493.00EnergyUNITED STATESUSNorth AmericaREX AMERICAN RESOURCESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30REX
IWMPUMP2026-09-180.0300002592954.00EnergyUNITED STATESUSNorth AmericaPROPETRO HOLDINGstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PUMP
IWMPTEN2026-09-180.1400009110138.00EnergyUNITED STATESUSNorth AmericaPATTERSON UTI ENERGYstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PTEN
IWMPBF2026-09-180.2500002557718.00EnergyUNITED STATESUSNorth AmericaPBF ENERGYstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PBF
IWMPARR2026-09-180.1400001275924.00EnergyUNITED STATESUSNorth AmericaPAR PACIFIC HOLDINGSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PARR
IWMOII2026-09-180.1600002604608.00EnergyUNITED STATESUSNorth AmericaOCEANEERING INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30OII
IWMNOG2026-09-180.0900002732848.00EnergyUNITED STATESUSNorth AmericaNORTHERN OIL & GASstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NOG
IWMNEXT2026-09-180.0400004332727.00EnergyUNITED STATESUSNorth AmericaNEXTDECADEstocktrue——uw_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 REUNITEDstocktrue——uw_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 CORPstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NE
IWMMUR2026-09-180.1800003598501.00EnergyUNITED STATESUSNorth AmericaMURPHY OILstocktrue——uw_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 & GASstocktrue——uw_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 LPGstocktrue——uw_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 ENERGYstocktrue——uw_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 ENERGYstocktrue——uw_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 ENERGYstocktrue——uw_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 HOLDINGSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KNTK
IWMHP2026-09-180.1400002547051.00EnergyUNITED STATESUSNorth AmericaHELMERICH & PAYNEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HP