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

Sources in this table

as_ofto
column equals (exact text)
sort
chart against as_of
reset

as_of leads no index, so this sort reads every matching row and keeps only the top 250 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
SPYMET2026-09-160.0807786464343.00Financial ServicesUNITED STATESUSNorth AmericaMETLIFEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MET
SPYMDT2026-09-160.18236415323541.00HealthcareIRELANDIEEuropeMEDTRONICstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MDT
SPYMDLZ2026-09-160.12272415312809.00Consumer DefensiveUNITED STATESUSNorth AmericaMONDELEZ INTERNATIONALstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MDLZ
SPYMCO2026-09-160.1074581796954.00Financial ServicesUNITED STATESUSNorth AmericaMOODYSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MCO
SPYMCK2026-09-160.1636271434893.00HealthcareUNITED STATESUSNorth AmericaMCKESSONstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MCK
SPYMCHP2026-09-160.0578936473017.00TechnologyUNITED STATESUSNorth AmericaMICROCHIP TECHNOLOGYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MCHP
SPYMCD2026-09-160.2711288487370.00Consumer CyclicalUNITED STATESUSNorth AmericaMCDONALDSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MCD
SPYMAS2026-09-160.0212442420872.00IndustrialsUNITED STATESUSNorth AmericaMASCOstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MAS
SPYMAR2026-09-160.1126942617732.00Consumer CyclicalUNITED STATESUSNorth AmericaMARRIOTTstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MAR
SPYMAA2026-09-160.0218051391830.00Real EstateUNITED STATESUSNorth AmericaMID AMERICA APARTMENT COMMUNITIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MAA
SPYMA2026-09-160.7033059638669.00Financial ServicesUNITED STATESUSNorth AmericaMASTERCARDstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MA
SPYLYV2026-09-160.0416291892767.00Communication ServicesUNITED STATESUSNorth AmericaLIVE NATION ENTERTAINMENTstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LYV
SPYLYB2026-09-160.0258553099783.00Basic MaterialsUNITED STATESUSNorth AmericaLYONDELLBASELL INDUSTRIES NVstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LYB
SPYLVS2026-09-160.0188193566300.00Consumer CyclicalUNITED STATESUSNorth AmericaLAS VEGAS SANDSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LVS
SPYLUV2026-09-160.0294055844173.00IndustrialsUNITED STATESUSNorth AmericaSOUTHWEST AIRLINESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LUV
SPYLULU2026-09-160.0154501252517.00Consumer CyclicalCANADACANorth AmericaLULULEMON ATHLETICAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LULU
SPYLRCX2026-09-160.51706414943463.00TechnologyUNITED STATESUSNorth AmericaLAM RESEARCHstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LRCX
SPYLOW2026-09-160.1667596684881.00Consumer CyclicalUNITED STATESUSNorth AmericaLOWES COMPANIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LOW
SPYLNT2026-09-160.0260953071300.00UtilitiesUNITED STATESUSNorth AmericaALLIANT ENERGYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LNT
SPYLMT2026-09-160.1673352423483.00IndustrialsUNITED STATESUSNorth AmericaLOCKHEED MARTINstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LMT
SPYLLY2026-09-161.3820619451134.00HealthcareUNITED STATESUSNorth AmericaELI LILLYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LLY
SPYLITE2026-09-160.109946930479.00TechnologyUNITED STATESUSNorth AmericaLUMENTUM HOLDINGSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LITE
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
SPYLII2026-09-160.017569378634.00IndustrialsUNITED STATESUSNorth AmericaLENNOX INTERNATIONALstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LII
SPYLHX2026-09-160.0718042228200.00IndustrialsUNITED STATESUSNorth AmericaL3HARRIS TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LHX
SPYLH2026-09-160.040930981384.00HealthcareUNITED STATESUSNorth AmericaLABORATORY CORP OF AMERICA HOLDINGSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LH
SPYLEN2026-09-160.0259272574519.00Consumer CyclicalUNITED STATESUSNorth AmericaLENNARstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LEN
SPYLDOS2026-09-160.0250111504482.00TechnologyUNITED STATESUSNorth AmericaLEIDOS HOLDINGSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LDOS
SPYL2026-09-160.0282172018160.00Financial ServicesUNITED STATESUSNorth AmericaLOEWSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30L
SPYKVUE2026-09-160.05262422964798.00Consumer DefensiveKENVUEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KVUE
SPYKR2026-09-160.0533156785122.00Consumer DefensiveUNITED STATESUSNorth AmericaKROGERstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KR
SPYKO2026-09-160.52228246248237.00Consumer DefensiveUNITED STATESUSNorth AmericaCOCA COLAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KO
SPYKMI2026-09-160.09248423417134.00EnergyUNITED STATESUSNorth AmericaKINDER MORGANstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KMI
SPYKMB2026-09-160.0500533969992.00Consumer DefensiveUNITED STATESUSNorth AmericaKIMBERLY CLARKstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KMB
SPYKLAC2026-09-160.33568515606694.00TechnologyUNITED STATESUSNorth AmericaKLAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KLAC
SPYKKR2026-09-160.1029228269566.00Financial ServicesUNITED STATESUSNorth AmericaKKR & COstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KKR
SPYKIM2026-09-160.0234208066703.00Real EstateUNITED STATESUSNorth AmericaKIMCO REALTYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KIM
SPYKHC2026-09-160.03256010244515.00Consumer DefensiveUNITED STATESUSNorth AmericaKRAFT HEINZstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KHC
SPYKEYS2026-09-160.0846972046391.00TechnologyUNITED STATESUSNorth AmericaKEYSIGHT TECHNOLOGIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KEYS
SPYKEY2026-09-160.02935211022636.00Financial ServicesUNITED STATESUSNorth AmericaKEYCORPstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KEY
SPYKDP2026-09-160.06650716273205.00Consumer DefensiveUNITED STATESUSNorth AmericaKEURIG DR PEPPERstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KDP
SPYJPM2026-09-161.43559032013624.00Financial ServicesUNITED STATESUSNorth AmericaJPMORGAN CHASEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30JPM
SPYJNJ2026-09-160.98785028757752.00HealthcareUNITED STATESUSNorth AmericaJOHNSON & JOHNSONstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30JNJ
SPYJKHY2026-09-160.017361849698.00TechnologyUNITED STATESUSNorth AmericaJACK HENRY & ASSOCIATESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30JKHY
SPYJCI2026-09-160.1317487297799.00IndustrialsIRELANDIEEuropeJOHNSON CONTROLS INTERNATIONALstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30JCI
SPYJBL2026-09-160.0482061261904.00TechnologyUNITED STATESUSNorth AmericaJABILstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30JBL
SPYJBHT2026-09-160.027096890588.00IndustrialsUNITED STATESUSNorth AmericaHUNT J B TRANSPORT SERVICESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30JBHT
SPYJ2026-09-160.0260421412142.00IndustrialsUNITED STATESUSNorth AmericaJACOBS SOLUTIONSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30J
SPYIVZ2026-09-160.0205425313750.00Financial ServicesUNITED STATESUSNorth AmericaINVESCOstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30IVZ
SPYITW2026-09-160.1075863131411.00IndustrialsUNITED STATESUSNorth AmericaILLINOIS TOOL WORKSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ITW