My understanding is that the name 'guppy' came from the Boeing CEO. The story goes:
There was a 747 (whale) on the ramp next to a 737.
The Boeing CEO said that the 737 looked like a guppy next to the whale.

FWIW.
I have never verified whether or not it's true.