Methodology:

Dashboard consists of several tabs:

• Overal stats shows the overall activity of flows in aggregated state as well as some metrics for both directions like total transferred Near volume, number of transactions, unique users. Also there you can see Net volume.
• Flows by CEX reveals inflows and outflows by CEX.
• Users & dApp usage Breakdown In this tab I've made a breakdown of users based on their activity and found the most active ones. Lastly I've tracked the dApps where users send their assets from CEX.

To perform this dashboard I have used 2 tables from the Near scheme on Flipside.

near.core.dim_address_labels was used to extract users CEX and Dapp addresses filtering with label_type = 'cex' and label_type = 'dapp'

near.core.fact_transfers - was used to track the token transfers itself in both directions from Near to CEX and vice-versa.

For creating table with Inflow transactions I've merged near.core.fact_transfers with CEX addresses on near.core.dim_address_labels by using the following condition on transfers.tx_signer = cex_addresses.address. In case of analysing Outflow activity I've used on transfers.tx_receiver = cex_addresses.address

Introduction:

Near Protocol provides a scalable, secure, and user-friendly platform for building decentralized applications. Its low transaction fees, interoperability and security features making it a promising platform for developers looking to build the next generation of decentralized applications.

Centralized exchange (CEX) is a platform that facilitate the trading of cryptocurrencies for assets including crypto and fiat currencies. As such, CEX acts as intermediaries between buyers and sellers. Since these exchanges are managed and maintained by a central organization, investors essentially put their trust in them to safely complete their transactions and to even safely hodl their precious crypto assets. Learn more about CEX

---

In this dashboard I'll dive into inflows and outflows of assets from Near ecosystem to CEX and vice-versa for last year in monthly dynamics.
I've considered the following technical terms as:

• Inflow - users sending their assets from CEX to Near ecosystem
• Outflow - users sending their assets from Near ecosystem to the CEX
  
• Net volume = ( Inflow - Outflow )