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 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
SPYXOM2026-09-161.03938149518328.00EnergyUNITED STATESUSNorth AmericaEXXON MOBILstocktrueuw_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 COMPANIESstocktrueuw_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 ENERGYstocktrueuw_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 RESOURCESstocktrueuw_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 LANDstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TPL
SPYSLB2026-09-160.12019117881424.00EnergyNETHERLANDSNLEuropeSCHLUMBERGERstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SLB
SPYPSX2026-09-160.1630884795286.00EnergyUNITED STATESUSNorth AmericaPHILLIPS 66stocktrueuw_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 PETROLEUMstocktrueuw_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 AmericaONEOKstocktrueuw_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 PETROLEUMstocktrueuw_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 MORGANstocktrueuw_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 AmericaHALLIBURTONstocktrueuw_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 ENERGYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FANG
SPYEXE2026-09-160.0326572863467.00EnergyExpand Energystocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30EXE
SPYEQT2026-09-160.0484667480832.00EnergyUNITED STATESUSNorth AmericaEQTstocktrueuw_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 RESOURCESstocktrueuw_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 ENERGYstocktrueuw_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 AmericaCHEVRONstocktrueuw_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 AmericaCONOCOPHILLIPSstocktrueuw_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 HUGHESstocktrueuw_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 AmericaAPAstocktrueuw_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 ENERGYstocktrueuw_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 HUGHESstocktrueuw_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 NVstocktrueuw_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 SOLUTIONSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WTTR
IWMWKC2026-09-180.0600001302763.00EnergyWORLD KINECTstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WKC
IWMWHD2026-09-180.1600001820983.00EnergyUNITED STATESUSNorth AmericaCACTUSstocktrueuw_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 GROUPstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VTOL
IWMVAL2026-09-180.1600001487652.00EnergyUNITED KINGDOMGBEuropeVALARISstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VAL
IWMUUUU2026-09-180.1000006743540.00EnergyUNITED STATESUSNorth AmericaENERGY FUELSstocktrueuw_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 ENERGYstocktrueuw_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 TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TTI
IWMTNK2026-09-180.080000637419.00EnergyBERMUDABMNorth AmericaTEEKAY TANKERSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TNK
IWMTK2026-09-180.0300001463995.00EnergyBERMUDABMNorth AmericaTEEKAYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TK
IWMTH2026-09-180.0300001063167.00EnergyUNITED STATESUSNorth AmericaTARGET HOSPITALITYstocktrueuw_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 AmericaTIDEWATERstocktrueuw_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 ENERGYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TALO
IWMSTNG2026-09-180.1300001206494.00EnergySCORPIO TANKERSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30STNG
IWMSM2026-09-180.3100006309561.00EnergyUNITED STATESUSNorth AmericaSM ENERGYstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SM
IWMSEI2026-09-180.1100001381020.00EnergySolaris Oilfield Infrastructurestocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SEI
IWMSDRL2026-09-180.1000001639569.00EnergySEADRILLstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SDRL
IWMRIG2026-09-180.18000025475875.00EnergySWITZERLANDCHEuropeTRANSOCEANstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RIG
IWMREX2026-09-180.040000748493.00EnergyUNITED STATESUSNorth AmericaREX AMERICAN RESOURCESstocktrueuw_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 HOLDINGstocktrueuw_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 ENERGYstocktrueuw_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 ENERGYstocktrueuw_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 HOLDINGSstocktrueuw_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 INTERNATIONALstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30OII
IWMNVGS2026-09-180.030000947484.00EnergyUNITED KINGDOMGBEuropeNAVIGATOR HOLDINGSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NVGS
IWMNOG2026-09-180.0900002732848.00EnergyUNITED STATESUSNorth AmericaNORTHERN OIL & GASstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NOG