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 = IE×sorted by as_of ↑×

as_of leads no index, so this sort reads every matching row and keeps only the top 100 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
SPYACN2026-09-040.1721127474012.00TechnologyIRELANDIEEuropeACCENTUREstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30ACN
IWMPRGO2026-09-090.0700003611882.00HealthcareIRELANDIEEuropePERRIGO COstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30PRGO
IWMDOLE2026-09-090.0400002088937.00Consumer DefensiveIRELANDIEEuropeDOLEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30DOLE
IWMCMPR2026-09-090.050000438729.00Communication ServicesIRELANDIEEuropeCIMPRESSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30CMPR
IWMALKS2026-09-090.2500004291408.00HealthcareIRELANDIEEuropeALKERMESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30ALKS
IWMADNT2026-09-090.0500002103594.00Consumer CyclicalIRELANDIEEuropeADIENTstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30ADNT
SPYTT2026-09-080.1488662694925.00IndustrialsIRELANDIEEuropeTRANE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30TT
SPYTEL2026-09-080.0905563566737.00TechnologyIRELANDIEEuropeTE CONNECTIVITYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30TEL
SPYSTX2026-09-080.3064272735654.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30STX
SPYSTE2026-09-080.0324261198521.00HealthcareIRELANDIEEuropeSTERISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30STE
SPYMDT2026-09-080.17914815655662.00HealthcareIRELANDIEEuropeMEDTRONICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30MDT
SPYJCI2026-09-080.1351607455590.00IndustrialsIRELANDIEEuropeJOHNSON CONTROLS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30JCI
SPYETN2026-09-080.2477424738480.00IndustrialsIRELANDIEEuropeEATON CORPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30ETN
SPYCRH2026-09-080.0916308164860.00Basic MaterialsIRELANDIEEuropeCRH PUBLIC LTDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30CRH
SPYAON2026-09-080.1020822609975.00Financial ServicesIRELANDIEEuropeAONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30AON
SPYALLE2026-09-080.0200671038259.00IndustrialsIRELANDIEEuropeALLEGIONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30ALLE
SPYACN2026-09-080.1659877485727.00TechnologyIRELANDIEEuropeACCENTUREstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30ACN
QQQSTX2026-09-080.8902274729662.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30STX
QQQPDD2026-09-080.23382814087901.00Consumer CyclicalIRELANDIEEuropePDD HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30PDD
IWMPRGO2026-09-100.0700003588607.00HealthcareIRELANDIEEuropePERRIGO COstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30PRGO
IWMDOLE2026-09-100.0400002075462.00Consumer DefensiveIRELANDIEEuropeDOLEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30DOLE
IWMCMPR2026-09-100.050000435894.00Communication ServicesIRELANDIEEuropeCIMPRESSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30CMPR
IWMALKS2026-09-100.2400004263758.00HealthcareIRELANDIEEuropeALKERMESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30ALKS
IWMADNT2026-09-100.0500002090049.00Consumer CyclicalIRELANDIEEuropeADIENTstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30ADNT
SPYTT2026-09-090.1489712696461.00IndustrialsIRELANDIEEuropeTRANE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30TT
SPYTEL2026-09-090.0908553568765.00TechnologyIRELANDIEEuropeTE CONNECTIVITYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30TEL
SPYSTX2026-09-090.3016202737214.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30STX
SPYSTE2026-09-090.0320831199205.00HealthcareIRELANDIEEuropeSTERISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30STE
SPYMDT2026-09-090.17903715664578.00HealthcareIRELANDIEEuropeMEDTRONICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30MDT
SPYJCI2026-09-090.1344667459826.00IndustrialsIRELANDIEEuropeJOHNSON CONTROLS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30JCI
SPYETN2026-09-090.2448624741180.00IndustrialsIRELANDIEEuropeEATON CORPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30ETN
SPYCRH2026-09-090.0907928169504.00Basic MaterialsIRELANDIEEuropeCRH PUBLIC LTDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30CRH
SPYAON2026-09-090.0989692611463.00Financial ServicesIRELANDIEEuropeAONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30AON
SPYALLE2026-09-090.0196061038859.00IndustrialsIRELANDIEEuropeALLEGIONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30ALLE
SPYACN2026-09-090.1637797489987.00TechnologyIRELANDIEEuropeACCENTUREstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30ACN
QQQSTX2026-09-090.8746114756566.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30STX
QQQPDD2026-09-090.23115914167929.00Consumer CyclicalIRELANDIEEuropePDD HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30PDD
IWMPRGO2026-09-110.0700003584617.00HealthcareIRELANDIEEuropePERRIGO COstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30PRGO
IWMDOLE2026-09-110.0400002073152.00Consumer DefensiveIRELANDIEEuropeDOLEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30DOLE
IWMCMPR2026-09-110.050000435408.00Communication ServicesIRELANDIEEuropeCIMPRESSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30CMPR
IWMALKS2026-09-110.2500004259018.00HealthcareIRELANDIEEuropeALKERMESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30ALKS
IWMADNT2026-09-110.0500002087727.00Consumer CyclicalIRELANDIEEuropeADIENTstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30ADNT
SPYTT2026-09-100.1483672709901.00IndustrialsIRELANDIEEuropeTRANE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30TT
SPYTEL2026-09-100.0913573586510.00TechnologyIRELANDIEEuropeTE CONNECTIVITYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30TEL
SPYSTX2026-09-100.2952852750864.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30STX
SPYSTE2026-09-100.0318721205190.00HealthcareIRELANDIEEuropeSTERISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30STE
SPYMDT2026-09-100.17954215742593.00HealthcareIRELANDIEEuropeMEDTRONICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30MDT
SPYJCI2026-09-100.1332727496891.00IndustrialsIRELANDIEEuropeJOHNSON CONTROLS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30JCI
SPYETN2026-09-100.2426764764805.00IndustrialsIRELANDIEEuropeEATON CORPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30ETN
SPYCRH2026-09-100.0895888210139.00Basic MaterialsIRELANDIEEuropeCRH PUBLIC LTDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30CRH