• Memecoins activity
• Transactions 💱
• Users 🧑‍💼
• Volume 💰
• Correlations 📈
• Prices 💹
• TL;DR & Conclusion 📃

Welcome to meme cryptocurrency dashboard!

Meme cryptocurrencies are a unique class of digital assets that have gained popularity thanks to their meme-inspired branding and often humorous marketing tactics. While some may view these tokens as nothing more than a joke, others see them as a potentially lucrative investment opportunity. In this dashboard, we will be analyzing several meme cryptocurrencies, including Dogecoin (DOGE), Shiba Inu (SHIB), Floki (FLOKI), DogeElon Mars (ELON), Pepe (PEPE), and Chad Coin (CHAD).

In this dashboard I will analyze 6 tokens: DOGE, SHIB, FLOKI, PEPE, CHAD, ELON. I use table bsc.core.ez_token_transfers for doge and ethereum.core.ez_token_transfers for all the other tokens to get the statistics like number of transactions, number of users (wallets that transacted the given token) and volume (sum of amount transfered).

To get the prices of those token I use ethereum.core.fact_hourly_token_prices and bsc.core.fact_hourly_token_prices tables.

Further I use builtin CORR function to get the correlation coefficient of the prices of memecoins.

Correlation coefficient is a measure of the strength and direction of the relationship between two variables. It is a number that ranges from -1 to 1, where -1 represents a perfectly negative correlation (when one variable goes up, the other goes down) and 1 represents a perfectly positive correlation (when one variable goes up, the other also goes up). A correlation coefficient of 0 means that there is no linear relationship between the two variables. The closer the correlation coefficient is to 1 or -1, the stronger the relationship between the two variables.

🐦 twitter.com/mondov_dev