In what felt like a mini rollercoaster ride, the S&P 500 pulled off an impressive feat on Tuesday, defying the usual September gloom to notch a second consecutive win.