Makes your jaw drop in amazement

It's definitely a downspout. That fitting on the bottom is a receiver for pipes under the concrete.

Looks to me like a downspout that carries the "water" under the concrete and probably lets out somewhere else.

That's a downspout. In a lot of countries they hook up to a municipal stormwater system

*by which i mean the piping leads to street gutters