I stand corrected, what we are actually seeing is a camera filming at 24fps and its syncing up with the 24 hz sine wave. Therefore it only appears to be unmoving because of the way the camera is filming. At 23 hz they are out of sync by one frame the it appears as though the water is flowing up. Just a consequence of FPS and frequency being slightly different. Either way it is merely a camera trick.