One of Amazon’s most popular hydration must-haves just got a major markdown for October Prime Day