Depends on the fish. Tiger barbs sleep with their nose pointed downwards, and the worse the water quality is, the more downwards it will be. Some fish flare and if their tail has damage it could look like it's pointing up rather than flaring out. Certain fish just have tails that are more upwards pointing than others, like some bottom feeders.