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

Sources in this table

as_ofto
column equals (exact text)
sort
chart against as_of
reset
active:sorted by as_of ↑×

as_of leads no index, so this sort reads every matching row and keeps only the top 250 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
XLUEVRG2026-06-301.4083953766055.00UtilitiesUNITED STATESUSNorth AmericaEVERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EVRG
XLUETR2026-07-313.5090007561300.00UtilitiesUNITED STATESUSNorth AmericaENTERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ETR
XLUETR2026-06-303.7178537480833.00UtilitiesUNITED STATESUSNorth AmericaENTERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ETR
XLUES2026-07-311.9990006210429.00UtilitiesUNITED STATESUSNorth AmericaEVERSOURCE ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ES
XLUES2026-06-301.9213476144327.00UtilitiesUNITED STATESUSNorth AmericaEVERSOURCE ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ES
XLUEIX2026-07-312.1510006354322.00UtilitiesUNITED STATESUSNorth AmericaEDISON INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EIX
XLUEIX2026-06-302.0251696286706.00UtilitiesUNITED STATESUSNorth AmericaEDISON INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EIX
XLUED2026-07-312.9410006085707.00UtilitiesUNITED STATESUSNorth AmericaCONSOLIDATED EDISONstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ED
XLUED2026-06-302.8821006020917.00UtilitiesUNITED STATESUSNorth AmericaCONSOLIDATED EDISONstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ED
XLUDUK2026-07-317.15500012873846.00UtilitiesUNITED STATESUSNorth AmericaDUKE ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DUK
XLUDUK2026-06-306.97587612736797.00UtilitiesUNITED STATESUSNorth AmericaDUKE ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DUK
XLUDTE2026-07-312.1230003435294.00UtilitiesUNITED STATESUSNorth AmericaDTE ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DTE
XLUDTE2026-06-302.2406853398661.00UtilitiesUNITED STATESUSNorth AmericaDTE ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27DTE
XLUD2026-07-314.41100014522871.00UtilitiesUNITED STATESUSNorth AmericaDOMINION ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27D
XLUD2026-06-304.24558814368362.00UtilitiesUNITED STATESUSNorth AmericaDOMINION ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27D
XLUCNP2026-07-311.99700010802642.00UtilitiesUNITED STATESUSNorth AmericaCENTERPOINT ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CNP
XLUCNP2026-06-302.03657610687594.00UtilitiesUNITED STATESUSNorth AmericaCENTERPOINT ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CNP
XLUCMS2026-07-311.6330005101371.00UtilitiesUNITED STATESUSNorth AmericaCMS ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CMS
XLUCMS2026-06-301.6706095047076.00UtilitiesUNITED STATESUSNorth AmericaCMS ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CMS
XLUCEG2026-07-315.8630005279029.00UtilitiesUNITED STATESUSNorth AmericaCONSTELLATION ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CEG
XLUCEG2026-06-305.6127935222837.00UtilitiesUNITED STATESUSNorth AmericaCONSTELLATION ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CEG
XLUAWK2026-07-311.9170003224735.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN WATER WORKS COMPANYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AWK
XLUAWK2026-06-301.8164573190522.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN WATER WORKS COMPANYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AWK
XLUATO2026-07-312.1090002756422.00UtilitiesUNITED STATESUSNorth AmericaATMOS ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ATO
XLUATO2026-06-302.0327172727055.00UtilitiesUNITED STATESUSNorth AmericaATMOS ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ATO
XLUAES2026-07-310.75100011776808.00UtilitiesUNITED STATESUSNorth AmericaAESstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AES
XLUAES2026-06-300.73907411651466.00UtilitiesUNITED STATESUSNorth AmericaAESstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AES
XLUAEP2026-07-315.0060008985094.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN ELECTRIC POWER COstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AEP
XLUAEP2026-06-305.2621648889413.00UtilitiesUNITED STATESUSNorth AmericaAMERICAN ELECTRIC POWER COstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AEP
XLUAEE2026-07-312.1640004570184.00UtilitiesUNITED STATESUSNorth AmericaAMERENstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AEE
XLUAEE2026-06-302.2115264521541.00UtilitiesUNITED STATESUSNorth AmericaAMERENstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AEE
XLU$CASH:US DOLLAR2026-06-300.031015—————US DOLLARcash———uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27—
XLU$CASH:SSI US GOV MONEY MARKET CLASS2026-06-300.233474—————SSI US GOV MONEY MARKET CLASScash———uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27—
XLPWMT2026-06-3010.78675212999430.00Consumer DefensiveUNITED STATESUSNorth AmericaWALMARTstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WMT
XLPTSN2026-06-301.0467032495504.00Consumer DefensiveUNITED STATESUSNorth AmericaTYSON FOODSstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TSN
XLPTGT2026-06-303.8442734017427.00Consumer DefensiveUNITED STATESUSNorth AmericaTARGETstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TGT
XLPTAP2026-06-300.4050661419113.00Consumer DefensiveUNITED STATESUSNorth AmericaMOLSON COORS BEVERAGEstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TAP
XLPSYY2026-06-302.5900584229776.00Consumer DefensiveUNITED STATESUSNorth AmericaSYSCOstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SYY
XLPSTZ2026-06-301.2570701233598.00Consumer DefensiveUNITED STATESUSNorth AmericaCONSTELLATION BRANDSstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27STZ
XLPSJM2026-06-300.777537943363.00Consumer DefensiveUNITED STATESUSNorth AmericaJ M SMUCKERstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SJM
XLPPM2026-06-306.1252604621385.00Consumer DefensiveUNITED STATESUSNorth AmericaPHILIP MORRIS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PM
XLPPG2026-06-307.4179766904673.00Consumer DefensiveUNITED STATESUSNorth AmericaPROCTER & GAMBLEstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PG
XLPPEP2026-06-304.3169434351789.00Consumer DefensiveUNITED STATESUSNorth AmericaPEPSICOstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PEP
XLPMO2026-06-304.5270988588142.00Consumer DefensiveUNITED STATESUSNorth AmericaALTRIA stocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MO
XLPMNST2026-06-304.4472636315230.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MNST
XLPMKC2026-06-300.8299082246660.00Consumer DefensiveUNITED STATESUSNorth AmericaMCCORMICK & COstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MKC
XLPMDLZ2026-06-304.1468019785771.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MDLZ
XLPKVUE2026-06-302.37781316983502.00Consumer Defensive———KENVUEstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KVUE
XLPKR2026-06-302.0412905017498.00Consumer DefensiveUNITED STATESUSNorth AmericaKROGERstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KR
XLPKO2026-06-306.83645111481817.00Consumer DefensiveUNITED STATESUSNorth AmericaCOCA COLAstocktrue——uw_etf_holdings/api/etfs/XLP/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KO