Why is frequency different for gravitational waves coming from SMBHs vs small compact binaries? Why do gravitational waves emitted by supermassive black holes binaries have low-frequency range (~10$^{-9}$ - 10$^{-2}$ Hz) than those emitted by stellar mass compact binaries (~10$^{-4}$  - 10$^2$ Hz)?

Below, a NASA graphic showing the wavelength ranges of various phenomenon found here. Click for full size.
The reason for the upper limit is that gravitational force scales as the product of masses over separation squared and that the closest approach of black holes is limited by their event horizons. The lower limit is because the amplitude of the waves gets smaller and becomes undetectable at lower frequencies.

In more detail:

The frequency of gravitational waves is twice the orbital frequency.

Kepler's third law tells us that the orbital period $P$ is related to the total mass $M$ and orbital separation $a$ as
$$ P^2 \propto M^{-1} a^3 $$

The orbital frequency $\omega =2\pi/P$ so
$$\omega \propto M^{1/2} a^{-3/2} \tag{(1)}$$

The frequency of gravitational waves therefore depends on both the mass and separation of the binary system.

However, the maximum frequency occurs at closest approach, which for black holes is when their event horizons come into contact. The Schwarzschild radius is $2GfM/c^2$, where $f$ is the fraction of the system mass of each black hole. Thus the closest separation $a_{\rm min}$ is the sum of the Schwarzschild radii and is simply $2GM/c^2$, since $f_1+f_2=1$.

Using $a_{\rm min}$ for $a$ in equation (1) we see that the maximum frequency
$\omega^{\rm max} \propto M^{1/2}a_{\rm min}^{-3/2} \propto M^{-1}$
Thus the maximum frequency gets bigger as the mass gets smaller, and as supermassive black holes are a million to a billion times more massive than stellar black holes, the maximum frequencies are correspondingly smaller.

The lower limits to frequency are not really limits at all. The frequencies can be anything smaller than the maximum. However the amplitude of the gravitational waves depends on the acceleration of the masses, which in turn decreases as they become more widely separated. This effectively gives a window between where the waves become detectable and the maximum frequency.