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:country_code = US×country_name = UNITED STATES×etf = XLE×

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
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
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