It's called the Archimedes Screw and is hundreds of years old. Is very common in third world countries even today.
https://www.google.com.au/search?q=spiral+water+pump&tbm=isc...