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 150 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
SPYAON2026-09-100.1005472624483.00Financial ServicesIRELANDIEEuropeAONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30AON
SPYALLE2026-09-100.0196611044109.00IndustrialsIRELANDIEEuropeALLEGIONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30ALLE
SPYACN2026-09-100.1667007527262.00TechnologyIRELANDIEEuropeACCENTUREstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30ACN
QQQSTX2026-09-100.8605304769664.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30STX
QQQPDD2026-09-100.23137014206890.00Consumer CyclicalIRELANDIEEuropePDD HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30PDD
IWMPRGO2026-09-120.0600003606562.00HealthcareIRELANDIEEuropePERRIGO COstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30PRGO
IWMDOLE2026-09-120.0400002085857.00Consumer DefensiveIRELANDIEEuropeDOLEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30DOLE
IWMCMPR2026-09-120.050000438081.00Communication ServicesIRELANDIEEuropeCIMPRESSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30CMPR
IWMALKS2026-09-120.2500004285088.00HealthcareIRELANDIEEuropeALKERMESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30ALKS
IWMADNT2026-09-120.0500002100498.00Consumer CyclicalIRELANDIEEuropeADIENTstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30ADNT
SPYTT2026-09-110.1479972698253.00IndustrialsIRELANDIEEuropeTRANE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30TT
SPYTEL2026-09-110.0938203571131.00TechnologyIRELANDIEEuropeTE CONNECTIVITYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30TEL
SPYSTX2026-09-110.2818392739034.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30STX
SPYSTE2026-09-110.0313481200003.00HealthcareIRELANDIEEuropeSTERISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30STE
SPYMDT2026-09-110.17672315674980.00HealthcareIRELANDIEEuropeMEDTRONICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30MDT
SPYJCI2026-09-110.1350947464768.00IndustrialsIRELANDIEEuropeJOHNSON CONTROLS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30JCI
SPYETN2026-09-110.2501374744330.00IndustrialsIRELANDIEEuropeEATON CORPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30ETN
SPYCRH2026-09-110.0897248174922.00Basic MaterialsIRELANDIEEuropeCRH PUBLIC LTDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30CRH
SPYAON2026-09-110.0980412613199.00Financial ServicesIRELANDIEEuropeAONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30AON
SPYALLE2026-09-110.0197591039559.00IndustrialsIRELANDIEEuropeALLEGIONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30ALLE
SPYACN2026-09-110.1708397494957.00TechnologyIRELANDIEEuropeACCENTUREstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30ACN
QQQSTX2026-09-130.8209424772496.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30STX
QQQPDD2026-09-130.22918814215314.00Consumer CyclicalIRELANDIEEuropePDD HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30PDD
IWMPRGO2026-09-150.0600003691017.00HealthcareIRELANDIEEuropePERRIGO COstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30PRGO
IWMDOLE2026-09-150.0400002134752.00Consumer DefensiveIRELANDIEEuropeDOLEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30DOLE
IWMCMPR2026-09-150.050000448368.00Communication ServicesIRELANDIEEuropeCIMPRESSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30CMPR
IWMALKS2026-09-150.2500004385418.00HealthcareIRELANDIEEuropeALKERMESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30ALKS
IWMADNT2026-09-150.0500002149647.00Consumer CyclicalIRELANDIEEuropeADIENTstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30ADNT
SPYTT2026-09-140.1431602690317.00IndustrialsIRELANDIEEuropeTRANE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30TT
SPYTEL2026-09-140.0904513560653.00TechnologyIRELANDIEEuropeTE CONNECTIVITYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30TEL
SPYSTX2026-09-140.2747942730974.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30STX
SPYSTE2026-09-140.0319321196469.00HealthcareIRELANDIEEuropeSTERISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30STE
SPYMDT2026-09-140.18311715628914.00HealthcareIRELANDIEEuropeMEDTRONICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30MDT
SPYJCI2026-09-140.1280747442882.00IndustrialsIRELANDIEEuropeJOHNSON CONTROLS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30JCI
SPYETN2026-09-140.2323074730380.00IndustrialsIRELANDIEEuropeEATON CORPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30ETN
SPYCRH2026-09-140.0905948150928.00Basic MaterialsIRELANDIEEuropeCRH PUBLIC LTDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30CRH
SPYAON2026-09-140.1013922605511.00Financial ServicesIRELANDIEEuropeAONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30AON
SPYALLE2026-09-140.0200461036459.00IndustrialsIRELANDIEEuropeALLEGIONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30ALLE
SPYACN2026-09-140.1820227472947.00TechnologyIRELANDIEEuropeACCENTUREstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30ACN
QQQSTX2026-09-140.8042654766331.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30STX
QQQPDD2026-09-140.23607914197873.00Consumer CyclicalIRELANDIEEuropePDD HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30PDD
IWMPRGO2026-09-160.0600003677052.00HealthcareIRELANDIEEuropePERRIGO COstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30PRGO
IWMDOLE2026-09-160.0400002126667.00Consumer DefensiveIRELANDIEEuropeDOLEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30DOLE
IWMCMPR2026-09-160.050000446667.00Communication ServicesIRELANDIEEuropeCIMPRESSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30CMPR
IWMALKS2026-09-160.2500004368828.00HealthcareIRELANDIEEuropeALKERMESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30ALKS
IWMADNT2026-09-160.0500002141520.00Consumer CyclicalIRELANDIEEuropeADIENTstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30ADNT
SPYTT2026-09-150.1426712654605.00IndustrialsIRELANDIEEuropeTRANE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30TT
SPYTEL2026-09-150.0899743513502.00TechnologyIRELANDIEEuropeTE CONNECTIVITYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30TEL
SPYSTX2026-09-150.2644212694704.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30STX
SPYSTE2026-09-150.0315621180566.00HealthcareIRELANDIEEuropeSTERISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30STE