NEAR is a blockchain platform that hosts a multitude of projects built on its infrastructure. These projects harness the power of NEAR's blockchain for a wide range of applications, including decentralized finance (DeFi), gaming, digital identity, and more. Users actively participate in these projects by interacting with decentralized applications (dApps), engaging with smart contracts, and utilizing tokens within the NEAR ecosystem. The usage by users varies across projects, depending on their specific functionalities and purposes. Overall, NEAR blockchain projects empower users to explore innovative decentralized solutions and benefit from the advantages offered by blockchain technology.

In this comprehensive dashboard, I have conducted a thorough analysis of NEAR projects starting from the beginning of 2023. Additionally, I have included NEAR Horizon projects, focusing on their performance since the launch of Horizon in late April. To customize the timeframe for NEAR Projects, you can effortlessly modify the "Days_Ago" field located at the top of the dashboard.

To accomplish this analysis, I have leveraged the near.core and near.horizon schemas provided by Flipsidecrypto. For NEAR projects, I utilized the "fact_transactions" table, while for Horizon projects, I examined the "fact_decoded_actions" table. By joining these tables in the "dim_address_labels" table, I was able to accurately identify the names of the respective projects.

Also i analyzed NEAR projects in past 30 days and considered top 5 projects with the most number of transactions and users as most active projects on NEAR chain in past month.