Methodology

Dashboard Objective

Show an Overview of Jumbo Exchange in Near.

Dashboard Structure

What is Jumbo Exchange?
Overview
- When Jumbo Exchange started its activity?
- Transaction Activity
- User Activity
- Gas Fees ($NEAR) Activity
Swap Activity
- Swaps and Swappers
- Swaps IN
- Swaps OUT
$JUMBO Activity
- $JUMBO Swaps in Near
Conclusion
Methodology

Dashboard Method

Using Flipside Tables of Near I'll track the activity of Jumbo Exchange

Table Used for the Overview:

From near.core.fact_transactions 
Where tx_receiver='v1.jumbo_exchange.near'

Table Used for the Swaps:

From near.core.ez_dex_swaps
Where platform = 'v1.jumbo_exchange.near'

Table Used for the $JUMBO Swaps:

from near.core.ez_dex_swaps
where (token_in='JUMBO' or token_out='JUMBO')

Dashboard Sources

Jumbo Image

Jumbo Icon

MetricsDAO Bounty Question

Build a dashboard covering one of the top 10 NEAR projects by TVL featured on Defi Llama (https://defillama.com/chain/Near), a bridge into NEAR or a popular NFT marketplace.

Show the activity and usage of the protocol. Some of the things to look at and consider are the number of unique wallets, asset volumes, swaps, LP actions, or fees- build a dashboard you think the protocol and the ecosystem would find useful to use and monitor the usage of the protocol.

Tips: Break out your sections into tabs if you are using the Flipside App.

Jumbo Exchange Dashboard