They shouldn't spend 99% of the time in the hide but a large majority of it. They like to feel secure and hidden. And even though being active can be a sign of stress it can also just be the snake exploring at night, getting a drink, or just hungry. I wouldn't say a snake climbing a branch means its super stressed at all.