Methodology

Dashboard Objective

Show Avalanche CEXes Activity and Volume Flows, and their popular assets.

Dashboard Structure

Introduction
CEX Comparison
- Activity of CEXs in Avalanche
- CEXs Comparison in Avalanche
Assets Comparison
- CEX Flows by Assets
- Total Activity of CEX Flows by Assets
User Behaviour
- How Avalanche Users Fund Their Wallet?
- Users Retention from CEX
Conclusion
Methodology

Dashboard Method

Using Flipside Tables of Avalanche I'll track the CEX activity.

Table Used to track all CEX Wallets:

avalanche.core.dim_labels (WHERE label_type = 'cex')

Table Used to track CEX Transfers:

avalanche.core.ez_avax_transfers
avalanche.core.ez_token_transfers

Table Used to track first transaction received:

avalanche.core.fact_transactions

Dashboard Sources

Avax Logo used in the Tabs and Introduction by Cryptologos

Centralized Exchange Image

Binance Logo

Avalanche Ecosystem by The Tie

Avalanche by Wikipedia

MetricsDAO Bounty Question

Using the labels table create a dashboard that illustrates the inflows and outflows of assets from Avalanche. Look at items such as number of users and volume by CEX. Another thing to look at is which CEXes brings in the most active users to the ecosystem?

CEX in the Avalanche 🌊