Investor confidence in the US stock market decreased in June, according to the latest results from the S&P Global "Investment Manager Index" survey.