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.

18,322 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 300 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
SPYISRG2026-09-180.2107674241002.00HealthcareUNITED STATESUSNorth AmericaINTUITIVE SURGICALstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27ISRG
SPYIRM2026-09-180.0517433581618.00Real EstateUNITED STATESUSNorth AmericaIRON MOUNTAINstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27IRM
SPYIR2026-09-180.0374294124012.00IndustrialsUNITED STATESUSNorth AmericaINGERSOLL RANDstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27IR
SPYIQV2026-09-180.0663201970158.00HealthcareUNITED STATESUSNorth AmericaIQVIA HOLDINGSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27IQV
SPYIP2026-09-180.0277506360572.00Consumer CyclicalUNITED STATESUSNorth AmericaINTERNATIONAL PAPERstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27IP
SPYINVH2026-09-180.0219386452235.00Real EstateUNITED STATESUSNorth AmericaINVITATION HOMESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27INVH
SPYINTU2026-09-180.1256043278761.00TechnologyUNITED STATESUSNorth AmericaINTUITstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27INTU
SPYINTC2026-09-180.81851959651438.00TechnologyUNITED STATESUSNorth AmericaINTELstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27INTC
SPYINCY2026-09-180.0323622043982.00HealthcareUNITED STATESUSNorth AmericaINCYTEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27INCY
SPYILMN2026-09-180.0548831812716.00HealthcareUNITED STATESUSNorth AmericaILLUMINAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27ILMN
SPYIFF2026-09-180.0322923080721.00Basic MaterialsUNITED STATESUSNorth AmericaINTERNATIONAL FLAVORS & FRAGRANCESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27IFF
SPYIEX2026-09-180.025187891042.00IndustrialsUNITED STATESUSNorth AmericaIDEXstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27IEX
SPYIDXX2026-09-180.061400949773.00HealthcareUNITED STATESUSNorth AmericaIDEXX LABORATORIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27IDXX
SPYICE2026-09-180.1323866739330.00Financial ServicesUNITED STATESUSNorth AmericaINTERCONTINENTAL EXCHANGEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27ICE
SPYIBM2026-09-180.32803511310059.00TechnologyUNITED STATESUSNorth AmericaIBMstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27IBM
SPYIBKR2026-09-180.0623265439200.00Financial ServicesUNITED STATESUSNorth AmericaINTERACTIVE BROKERSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27IBKR
SPYHWM2026-09-180.1387274780546.00IndustrialsUNITED STATESUSNorth AmericaHOWMET AEROSPACEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HWM
SPYHUM2026-09-180.0705371445453.00HealthcareUNITED STATESUSNorth AmericaHUMANAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HUM
SPYHUBB2026-09-180.035933636335.00IndustrialsUNITED STATESUSNorth AmericaHUBBELLstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HUBB
SPYHSY2026-09-180.0374841747234.00Consumer DefensiveUNITED STATESUSNorth AmericaHERSHEYstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HSY
SPYHST2026-09-180.0226968224777.00Real EstateUNITED STATESUSNorth AmericaHOST HOTELS & RESORTSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HST
SPYHSIC2026-09-180.0124931165447.00HealthcareUNITED STATESUSNorth AmericaHENRY SCHEINstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HSIC
SPYHRL2026-09-180.0092413511106.00Consumer DefensiveUNITED STATESUSNorth AmericaHORMEL FOODSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HRL
SPYHPQ2026-09-180.04788711017451.00TechnologyUNITED STATESUSNorth AmericaHPstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HPQ
SPYHPE2026-09-180.12184415871167.00TechnologyUNITED STATESUSNorth AmericaHEWLETT PACKARD ENTERPRISEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HPE
SPYHOOD2026-09-180.1438519501824.00TechnologyUNITED STATESUSNorth AmericaROBINHOODstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HOOD
SPYHONA2026-09-180.0788483814433.00IndustrialsHoneywell Aerospacestocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HONA
SPYHON2026-09-180.0995053814433.00IndustrialsUNITED STATESUSNorth AmericaHONEYWELL INTERNATIONALstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HON
SPYHLT2026-09-180.1041712696698.00Consumer CyclicalUNITED STATESUSNorth AmericaHILTON WORLDWIDE HOLDINGSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HLT
SPYHII2026-09-180.016275472080.00IndustrialsUNITED STATESUSNorth AmericaHUNTINGTON INGALLS INDUSTRIESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HII
SPYHIG2026-09-180.0539943240099.00Financial ServicesUNITED STATESUSNorth AmericaHARTFORD FINANCIAL SERVICES GROUPstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HIG
SPYHD2026-09-180.45382911973517.00Consumer CyclicalUNITED STATESUSNorth AmericaHOME DEPOTstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HD
SPYHCA2026-09-180.0955101767340.00HealthcareUNITED STATESUSNorth AmericaHCA HEALTHCAREstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HCA
SPYHBAN2026-09-180.04896424403311.00Financial ServicesUNITED STATESUSNorth AmericaHUNTINGTON BANCSHARESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HBAN
SPYHAS2026-09-180.0187361693327.00Consumer CyclicalUNITED STATESUSNorth AmericaHASBROstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HAS
SPYHAL2026-09-180.04273110053268.00EnergyUNITED STATESUSNorth AmericaHALLIBURTONstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27HAL
SPYGWW2026-09-180.083251520196.00IndustrialsUNITED STATESUSNorth AmericaWW GRAINGERstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27GWW
SPYGS2026-09-180.4160313495399.00Financial ServicesUNITED STATESUSNorth AmericaGOLDMAN SACHS GROUPstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27GS
SPYGRMN2026-09-180.0689471991090.00TechnologySWITZERLANDCHEuropeGARMINstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27GRMN
SPYGPN2026-09-180.0286782668358.00IndustrialsUNITED STATESUSNorth AmericaGLOBAL PAYMENTSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27GPN
SPYGPC2026-09-180.0268141656911.00Consumer CyclicalUNITED STATESUSNorth AmericaGENUINE PARTSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27GPC
SPYGOOGL2026-09-183.11095670439945.00Communication ServicesUNITED STATESUSNorth AmericaALPHABETstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27GOOGL
SPYGOOG2026-09-182.48312557061716.00Communication ServicesUNITED STATESUSNorth AmericaALPHABETstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27GOOG
SPYGNRC2026-09-180.018401702037.00IndustrialsUNITED STATESUSNorth AmericaGENERAC HOLDINGSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27GNRC
SPYGM2026-09-180.10921510515572.00Consumer CyclicalUNITED STATESUSNorth AmericaGENERAL MOTORSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27GM
SPYGLW2026-09-180.1804649513584.00TechnologyUNITED STATESUSNorth AmericaCORNINGstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27GLW
SPYGL2026-09-180.020479934594.00Financial ServicesUNITED STATESUSNorth AmericaGLOBE LIFEstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27GL
SPYGIS2026-09-180.0294836424690.00Consumer DefensiveUNITED STATESUSNorth AmericaGENERAL MILLSstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27GIS
SPYGILD2026-09-180.28212914875132.00HealthcareUNITED STATESUSNorth AmericaGILEAD SCIENCESstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27GILD
SPYGEV2026-09-180.3796763195621.00UtilitiesGE Vernovastocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-222026-09-22 12:272026-09-22 12:27GEV