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×etf = SPY×

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
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
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
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
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