changed query to pull one day