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×

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_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zonevendor_tickertext
SPYWTW2026-09-160.0454321129736.00Financial ServicesUNITED KINGDOMGBEuropeWILLIS TOWERS WATSONstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WTW
SPYPNR2026-09-160.0140261932958.00IndustrialsUNITED KINGDOMGBEuropePENTAIRstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PNR
SPYLIN2026-09-160.3278845521078.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LIN
SPYAMCR2026-09-160.0296155490394.00Consumer CyclicalUNITED KINGDOMGBEuropeAMCORstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AMCR
QQQLIN2026-09-160.9606919847646.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LIN
QQQCCEP2026-09-160.2052569497101.00Consumer DefensiveUNITED KINGDOMGBEuropeCOCA-COLA EUROPACIFIC PARTNERSstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CCEP
IWMVAL2026-09-180.1600001487652.00EnergyUNITED KINGDOMGBEuropeVALARISstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VAL
IWMNVGS2026-09-180.030000947484.00EnergyUNITED KINGDOMGBEuropeNAVIGATOR HOLDINGSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NVGS
IWMLIVN2026-09-180.1500001450572.00HealthcareUNITED KINGDOMGBEuropeLIVANOVAstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LIVN
IWMKNSA2026-09-180.1100001094367.00HealthcareUNITED KINGDOMGBEuropeKINIKSA PHARMACEUTICALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KNSA
IWMGENI2026-09-180.0500006160667.00Communication ServicesUNITED KINGDOMGBEuropeGENIUS SPORTSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GENI
IWMCWK2026-09-180.1000006203323.00Real EstateUNITED KINGDOMGBEuropeCUSHMAN & WAKEFIELDstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CWK
IWMCPRI2026-09-180.0600003087276.00Consumer CyclicalUNITED KINGDOMGBEuropeCAPRI HOLDINGSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CPRI
SPYWTW2026-09-150.0465421136996.00Financial ServicesUNITED KINGDOMGBEuropeWILLIS TOWERS WATSONstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30WTW
SPYPNR2026-09-150.0139941945366.00IndustrialsUNITED KINGDOMGBEuropePENTAIRstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PNR
SPYLIN2026-09-150.3270515556454.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30LIN
SPYAMCR2026-09-150.0298305525770.00Consumer CyclicalUNITED KINGDOMGBEuropeAMCORstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30AMCR
QQQLIN2026-09-150.9627519827206.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30LIN
QQQCCEP2026-09-150.2058699477389.00Consumer DefensiveUNITED KINGDOMGBEuropeCOCA-COLA EUROPACIFIC PARTNERSstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CCEP
IWMVAL2026-09-170.1700001519088.00EnergyUNITED KINGDOMGBEuropeVALARISstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30VAL
IWMNVGS2026-09-170.030000967552.00EnergyUNITED KINGDOMGBEuropeNAVIGATOR HOLDINGSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30NVGS
IWMLIVN2026-09-170.1500001481312.00HealthcareUNITED KINGDOMGBEuropeLIVANOVAstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30LIVN
IWMKNSA2026-09-170.1100001117567.00HealthcareUNITED KINGDOMGBEuropeKINIKSA PHARMACEUTICALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30KNSA
IWMGENI2026-09-170.0500006291051.00Communication ServicesUNITED KINGDOMGBEuropeGENIUS SPORTSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30GENI
IWMCWK2026-09-170.1000006334519.00Real EstateUNITED KINGDOMGBEuropeCUSHMAN & WAKEFIELDstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CWK
IWMCPRI2026-09-170.0600003152584.00Consumer CyclicalUNITED KINGDOMGBEuropeCAPRI HOLDINGSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CPRI
SPYWTW2026-09-140.0465951152341.00Financial ServicesUNITED KINGDOMGBEuropeWILLIS TOWERS WATSONstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30WTW
SPYPNR2026-09-140.0138361971592.00IndustrialsUNITED KINGDOMGBEuropePENTAIRstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30PNR
SPYLIN2026-09-140.3266655631226.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30LIN
SPYAMCR2026-09-140.0295575600542.00Consumer CyclicalUNITED KINGDOMGBEuropeAMCORstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30AMCR
QQQLIN2026-09-140.9593979827936.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30LIN
QQQCCEP2026-09-140.2078109478093.00Consumer DefensiveUNITED KINGDOMGBEuropeCOCA-COLA EUROPACIFIC PARTNERSstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30CCEP
IWMVAL2026-09-160.1500001500389.00EnergyUNITED KINGDOMGBEuropeVALARISstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30VAL
IWMNVGS2026-09-160.030000955615.00EnergyUNITED KINGDOMGBEuropeNAVIGATOR HOLDINGSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30NVGS
IWMLIVN2026-09-160.1500001463027.00HealthcareUNITED KINGDOMGBEuropeLIVANOVAstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30LIVN
IWMKNSA2026-09-160.1100001103767.00HealthcareUNITED KINGDOMGBEuropeKINIKSA PHARMACEUTICALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30KNSA
IWMGENI2026-09-160.0500006213495.00Communication ServicesUNITED KINGDOMGBEuropeGENIUS SPORTSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30GENI
IWMCWK2026-09-160.1000006256480.00Real EstateUNITED KINGDOMGBEuropeCUSHMAN & WAKEFIELDstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30CWK
IWMCPRI2026-09-160.0600003113737.00Consumer CyclicalUNITED KINGDOMGBEuropeCAPRI HOLDINGSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30CPRI
SPYWTW2026-09-110.0452121155751.00Financial ServicesUNITED KINGDOMGBEuropeWILLIS TOWERS WATSONstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30WTW
SPYPNR2026-09-110.0138681977420.00IndustrialsUNITED KINGDOMGBEuropePENTAIRstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30PNR
SPYLIN2026-09-110.3263705647842.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30LIN
SPYAMCR2026-09-110.0294645617158.00Consumer CyclicalUNITED KINGDOMGBEuropeAMCORstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30AMCR
QQQLIN2026-09-130.9539329840619.00Basic MaterialsUNITED KINGDOMGBEuropeLINDEstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30LIN
QQQCCEP2026-09-130.2020849490001.00Consumer DefensiveUNITED KINGDOMGBEuropeCOCA-COLA EUROPACIFIC PARTNERSstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30CCEP
IWMVAL2026-09-150.1600001506080.00EnergyUNITED KINGDOMGBEuropeVALARISstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30VAL
IWMNVGS2026-09-150.030000959248.00EnergyUNITED KINGDOMGBEuropeNAVIGATOR HOLDINGSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30NVGS
IWMLIVN2026-09-150.1400001468592.00HealthcareUNITED KINGDOMGBEuropeLIVANOVAstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30LIVN
IWMKNSA2026-09-150.1100001107967.00HealthcareUNITED KINGDOMGBEuropeKINIKSA PHARMACEUTICALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30KNSA
IWMGENI2026-09-150.0500006237099.00Communication ServicesUNITED KINGDOMGBEuropeGENIUS SPORTSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30GENI