Wall Street is nearing frothy levels as investors start to get too greedy for gains, the "Mad Money" host said.