Methodology

Dashboard Objective

Show $JOE Activity and Achievment in the 2 years active on Avalanche.

Dashboard Structure

Introduction
Mints, Supply & Price
- Mints and Supply of $JOE
- $JOE Price (USD)
Holders
- Holders of $JOE
- Distribution of $JOE Holders
- The Top 10 from before - Additional Metrics.
Transfers
- Active Users and Transfers with $JOE
- Transferred $JOE Volume
Swaps
- Swaps Activity
- Trading Pair Activity
- Top 5 Trading Pair with $JOE
Key Takeaways
Methodology

Dashboard Method

Using Flipside Tables of Avalanche I'll track the activity of $JOE Using:

Contract Address for $JOE:
0x6e84a6216eA6dACC71eE8E6b0a5B7322EEbC0fDd

Table used for $JOE Price:
avalanche.core.fact_hourly_token_prices

Table used for $JOE Supply, Transfer Volume and Holders:
avalanche.core.fact_token_transfers  

Table used for $JOE Swaps
avalanche.core.ez_dex_swaps

To Get Mints I filtered by Activity from the Root Address:
0x0000000000000000000000000000000000000000

Additional Information:
When I got the $JOE Holders the volume for the top addresses is equal to the one shown in the Avalanche Scanner.

However the Holder's Information isn't the same, and I used the Correct Methodology, filtering by holders with only positive balance (After adding their (receive-sent) balance through Union All or Join), and I couldn't find the reason.

Dashboard Sources

Trader Joe Logo by Cryptologos AltCoinsBox

Trader Joe Image by JoeContent

Trader Joe Guide by Coinmonks

MetricsDAO Bounty Question

Follow the following AVAX influencers and tune into what they are paying attention to! Choose a topic from one of the twitter threads below and create a dashboard covering the topic, protocol, project, etc that is featured in one of their tweets.

Important:

Make the title of your dashboard relevant to the project or topic you are covering.

Next, respond to one of the tweets in the twitter thread or one of the "quote tweeted" tweets with an insight or twitter thread from your dashboard that will strengthen the narrative they are sharing.

There is no need to mention this is a MDAO challenge as a part of your tweet- keep it authentic and real!

Feel free to share

Twitter Threads & Influencers To Watch :

https://twitter.com/CaesarJulius0/status/1673055825949065219

https://twitter.com/Ommiii/status/1672187331753938944

https://twitter.com/demirelo

Note:

If one of these CT Influencers releases a new twitter thread, feel free to cover a topic in that twitter thread.

Two Years of $JOE