Introduction:

The intriguing life cycle of a meme, particularly when seen through the lens of cryptocurrency, is a fascinating study. From their inception in the creative corners of the internet, to their meteoric rise and inevitable fall in the digital financial markets, memes have evolved beyond simple humor to become potent economic forces. We've recently observed an intriguing ebb and flow in the arena of memecoins, a phenomenon that prompts a multitude of questions: What is the source of this sudden influx and subsequent ebb of liquidity? Are we witnessing a return to a more conservative, risk-averse mentality among investors? In this analysis, we will delve into these questions by focusing on the recent trajectories of two memecoins - $pepe and $shib. The former represents the new generation of memecoins while the latter stands as a representative of its predecessors. Our exploration aims to unpack the intricacies of their respective rises and falls, track the ebb and flow of their liquidity, and understand their broader impacts on the financial sector. Through this comparative study of $pepe and $shib, we hope to illuminate the underlying patterns and principles that drive this unique digital currency sector.

Methodology:

In this dashboard we are going to be looking at data from these three tables: from ethereum.core.ez_token_transfers, ethereum.core.ez_dex_swaps, and ethereum.core.fact_hourly_token_prices. We are going to be using the swap and transfer tables in order to deteremine the activity of these coins both overtime and overall. We are going to look into the prices table to see if these coins follow similar trends and how they both devleoped over time.

Definitions:

What is SHIB?

Shiba Inu (SHIBUSD) is an Ethereum-based altcoin (a cryptocurrency other than Bitcoin) that features the Shiba Inu—a Japanese breed of hunting dog—as its mascot. Shiba Inu is widely considered to be an alternative to Dogecoin; in fact, proponents of Shiba Inu tout it as "the Dogecoin killer."

What is Pepe?

Pepe Coin ($PEPE) is a popular memecoin built on the Ethereum blockchain. Since its public launch in April 2023, Pepe Coin has quickly become one of the top 50 traded cryptocurrencies.

Memecoins and the market