The S&P and Dow closed at fresh all-time highs on Tuesday after widely followed hedge fund manager David Tepper said he is "definitely bullish" on stocks.