Legendary market strategist Jeremy Grantham said the U.S. stock market is in a "super bubble", ranking it the third behind Japan's bubble in 1989 and the real estate bubble of the same era.