CryptoQuant's CEO says meme coins are "dead" as dominance hits 2024 lows. Losses mount, but some believe the bottom is near.