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 = GB×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
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
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
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
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
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
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
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
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
IWMNVGS2026-09-050.030000939872.00EnergyUNITED KINGDOMGBEuropeNAVIGATOR HOLDINGSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NVGS
IWMLIVN2026-09-050.1500001438912.00HealthcareUNITED KINGDOMGBEuropeLIVANOVAstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LIVN
IWMKNSA2026-09-050.1100001085567.00HealthcareUNITED KINGDOMGBEuropeKINIKSA PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KNSA
IWMGENI2026-09-050.0600006111211.00Communication ServicesUNITED KINGDOMGBEuropeGENIUS SPORTSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GENI
IWMCWK2026-09-050.1000006153559.00Real EstateUNITED KINGDOMGBEuropeCUSHMAN & WAKEFIELDstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CWK
IWMCPRI2026-09-050.0500003062504.00Consumer CyclicalUNITED KINGDOMGBEuropeCAPRI HOLDINGSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CPRI
QQQLIN2026-09-070.9714139852283.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57LIN
QQQCCEP2026-09-070.2067599501249.00Consumer DefensiveUNITED KINGDOMGBEuropeCOCA-COLA EUROPACIFIC PARTNERSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57CCEP
IWMVAL2026-09-080.1600001473831.00EnergyUNITED KINGDOMGBEuropeVALARISstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57VAL
IWMNVGS2026-09-080.030000938661.00EnergyUNITED KINGDOMGBEuropeNAVIGATOR HOLDINGSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57NVGS
IWMLIVN2026-09-080.1500001437057.00HealthcareUNITED KINGDOMGBEuropeLIVANOVAstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57LIVN
IWMKNSA2026-09-080.1100001084167.00HealthcareUNITED KINGDOMGBEuropeKINIKSA PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57KNSA
IWMGENI2026-09-080.0600006103343.00Communication ServicesUNITED KINGDOMGBEuropeGENIUS SPORTSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57GENI
IWMCWK2026-09-080.1000006145642.00Real EstateUNITED KINGDOMGBEuropeCUSHMAN & WAKEFIELDstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57CWK
IWMCPRI2026-09-080.0500003058563.00Consumer CyclicalUNITED KINGDOMGBEuropeCAPRI HOLDINGSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57CPRI
SPYWTW2026-09-040.0475791152506.00Financial ServicesUNITED KINGDOMGBEuropeWILLIS TOWERS WATSONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30WTW
SPYPNR2026-09-040.0146431971874.00IndustrialsUNITED KINGDOMGBEuropePENTAIRstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30PNR
SPYLIN2026-09-040.3317195632030.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30LIN
SPYAMCR2026-09-040.0311905601346.00Consumer CyclicalUNITED KINGDOMGBEuropeAMCORstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30AMCR
IWMVAL2026-09-090.1600001473831.00EnergyUNITED KINGDOMGBEuropeVALARISstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30VAL
IWMNVGS2026-09-090.030000938661.00EnergyUNITED KINGDOMGBEuropeNAVIGATOR HOLDINGSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30NVGS
IWMLIVN2026-09-090.1500001437057.00HealthcareUNITED KINGDOMGBEuropeLIVANOVAstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30LIVN
IWMKNSA2026-09-090.1100001084167.00HealthcareUNITED KINGDOMGBEuropeKINIKSA PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30KNSA
IWMGENI2026-09-090.0600006103343.00Communication ServicesUNITED KINGDOMGBEuropeGENIUS SPORTSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30GENI
IWMCWK2026-09-090.1000006145642.00Real EstateUNITED KINGDOMGBEuropeCUSHMAN & WAKEFIELDstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30CWK
IWMCPRI2026-09-090.0500003058563.00Consumer CyclicalUNITED KINGDOMGBEuropeCAPRI HOLDINGSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30CPRI
SPYWTW2026-09-080.0465131154321.00Financial ServicesUNITED KINGDOMGBEuropeWILLIS TOWERS WATSONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30WTW
SPYPNR2026-09-080.0143391974976.00IndustrialsUNITED KINGDOMGBEuropePENTAIRstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30PNR
SPYLIN2026-09-080.3272355640874.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30LIN
SPYAMCR2026-09-080.0308105610190.00Consumer CyclicalUNITED KINGDOMGBEuropeAMCORstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30AMCR
QQQLIN2026-09-080.9539839752410.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30LIN
QQQCCEP2026-09-080.2085599404938.00Consumer DefensiveUNITED KINGDOMGBEuropeCOCA-COLA EUROPACIFIC PARTNERSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30CCEP
IWMVAL2026-09-100.1600001464346.00EnergyUNITED KINGDOMGBEuropeVALARISstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30VAL
IWMNVGS2026-09-100.030000932606.00EnergyUNITED KINGDOMGBEuropeNAVIGATOR HOLDINGSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30NVGS
IWMLIVN2026-09-100.1400001427782.00HealthcareUNITED KINGDOMGBEuropeLIVANOVAstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30LIVN
IWMKNSA2026-09-100.1000001077167.00HealthcareUNITED KINGDOMGBEuropeKINIKSA PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30KNSA
IWMGENI2026-09-100.0600006064003.00Communication ServicesUNITED KINGDOMGBEuropeGENIUS SPORTSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30GENI
IWMCWK2026-09-100.1000006106057.00Real EstateUNITED KINGDOMGBEuropeCUSHMAN & WAKEFIELDstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30CWK
IWMCPRI2026-09-100.0500003038858.00Consumer CyclicalUNITED KINGDOMGBEuropeCAPRI HOLDINGSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30CPRI
SPYWTW2026-09-090.0450691154981.00Financial ServicesUNITED KINGDOMGBEuropeWILLIS TOWERS WATSONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30WTW
SPYPNR2026-09-090.0141381976104.00IndustrialsUNITED KINGDOMGBEuropePENTAIRstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30PNR