The Magic Can
The pushing force of air is called air pressure. The closer you are to Earth, the greater the air pressure. The farther away from Earth (in other words the higher your altitude), the less the air pressure. And remember, pressure is coming from all around us.
When you filled the can only half full, you left some space empty. This space actually was not empty - it was filled with air. Pressure on the lid exerted pressure on this air which in turn exerted pressure on the water forcing it out of the can. When you stop pressing on the lid, and leave your finger over the hole, the pressure of the air outside the can holds the water up from the bottom.