CSPR
Casper Sleep Inc.
stock NYSE

Its not in the SP500
It entered the CSPR and DJ Total market indexes, however, and was bought up by VTI and SCHB at least. You can see on VTI's portfolio page on their website, they had spaceX making .14% of the index dated 6/30/26, when it was priced 170. Current price is 115, and shares that it still holds make up about 0.1% of the fund (mathematically by share price + can see it on more recently updated holdings page for SCHB as .1%).
Hard to estimate since we dont know when they bought and/or sold, how many shares stayed in the fund versus were sold etc. Very rough estimate assuming no trading, the shares it kept ended up losing 30%, or reducing the NAV of the fund by about 0.03%, or about $3 for every $10000 of value from 6/30 to now

Its not in the SP500
It entered the CSPR and DJ Total market indexes, however, and was bought up by VTI and SCHB at least. You can see on VTI's portfolio page on their website, they had spaceX making .14% of the index dated 6/30/26, when it was priced 170. Current price is 115, and shares that it still holds make up about 0.1% of the fund (mathematically by share price + can see it on more recently updated holdings page for SCHB as .1%).
Hard to estimate since we dont know when they bought and/or sold, how many shares stayed in the fund versus were sold etc. Very rough estimate assuming no trading, the shares it kept ended up losing 30%, or reducing the NAV of the fund by about 0.03%, or about $3 for every $10000 of value from 6/30 to now