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×sorted by as_of ↑×

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
XLEXOM2026-06-3020.27216052965823.00EnergyUNITED STATESUSNorth AmericaEXXON MOBILstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XOM
XLEWMB2026-06-304.49532021600601.00EnergyUNITED STATESUSNorth AmericaWILLIAMS COMPANIESstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WMB
XLEVLO2026-06-304.4225096065810.00EnergyUNITED STATESUSNorth AmericaVALERO ENERGYstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VLO
XLETRGP2026-06-303.9982165326383.00EnergyUNITED STATESUSNorth AmericaTARGA RESOURCESstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TRGP
XLETPL2026-06-301.7614521437744.00EnergyUNITED STATESUSNorth AmericaTEXAS PACIFIC LANDstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TPL
XLESLB2026-06-304.53352734834088.00EnergyNETHERLANDSNLEuropeSCHLUMBERGERstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SLB
XLEPSX2026-06-304.3927849282232.00EnergyUNITED STATESUSNorth AmericaPHILLIPS 66stocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PSX
XLEOXY2026-06-302.44987118017847.00EnergyUNITED STATESUSNorth AmericaOCCIDENTAL PETROLEUMstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27OXY
XLEOKE2026-06-303.80517015634435.00EnergyUNITED STATESUSNorth AmericaONEOKstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27OKE
XLEMPC2026-06-304.4605836232175.00EnergyUNITED STATESUSNorth AmericaMARATHON PETROLEUMstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MPC
XLEKMI2026-06-304.34821848584350.00EnergyUNITED STATESUSNorth AmericaKINDER MORGANstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KMI
XLEHAL2026-06-301.97025820730558.00EnergyUNITED STATESUSNorth AmericaHALLIBURTONstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HAL
XLEFANG2026-06-302.3702944816822.00EnergyUNITED STATESUSNorth AmericaDIAMONDBACK ENERGYstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27FANG
XLEEXE2026-06-301.5154925936551.00Energy———Expand Energystocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EXE
XLEEQT2026-06-302.31030015521352.00EnergyUNITED STATESUSNorth AmericaEQTstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EQT
XLEEOG2026-06-304.44730012245705.00EnergyUNITED STATESUSNorth AmericaEOG RESOURCESstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EOG
XLEDVN2026-06-303.30948928610696.00EnergyUNITED STATESUSNorth AmericaDEVON ENERGYstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DVN
XLECVX2026-06-3014.38740431004908.00EnergyUNITED STATESUSNorth AmericaCHEVRONstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CVX
XLECOP2026-06-305.87208220176859.00EnergyUNITED STATESUSNorth AmericaCONOCOPHILLIPSstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27COP
XLEBKR2026-06-303.82494324618395.00EnergyUNITED STATESUSNorth AmericaBAKER HUGHESstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BKR
XLEAPA2026-06-300.7997618771425.00EnergyUNITED STATESUSNorth AmericaAPAstocktrue——uw_etf_holdings/api/etfs/XLE/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27APA
SPYXOM2026-09-031.00686950586328.00EnergyUNITED STATESUSNorth AmericaEXXON MOBILstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XOM
SPYWMB2026-09-030.13554514917470.00EnergyUNITED STATESUSNorth AmericaWILLIAMS COMPANIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WMB
SPYVLO2026-09-030.1646413619640.00EnergyUNITED STATESUSNorth AmericaVALERO ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VLO
SPYTRGP2026-09-030.0944532622314.00EnergyUNITED STATESUSNorth AmericaTARGA RESOURCESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TRGP
SPYTPL2026-09-030.031823707632.00EnergyUNITED STATESUSNorth AmericaTEXAS PACIFIC LANDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TPL
SPYSLB2026-09-030.12868018266794.00EnergyNETHERLANDSNLEuropeSCHLUMBERGERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SLB
SPYPSX2026-09-030.1530694898526.00EnergyUNITED STATESUSNorth AmericaPHILLIPS 66stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PSX
SPYOXY2026-09-030.0659818871827.00EnergyUNITED STATESUSNorth AmericaOCCIDENTAL PETROLEUMstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27OXY
SPYOKE2026-09-030.0904427697825.00EnergyUNITED STATESUSNorth AmericaONEOKstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27OKE
SPYMPC2026-09-030.1693113558899.00EnergyUNITED STATESUSNorth AmericaMARATHON PETROLEUMstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MPC
SPYKMI2026-09-030.09275623921764.00EnergyUNITED STATESUSNorth AmericaKINDER MORGANstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KMI
SPYHAL2026-09-030.04668910203812.00EnergyUNITED STATESUSNorth AmericaHALLIBURTONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HAL
SPYFANG2026-09-030.0590502371318.00EnergyUNITED STATESUSNorth AmericaDIAMONDBACK ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27FANG
SPYEXE2026-09-030.0355542925322.00Energy———Expand Energystocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EXE
SPYEQT2026-09-030.0521467641922.00EnergyUNITED STATESUSNorth AmericaEQTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EQT
SPYEOG2026-09-030.1165606508099.00EnergyUNITED STATESUSNorth AmericaEOG RESOURCESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EOG
SPYDVN2026-09-030.08409114046055.00EnergyUNITED STATESUSNorth AmericaDEVON ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DVN
SPYCVX2026-09-030.59235022844159.00EnergyUNITED STATESUSNorth AmericaCHEVRONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CVX
SPYCOP2026-09-030.24753714863927.00EnergyUNITED STATESUSNorth AmericaCONOCOPHILLIPSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27COP
SPYBKR2026-09-030.09467212123506.00EnergyUNITED STATESUSNorth AmericaBAKER HUGHESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BKR
SPYAPA2026-09-030.0234134318900.00EnergyUNITED STATESUSNorth AmericaAPAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27APA
QQQFANG2026-09-030.2508706052764.00EnergyUNITED STATESUSNorth AmericaDIAMONDBACK ENERGYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27FANG
QQQBKR2026-09-030.27743521345396.00EnergyUNITED STATESUSNorth AmericaBAKER HUGHESstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27BKR
IWMXPRO2026-09-050.0500002132984.00EnergyUNITED STATESUSNorth AmericaEXPRO GROUP HOLDINGS NVstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XPRO
IWMWTTR2026-09-050.0700002924425.00EnergyUNITED STATESUSNorth AmericaSELECT WATER SOLUTIONSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WTTR
IWMWKC2026-09-050.0600001292291.00Energy———WORLD KINECTstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WKC
IWMWHD2026-09-050.1600001806375.00EnergyUNITED STATESUSNorth AmericaCACTUSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WHD
IWMVTOL2026-09-050.040000679774.00EnergyUNITED STATESUSNorth AmericaBRISTOW GROUPstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VTOL
IWMVAL2026-09-050.1600001475728.00EnergyUNITED KINGDOMGBEuropeVALARISstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27VAL