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×source = uw_etf_holdings×ticker = XEL×

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
SPYXEL2026-09-160.0697787467200.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30XEL
QQQXEL2026-09-160.20504813296476.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30XEL
SPYXEL2026-09-150.0692587514852.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30XEL
QQQXEL2026-09-150.20448913268868.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30XEL
SPYXEL2026-09-140.0699827615571.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30XEL
QQQXEL2026-09-140.20613813269854.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30XEL
SPYXEL2026-09-110.0714767637953.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30XEL
QQQXEL2026-09-130.20786113286981.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30XEL
SPYXEL2026-09-100.0720067670804.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30XEL
QQQXEL2026-09-100.20950913279109.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30XEL
SPYXEL2026-09-090.0723347632899.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30XEL
QQQXEL2026-09-090.20941213242701.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30XEL
SPYXEL2026-09-080.0726397628567.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30XEL
QQQXEL2026-09-080.21069313167917.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30XEL
SPYXEL2026-09-040.0711287616654.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30XEL
QQQXEL2026-09-070.20726013302725.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57XEL
XLUXEL2026-07-313.49500010308895.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XEL
XLUXEL2026-06-303.54364810199095.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/XLU/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XEL
SPYXEL2026-09-030.0714527627845.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XEL
QQQXEL2026-09-030.20943013432613.00UtilitiesUNITED STATESUSNorth AmericaXCEL ENERGYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XEL