I did a small test of water displacement in sand. I used a 1 gallon container packed and filled with sand. I was able to add just shy of a 1/2 gallon of water.
Therefore, if you create a sand cistern with a volume of 1,000 gallons, you can store about 450 gallons of water.
The cool thing is that the water gets filtered. No worries about bird poop, dust, bugs, rodents, or other debris getting into your water.