Avalanche Cex Inflow and Outflow
A dashboard that shows the Inflow and Outflow of assets from the Avalanche-c chain to Centralized Exchanges (Cexes) and Vice Versa.
This dashboard is divided into three tabs:
-
Cex Volume: This tab shows inflow and outflow of assets from the Avalanche chain to Centralized Exchanges and from centralized exchanges back to the chain. It is further broken down into total cex volume, cex volume by a particular cex, cex volume by assets.
-
Cex Users: This sections shows the users responsible for the volume on the first tab. There is a table that shows most active users based on the last 24hours, there are also visuals for total cex users, users based on cex, and users based on asset type.
I Used the avalanche.core.dim_labels
table and made sure I only got deposit addresses when analyzing assets outflow.
where label_type = 'cex' and label_subtype != 'hot_wallet'
And filtered to get only hot wallets when analyzing assets inflow to the avalanche chain.
where label_type = 'cex' and label_subtype = 'hot_wallet'
I mostly used the avalanche.core.ez_token_transfers
table where I got specifically tokens transfered to and from centralized exchanges.
How To Use Parameters
- Date_trunc: Type in either day, week or month inside the input in other to view the data based on a daily, weekly or monthly basis. Note, it is currently set to week.
- Start_Date: Input the date which you want to start viewing the data from. For Example all data starts from the first week that ends in January.
- End_Date: This input is for the date you want to stop viewing data from. Currently set to the Month of May so as to cover all current time periods. When done adjusting inputs click on the Apply all parameters.
What is Avalanche?
- Avalanche is a high-performance, open-source blockchain platform that aims to provide fast and highly scalable network infrastructure for decentralized applications (dApps) and enterprise blockchain solutions. The platform utilizes a consensus mechanism called Avalanche consensus, which is designed to facilitate rapid consensus among network participants and enable interoperability with other blockchain networks. Avalanche supports the development of smart contracts using the Solidity programming language, and provides a wide range of tools and resources for developers to build and deploy their own decentralized applications.
Dashboard Introduction.
- This research examines the inflow and outflow of assets between centralized exchanges (CEXes) and the Avalanche-c chain. It explores the total volume of assets moved, the top CEXes by volume and user activity, and the most traded assets between CEXes and the Avalanche-c chain. Additionally, the research investigates the net positive and negative flow of assets and user behavior over time. The findings provide insights into the trends and patterns of asset movement between CEXes and the Avalanche-c chain, which can inform investment decisions and improve understanding of the crypto market based on the selected time frame.
