Hello! In this dashboard we are going to find out how many active projects are in Near chain, before we start, let's get familair with Near chain itself:

• Near aims to resolve the problem of sharing bandwidth between users and telecom providers. Near Protocol provides a solution that allows users to share and utilize their idle bandwidth through blockchain technologies. In addition, the Protocol offers a way to improve the payment transaction experience. It is a blockchain-based ecosystem that includes a next-generation DApp platform and a private chain with high throughput. Near Protocol will create the foundation for blockchain technology in the telecom industry.

• Also Near allows users to securely hire freelancers from all over the world without any worry about their ID or if they are safe due to blockchain technology being able to verify every transaction. On top of that, it offers up-front payment so that people can be sure they are hiring reliable individuals when there is low downtime between projects and emergencies that will not interfere with payment methods.

Source (text, image): 1 , 2

In this dashboard, this definition will be used for active projects: Active projects are the ones that have gained users' interaction in +100 days of the recent 365 days, in other words the projects that users have done transactions on them in +100 days in the recent year.

For finding different projects I used near.core.fact_transactions and near.core.dim_address_labels tables to track different platforms and sectors (defi, dapps, ecosystem) activity.

Note: Address with token lables have been excluded in this anaylsis, because our goal is to find specific priojetc and platforms, not the tokens!