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 = Europe×source = uw_etf_holdings×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
XLYGRMN2026-06-300.971397923937.00TechnologySWITZERLANDCHEuropeGARMINstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GRMN
XLYAPTV2026-06-300.3239671192495.00Consumer CyclicalSWITZERLANDCHEuropeAPTIVstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27APTV
XLVSTE2026-08-020.385000697583.00HealthcareIRELANDIEEuropeSTERISstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27STE
XLVSTE2026-06-300.360654695359.00HealthcareIRELANDIEEuropeSTERISstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27STE
XLVMDT2026-08-021.8670009132148.00HealthcareIRELANDIEEuropeMEDTRONICstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MDT
XLVMDT2026-06-301.7539519102464.00HealthcareIRELANDIEEuropeMEDTRONICstocktrue——uw_etf_holdings/api/etfs/XLV/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MDT
XLKTEL2026-08-120.4110002342098.00TechnologyIRELANDIEEuropeTE CONNECTIVITYstocktrue——uw_etf_holdings/api/etfs/XLK/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TEL
XLKTEL2026-06-300.3747522303284.00TechnologyIRELANDIEEuropeTE CONNECTIVITYstocktrue——uw_etf_holdings/api/etfs/XLK/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TEL
XLKSTX2026-08-121.1800001799163.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/XLK/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27STX
XLKSTX2026-06-301.3779221769346.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/XLK/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27STX
XLKNXPI2026-08-120.3870002025831.00TechnologyNETHERLANDSNLEuropeNXP SEMICONDUCTORS NVstocktrue——uw_etf_holdings/api/etfs/XLK/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NXPI
XLKNXPI2026-06-300.4518241992197.00TechnologyNETHERLANDSNLEuropeNXP SEMICONDUCTORS NVstocktrue——uw_etf_holdings/api/etfs/XLK/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NXPI
XLKACN2026-08-120.7190004926156.00TechnologyIRELANDIEEuropeACCENTUREstocktrue——uw_etf_holdings/api/etfs/XLK/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ACN
XLKACN2026-06-300.4865114844485.00TechnologyIRELANDIEEuropeACCENTUREstocktrue——uw_etf_holdings/api/etfs/XLK/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ACN
XLITT2026-06-301.8768321297836.00IndustrialsIRELANDIEEuropeTRANE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TT
XLIPNR2026-06-300.214165948849.00IndustrialsUNITED KINGDOMGBEuropePENTAIRstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PNR
XLIJCI2026-06-301.5410283582186.00IndustrialsIRELANDIEEuropeJOHNSON CONTROLS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27JCI
XLIETN2026-06-302.8603432279836.00IndustrialsIRELANDIEEuropeEATON CORPstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ETN
XLIALLE2026-06-300.208094503073.00IndustrialsIRELANDIEEuropeALLEGIONstocktrue——uw_etf_holdings/api/etfs/XLI/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ALLE
XLFWTW2026-06-300.327233642946.00Financial ServicesUNITED KINGDOMGBEuropeWILLIS TOWERS WATSONstocktrue——uw_etf_holdings/api/etfs/XLF/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WTW
XLFCB2026-06-301.6295052455870.00Financial ServicesSWITZERLANDCHEuropeCHUBBstocktrue——uw_etf_holdings/api/etfs/XLF/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CB
XLFAON2026-06-300.9392081454126.00Financial ServicesIRELANDIEEuropeAONstocktrue——uw_etf_holdings/api/etfs/XLF/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AON
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
SPYWTW2026-09-030.0484451154211.00Financial ServicesUNITED KINGDOMGBEuropeWILLIS TOWERS WATSONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WTW
SPYTT2026-09-030.1468552694669.00IndustrialsIRELANDIEEuropeTRANE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TT
SPYTEL2026-09-030.0916413566399.00TechnologyIRELANDIEEuropeTE CONNECTIVITYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TEL
SPYSTX2026-09-030.2680512735394.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27STX
SPYSTE2026-09-030.0332541198407.00HealthcareIRELANDIEEuropeSTERISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27STE
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
SPYPNR2026-09-030.0145441974788.00IndustrialsUNITED KINGDOMGBEuropePENTAIRstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PNR
SPYNXPI2026-09-030.0851783085340.00TechnologyNETHERLANDSNLEuropeNXP SEMICONDUCTORS NVstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NXPI
SPYMDT2026-09-030.17883115654176.00HealthcareIRELANDIEEuropeMEDTRONICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MDT
SPYLIN2026-09-030.3337235640338.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LIN
SPYJCI2026-09-030.1301057454884.00IndustrialsIRELANDIEEuropeJOHNSON CONTROLS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27JCI
SPYGRMN2026-09-030.0678861995972.00TechnologySWITZERLANDCHEuropeGARMINstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GRMN
SPYETN2026-09-030.2308784738030.00IndustrialsIRELANDIEEuropeEATON CORPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ETN
SPYCRH2026-09-030.0922038164086.00Basic MaterialsIRELANDIEEuropeCRH PUBLIC LTDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CRH
SPYCB2026-09-030.1879484398304.00Financial ServicesSWITZERLANDCHEuropeCHUBBstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CB
SPYAPTV2026-09-030.0147812588867.00Consumer CyclicalSWITZERLANDCHEuropeAPTIVstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27APTV
SPYAON2026-09-030.1047142609727.00Financial ServicesIRELANDIEEuropeAONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AON
SPYAMCR2026-09-030.0311405609654.00Consumer CyclicalUNITED KINGDOMGBEuropeAMCORstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AMCR
SPYALLE2026-09-030.0198161038159.00IndustrialsIRELANDIEEuropeALLEGIONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ALLE
SPYACN2026-09-030.1773717485017.00TechnologyIRELANDIEEuropeACCENTUREstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ACN
QQQSTX2026-09-030.7869524824888.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27STX
QQQPDD2026-09-030.23959014371158.00Consumer CyclicalIRELANDIEEuropePDD HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PDD
QQQNXPI2026-09-030.2496195432355.00TechnologyNETHERLANDSNLEuropeNXP SEMICONDUCTORS NVstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NXPI
QQQLIN2026-09-030.9829739948511.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LIN
QQQCCEP2026-09-030.2138719594045.00Consumer DefensiveUNITED KINGDOMGBEuropeCOCA-COLA EUROPACIFIC PARTNERSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CCEP
QQQASML2026-09-030.6629921971977.00TechnologyNETHERLANDSNLEuropeASML HOLDING NVstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ASML
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