Activity with NEAR Blockchain Projects and NEAR Horizon

What Is NEAR Protocol?
NEAR Protocol is a decentralized application (dApp) platform and Ethereum competitor that focuses on developer and user-friendliness. Its native NEAR tokens are used to pay for transaction fees and storage on the Near crypto platform.
What Is NEAR Horizon?
NEAR Horizon is an early stage accelerator revolutionizing how founders and builders find support in Web3. Build and scale great projects alongside a thriving community, while tapping into a robust backer network and diverse supporting resources.
In this dashboard, we are going to do the analysis in two sections. The first section is an analysis of active NEAR projects, and the second section is an analysis of NEAR Horizon and its projects.
The first section
Active projects: Our definition of active projects are projects that have transactions in the last 6 months.
Based on the definition of active projects, we first identify these projects and then analyze their activity including the number of transactions ,the number of users and number of active NEAR projects in the last 1 year.
The second section
In the next section, we have an analysis of NEAR Horizon and its projects. For this purpose, we use the new Flipside near.horizon.fact_decoded_actions
table and obtain metrics such as the number of transactions, the number of users and the number of projects.
Then we visualize these metrics over time based on NEAR Horizon projects.