Near is a blockchain platform that is designed to enable developers to build decentralized applications (dApps) and create decentralized finance (DeFi) solutions. The Near blockchain is unique in that it is designed to be user-friendly, scalable, and efficient. This means that it can handle a large number of transactions quickly and at a low cost. This makes it an attractive option for users who are coming from centralized exchanges (CEXs).

One of the key benefits of the Near blockchain is its ability to facilitate the flow of assets between centralized exchanges and decentralized applications. This means that users can move assets between CEXs and dApps seamlessly, without having to worry about high transaction fees or long wait times.

Another benefit of the Near blockchain is its growing ecosystem of dApps. These dApps cover a wide range of use cases, from gaming and social media to finance and governance. This means that users who are coming from CEXs can find a variety of dApps that suit their needs and interests.

Overall, the Near blockchain is an attractive option for users who are coming from CEXs because of its scalability, efficiency, and growing ecosystem of dApps. As the blockchain industry continues to grow and evolve, Near is poised to play an increasingly important role in the space.

In this dashboard, I conducted a comprehensive analysis of NEAR inflows and outflows from centralized exchanges (CEXs) over time. By exploring multiple metrics, I aimed to answer key questions such as: when did NEAR experience the highest activity, which CEX led others in terms of traded flows, and how did receivers from CEXs on NEAR interact with various NEAR sectors, particularly dApps?

To conduct this analysis, I utilized the near.core schema provided by Flipsidecrypto and primarily leveraged the fact_transfers table to gather transfer data and the dim_address_labels table to identify CEXs and dApps. Through this approach, I was able to gain a comprehensive understanding of NEAR's interaction with CEXs and dApps, enabling me to identify trends and insights that can inform future decision-making.