⚫Near Protocol

Near Protocol, is a decentralized blockchain platform designed to enable the development and execution of decentralized applications (dApps). It aims to provide a scalable, secure, and developer-friendly environment for building blockchain-based applications.

Near Protocol utilizes a unique consensus mechanism called "Proof of Stake" (PoS), which allows network participants to stake their tokens and validate transactions, contributing to the overall security and governance of the network. Near Protocol employs sharding techniques to divide the network into smaller parts, called "shards," enabling parallel processing and increasing the network's capacity to handle a large number of transactions. Near chain provides a user-friendly development environment with a range of software development kits (SDKs), tools, and libraries, making it easier for developers to build and deploy dApps on the platform.

Considering that a plethora of new labels have been added to Flipside's NEAR labels table, we decided to create a dashboard to analyze all projects and project types in terms of the number of transactions, the number of users, and the amount of generated fees. Sticky users are the users who demonstrate a high level of loyalty and retention towards a particular project. These users have a strong attachment to the projec. They continue to engage with the project over an extended period, recording a lot of transactions. Therefore, we also evaluated the performance of these users.

In this dashboard, Flipside database is used to extract data. As mentioned in the previous section, considering that a plethora of new labels have been added to Flipside's NEAR labels table, we examined the data of the near.core.dim_address_labels table. To obtain information such as the number of transactions and the number of users of each project, as well as the amount of fees generated by each project, we joined Table near.core.dim_address_labels with Table near.core.fact_transactions. Readers of this dashboard can get their desired results by specifying the following input parameters:

1- Transaction_Status: This entry can be "Success" or "Fail". According to this input, the results change as follows:

• Number of successful/failedtransactions for each project
• Number of users of each project who recorded successful/failed transactions.
• Amount of fees from successful/failed transactions generated by each project.

2- In this section, by selecting the time range, you can receive the results in the desired time period. In addition, by selecting Month, Week, Day options, you can see the results in these time formats.

3- Pproject_Type: In the third section (Custom Project Type), you can see the number of transactions, the number of users and the fees generated by projects related to that Label (project type) by choosing the type of project you want. A list of all Project Types is shown in the table below.

🔔 In this dashboard, whenever the word Label is used, the author means Project type.

The results show that there are a total of 26 project types in the near.core.dim_address_labels table. On the other hand, 979 distinct projects are also found in this table. On average, there are 232 active projects and 19 types per month. Examining the data shows that the token label has the largest number of projects with 513 projects. dapps and ecosystem labels are in the next ranks with 85 and 65 projects, respectively. 7 types of projects were found, each of which contains only one project. In January 2021 there were a total of 10 labels and 23 active projects, but in January 2023 the number of active labels increased by 120% to 22 labels. The number of active projects reached 284 active projects with a growth of 1134%.