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×country_code = IE×

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
SPYTT2026-09-160.1429482637709.00IndustrialsIRELANDIEEuropeTRANE TECHNOLOGIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TT
SPYTEL2026-09-160.0907253491194.00TechnologyIRELANDIEEuropeTE CONNECTIVITYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TEL
SPYSTX2026-09-160.2695062677544.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30STX
SPYSTE2026-09-160.0316441173042.00HealthcareIRELANDIEEuropeSTERISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30STE
SPYMDT2026-09-160.18236415323541.00HealthcareIRELANDIEEuropeMEDTRONICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MDT
SPYJCI2026-09-160.1317487297799.00IndustrialsIRELANDIEEuropeJOHNSON CONTROLS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30JCI
SPYETN2026-09-160.2371134637905.00IndustrialsIRELANDIEEuropeEATON CORPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ETN
SPYCRH2026-09-160.0890517991871.00Basic MaterialsIRELANDIEEuropeCRH PUBLIC LTDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CRH
SPYAON2026-09-160.0986802554547.00Financial ServicesIRELANDIEEuropeAONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AON
SPYALLE2026-09-160.0199521015909.00IndustrialsIRELANDIEEuropeALLEGIONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ALLE
SPYACN2026-09-160.1785787327042.00TechnologyIRELANDIEEuropeACCENTUREstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ACN
QQQSTX2026-09-160.7869084775889.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30STX
QQQPDD2026-09-160.23572614226358.00Consumer CyclicalIRELANDIEEuropePDD HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PDD
IWMPRGO2026-09-180.0600003645797.00HealthcareIRELANDIEEuropePERRIGO COstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PRGO
IWMDOLE2026-09-180.0400002108572.00Consumer DefensiveIRELANDIEEuropeDOLEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DOLE
IWMCMPR2026-09-180.050000442860.00Communication ServicesIRELANDIEEuropeCIMPRESSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CMPR
IWMALKS2026-09-180.2600004331698.00HealthcareIRELANDIEEuropeALKERMESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ALKS
IWMADNT2026-09-180.0500002123331.00Consumer CyclicalIRELANDIEEuropeADIENTstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 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
SPYMDT2026-09-150.18381215421617.00HealthcareIRELANDIEEuropeMEDTRONICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MDT
SPYJCI2026-09-150.1291287344395.00IndustrialsIRELANDIEEuropeJOHNSON CONTROLS INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30JCI
SPYETN2026-09-150.2328614667605.00IndustrialsIRELANDIEEuropeEATON CORPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30ETN
SPYCRH2026-09-150.0896688042955.00Basic MaterialsIRELANDIEEuropeCRH PUBLIC LTDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CRH
SPYAON2026-09-150.0995842570915.00Financial ServicesIRELANDIEEuropeAONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30AON
SPYALLE2026-09-150.0200981022509.00IndustrialsIRELANDIEEuropeALLEGIONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30ALLE
SPYACN2026-09-150.1813127373902.00TechnologyIRELANDIEEuropeACCENTUREstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30ACN
QQQSTX2026-09-150.7756864765977.00TechnologyIRELANDIEEuropeSEAGATE TECHNOLOGY HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30STX
QQQPDD2026-09-150.23375214196818.00Consumer CyclicalIRELANDIEEuropePDD HOLDINGSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PDD
IWMPRGO2026-09-170.0600003722937.00HealthcareIRELANDIEEuropePERRIGO COstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PRGO
IWMDOLE2026-09-170.0400002153232.00Consumer DefensiveIRELANDIEEuropeDOLEstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30DOLE
IWMCMPR2026-09-170.050000452256.00Communication ServicesIRELANDIEEuropeCIMPRESSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30CMPR
IWMALKS2026-09-170.2600004423338.00HealthcareIRELANDIEEuropeALKERMESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30ALKS
IWMADNT2026-09-170.0500002168223.00Consumer CyclicalIRELANDIEEuropeADIENTstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 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