My ball pythons only come out when they are either hungry or thirsty, but it is common for some snakes to explore at night. To me, it just depends on the snake. Some of my ball pythons like explore more at night, but most stay in their hide.
I agree though that if it is constantly active that it sounds stressed.