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 200 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
SPYOXY2026-09-160.0662578684927.00EnergyUNITED STATESUSNorth AmericaOCCIDENTAL PETROLEUMstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30OXY
SPYOTIS2026-09-160.0408444589265.00IndustrialsUNITED STATESUSNorth AmericaOTIS WORLDWIDEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30OTIS
SPYORLY2026-09-160.1065959911672.00Consumer CyclicalUNITED STATESUSNorth AmericaO REILLY AUTOMOTIVEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ORLY
SPYORCL2026-09-160.37315520281409.00TechnologyUNITED STATESUSNorth AmericaORACLEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ORCL
SPYON2026-09-160.0401214687305.00TechnologyUNITED STATESUSNorth AmericaON SEMICONDUCTORstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ON
SPYOMC2026-09-160.0347533408714.00Communication ServicesUNITED STATESUSNorth AmericaOMNICOM GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30OMC
SPYOKE2026-09-160.0897757535400.00EnergyUNITED STATESUSNorth AmericaONEOKstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30OKE
SPYODFL2026-09-160.0490502188876.00IndustrialsUNITED STATESUSNorth AmericaOLD DOMINION FREIGHT LINEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ODFL
SPYO2026-09-160.08191711152872.00Real EstateUNITED STATESUSNorth AmericaREALTY INCOMEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30O
SPYNXPI2026-09-160.0850033020370.00TechnologyNETHERLANDSNLEuropeNXP SEMICONDUCTORS NVstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NXPI
SPYNWSA2026-09-160.0169334364187.00Communication ServicesUNITED STATESUSNorth AmericaNEWSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NWSA
SPYNWS2026-09-160.0062711459083.00Communication ServicesUNITED STATESUSNorth AmericaNEWSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NWS
SPYNVR2026-09-160.02541531965.00Consumer CyclicalUNITED STATESUSNorth AmericaNVRstockfalse——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NVR
SPYNVDA2026-09-167.955356289387163.00TechnologyUNITED STATESUSNorth AmericaNVIDIAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NVDA
SPYNUE2026-09-160.0912592723936.00Basic MaterialsUNITED STATESUSNorth AmericaNUCORstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NUE
SPYNTRS2026-09-160.0502422213144.00Financial ServicesUNITED STATESUSNorth AmericaNORTHERN TRUSTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NTRS
SPYNTAP2026-09-160.0581702363669.00TechnologyUNITED STATESUSNorth AmericaNETAPPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NTAP
SPYNSC2026-09-160.1091782679822.00IndustrialsUNITED STATESUSNorth AmericaNORFOLK SOUTHERNstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NSC
SPYNRG2026-09-160.0348242523382.00UtilitiesUNITED STATESUSNorth AmericaNRG ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NRG
SPYNOW2026-09-160.22129712315076.00TechnologyUNITED STATESUSNorth AmericaSERVICENOWstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NOW
SPYNOC2026-09-160.1089231596749.00IndustrialsUNITED STATESUSNorth AmericaNORTHROP GRUMMANstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NOC
SPYNKE2026-09-160.06597514347321.00Consumer CyclicalUNITED STATESUSNorth AmericaNIKEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NKE
SPYNI2026-09-160.0298795717863.00UtilitiesUNITED STATESUSNorth AmericaNISOURCEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NI
SPYNFLX2026-09-160.49386650290872.00Communication ServicesUNITED STATESUSNorth AmericaNETFLIXstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NFLX
SPYNEM2026-09-160.19940112742456.00Basic MaterialsUNITED STATESUSNorth AmericaNEWMONTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NEM
SPYNEE2026-09-160.25728124908316.00UtilitiesUNITED STATESUSNorth AmericaNEXTERA ENERGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NEE
SPYNDSN2026-09-160.025176633922.00IndustrialsUNITED STATESUSNorth AmericaNORDSONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NDSN
SPYNDAQ2026-09-160.0609585343706.00Financial ServicesUNITED STATESUSNorth AmericaNASDAQstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NDAQ
SPYNCLH2026-09-160.0103275529988.00Consumer CyclicalUNITED STATESUSNorth AmericaNORWEGIAN CRUISE LINEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NCLH
SPYMU2026-09-161.60445013473724.00TechnologyUNITED STATESUSNorth AmericaMICRON TECHNOLOGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MU
SPYMTD2026-09-160.042566240229.00HealthcareUNITED STATESUSNorth AmericaMETTLER TOLEDO INTERNATIONALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MTD
SPYMTB2026-09-160.0508781751588.00Financial ServicesUNITED STATESUSNorth AmericaM&T BANKstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MTB
SPYMSI2026-09-160.1174781984861.00TechnologyUNITED STATESUSNorth AmericaMOTOROLA SOLUTIONSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MSI
SPYMSFT2026-09-165.59265988753781.00TechnologyUNITED STATESUSNorth AmericaMICROSOFTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MSFT
SPYMSCI2026-09-160.060493870668.00Financial ServicesUNITED STATESUSNorth AmericaMSCIstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MSCI
SPYMS2026-09-160.37243814316303.00Financial ServicesUNITED STATESUSNorth AmericaMORGAN STANLEYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MS
SPYMRVL2026-09-160.30864510454654.00TechnologyUNITED STATESUSNorth AmericaMARVELL TECHNOLOGYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MRVL
SPYMRSH2026-09-160.1309055762411.00Financial Services———Marsh & McLennanstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MRSH
SPYMRNA2026-09-160.0790604224425.00HealthcareUNITED STATESUSNorth AmericaMODERNAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MRNA
SPYMRK2026-09-160.54959729510498.00HealthcareUNITED STATESUSNorth AmericaMERCK & COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MRK
SPYMPWR2026-09-160.086645587464.00TechnologyUNITED STATESUSNorth AmericaMONOLITHIC POWER SYSTEMSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MPWR
SPYMPC2026-09-160.1853223483694.00EnergyUNITED STATESUSNorth AmericaMARATHON PETROLEUMstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MPC
SPYMOS2026-09-160.0122023829734.00Basic MaterialsUNITED STATESUSNorth AmericaMOSAICstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MOS
SPYMO2026-09-160.17954219928703.00Consumer DefensiveUNITED STATESUSNorth AmericaALTRIA stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MO
SPYMNST2026-09-160.09777517069362.00Consumer DefensiveUNITED STATESUSNorth AmericaMONSTER BEVERAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MNST
SPYMMM2026-09-160.1303996238095.00IndustrialsUNITED STATESUSNorth America3Mstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MMM
SPYMLM2026-09-160.045854718224.00Basic MaterialsUNITED STATESUSNorth AmericaMARTIN MARIETTA MATERIALSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MLM
SPYMKC2026-09-160.0196063047356.00Consumer DefensiveUNITED STATESUSNorth AmericaMCCORMICK & COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MKC
SPYMGM2026-09-160.0111902268062.00Consumer CyclicalUNITED STATESUSNorth AmericaMGM RESORTS stocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MGM
SPYMETA2026-09-162.27052226238624.00Communication ServicesUNITED STATESUSNorth AmericaMETAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30META