A new survey found that the majority of active traders are bullish, despite some thinking the market is in a bubble.