Why is there a squeal as you turn off the water faucet?

That squeal you here is a very acute vibration that comes from the washer as it touches down on the base of the tap, it is normally caused due to very high water pressure.