That’s assuming the valve is open all the way and that there’s a bunch of water pressure behind the spigot. It should be entirely possible to create a very slow trickle by having a massive body of water behind the spigot (making it functionally infinite) but having only a small part of the entrance beneath the surface.