Methodology:

To perform this dashboard I primarily utilized the following tables core.fact_transactions core.dim_address_labels and horizon.fact_decoded_actions from Near scheme.

core.fact_transactions table was used to track all the projects activity. Project names were pulled up by using this statement fact_tx.tx_receiver = labels.address

Dashboard consists of two tabs:

• The Active projects tab provides insights into the activity of projects, including user interactions categorized by project type. It also includes an analysis of the top 10 Near projects based on interactions and the number of active users.
• The Near Horizon activity tab primarily showcases the overall activity of the Near Horizon smart contract and the interactions of added projects with Near Horizon itself .

Intoduction:

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.

Projects on the Near blockchain have the potential to drive ecosystem growth, promote innovation, attract users, and contribute to the development of a thriving and sustainable blockchain ecosystem. Their diverse applications, technological advancements, economic impact, and community engagement collectively contribute to the success and maturation of the Near ecosystem.

NEAR Horizon is an exciting opportunity for founder teams looking to build their startups on the BOS. Startups can interact with NEAR Horizon through a double sided marketplace application that connects founders to each other, and to the people and organizations who are best able to accelerate their growth Learn more

---

This dashboard offers a comprehensive analysis of active projects on Near blockchain. Additionally, Near Horizon was separately analyzed. For a project to be considered active during the review period, it must have had at least one interaction. The analysis covers a date range starting from the beginning of the year, and all metrics are considered on a weekly basis.

During the analysis, I will examine the activity of projects and the distribution of projects by type on Near. Additionally, I will highlight the top 10 projects with the highest number of active users and the most interactions. The analysis will focus on a weekly basis and cover the period starting from the beginning of the year.