I don't know when the term was used for the first time. It is a universal term and is an expression to express approval, happiness, joy and/or excitement. In the juggaloworld it is offen used as a greeting and means "What's up, ninja"

If you shout a whoop whoop in a crowd of juggalos you definitely get a lot of whoop whoops back.

Whoop Whoop...