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?

In this dashboard, the transfer of assets between the Avalanche network and centralized exchanges has been investigated.

To track the asset flow between CEXs and the Avalanche network, this dashboard is divided into the following parts:

• General view related to the inflow/outflow to CEXs
• Breakdown by CEXs
• Breakdown by assets
• Net flow analysis on special dates in 2023

Avalanche is a blockchain platform that was launched in 2020. It aims to provide a fast, scalable, and secure network for decentralized applications (dApps) and financial transactions. Avalanche uses a consensus protocol called Avalanche-X, which allows for high throughput and low latency, making it well-suited for applications that require fast transaction speeds.

One of the key features of Avalanche is its subnets, which allow developers to create their own custom blockchains within the Avalanche network. This enables developers to build dApps that can operate independently while still benefiting from the security and scalability of the Avalanche network.

Centralized exchanges (CEX) are platforms that allow users to trade cryptocurrencies and other digital assets. These exchanges are important because they provide liquidity to the market, allowing users to buy and sell assets quickly and easily. In addition, CEXs often offer advanced trading features, such as margin trading and order books, which can be useful for experienced traders.

However, there are also some drawbacks to using centralized exchanges. One of the biggest concerns is security, as these exchanges are often targeted by hackers due to the large amounts of funds they hold. In addition, CEXs are often subject to government regulations and can restrict access to certain users or regions.

Overall, both centralized and decentralized exchanges play an important role in the cryptocurrency ecosystem. While CEXs provide liquidity and advanced trading features, DEXs offer greater security and privacy. As the industry continues to evolve, it is likely that both types of exchanges will continue to coexist and serve the different needs of different users.

The data provided by Flipside has been used to handle this analysis.

• In this investigation, first of all, the centralized exchanges (CEXs) on the Avalanche network are identified based on the labels:

SELECT *  from avalanche.core.dim_labels  where label_type='cex' 

• The inflow and outflow of assets into the CEXs from the Avalanche network have been calculated on a weekly basis.
• The domination of CEXs on the Avalanche network has been determined based on the volume, users, and attraction of new users.
• The most popular assets transferred between CEXs and the Avalanche network are obtained.
• The special events in 2023 have been selected and the net USD flow from the Avalanche network has been estimated on these dates.