In order to watch this solution you need to have a subscription.
So I understand that the pressure pushing up counters the pressure pushing down but only results to a zero net pressure.
So in reality, the water is only kept from moving [up or down] and does not actually come out of the faucet.