This comprehensive dashboard gives an overview of the popular meme tokens in the past week.

It provides an in-depth analysis of the PEPE token, a popular meme token on the Ethereum blockchain which went viral in the past few days. The dashboard offers valuable insights into the token's performance, Swap Volumes, holders' distribution, and trading activity across different platforms.

Key metrics presented in the dashboard include:

• Daily trading volume: The total amount of PEPE token traded on various DEXes on a daily basis, both in terms of tokens and USD value.
• Transaction volume: The number of transactions involving the PEPE token each day.
• Gas usage: The percentage of daily gas used on the Ethereum network due to PEPE token trades.
• MEV bot activity: Detection of potential MEV bots based on their trading behavior and gas fees spent on PEPE token trades.
• Token holders over time: A historical view of the number of unique PEPE token holders, with day-over-day percentage growth.
• Holder distribution: A breakdown of PEPE token holders by balance tiers, labeled as whales, sharks, crabs, shrimps, and pepes, along with the percentage of total holders in each tier and their net worth.
• Liquidity: The amount of PEPE token locked in liquidity pools across various DEX platforms, both in terms of tokens and USD value.
• Swap Volume: Total volume in swaps across platforms in USD.
• 24-hour volume by platform: The trading volume of the PEPE token on different DEXes in the past 24 hours, grouped by platform and represented in USD.
• It offers the users the capability to input the contract address of their token to find all of these above mentioned stats

By examining these metrics, users can gain a comprehensive understanding of the PEPE token's market dynamics, liquidity, and holder distribution, enabling them to make informed decisions about their investments and trading strategies.

The methodology for compiling this dashboard involves aggregating data from various Ethereum blockchain tables and cross-chain tables, specifically targeting the PEPE token. We extract relevant information on trading volume, gas usage, token holders, liquidity, and other metrics by utilizing SQL queries to process and analyze the raw data. These queries are designed to be flexible and adaptable, allowing users to input different token contract addresses as parameters to analyze other tokens of their choice.

Tables in use:

- ETHEREUM.core.fact_transactions
- ETHEREUM.core.ez_dex_swaps
- ETHEREUM.core.ez_current_balances
- crosschain.core.ez_hourly_prices
- ETHEREUM.core.dim_dex_liquidity_pools
- ETHEREUM.core.fact_event_logs
- ethereum.core.dim_labels
- crosschain.core.address_labels 

Parameters:

token-contract: this is the contract address of the token. Default value is of $PEPE token.

time-range: use this to toggle between daily and hourly bar graphs in trading volume tab. Use day for daily bar chart.

TopXHolders: use this to specify the number of top holders user wishes to see in Token Distribution tab. Defaulted to Top 10 Holders.

I've spent considerable time and effort on preparing this dashboard giving useful insights to traders who look to ape in. If you like the dashboard, follow me on twitter for similar analytics and please do provide useful feedback.

Look out for ✰NEW charts added every week. HINT: Token Distribution Tab has alpha :)

Twitter: @zakkisyed Data Collective: @0xTheWatchmen

Check out my other Dashboards on Flipside: zakkisyed

Discord : zakkisyed#0297

Analysis for @MetricsDAO