There really are too many factors to give an absolute answer. The pH can change due to the processes of live plants, bacteria, fish, microorganisms, algae, etc. They all have some impact, even if minute. The plants have the greatest impact. An aquarium without plants shouldn't change too much day to day or hour to hour. This section on my site tries to explain how plants (and to a lesser degree animals) effect the pH during different parts of the day due to the carbonic and respiratory cycles:
http://www.fishpondinfo.com/plants/algae4.htm#plantsWater that is low in hardness and alkalinity like my well water is more apt to have pH fluctuations because the bicarbonates that make up alkalinity buffer the water. Buffering is like a cushion to protect the pH. Imagine that you put a glass of water on your bed. If you put it between two pillows, then it's buffered. If you set it by itself, it's not. Now, push on the glass. You can see that the glass without the pillow buffer will fall over. That's akin to a pH crash up or down. Any little process or something can cause the pH to change more drastically when there is no buffer. I just made up that analogy but it sounds pretty good. So, for water with low alkalinity, I suggest adding baking soda. I do put some in my ponds but not my aquariums. I just don't have the time to add and monitor it with all my animals, tanks, and ponds.