Introduction

Experience the power of data-driven insights as we unveil an array of new labels added to our NEAR labels table. With these labels, we embark on a journey to uncover the projects and project types that generate the highest gas fees, attract the largest user base, and boast the highest number of transactions per user. But that's not all – we take a deeper dive to identify the project types and individual projects with the most devoted and engaged users.

Our dashboard is thoughtfully designed with three interactive tabs, each offering unique perspectives. In the first tab, you'll find a comprehensive overview of the top project types, enabling you to grasp the broader trends in the NEAR ecosystem. The second tab provides a closer look at the leading projects, carefully curated based on the metrics mentioned earlier.

However, we understand that your exploration may require a more specific focus. That's why we've introduced the third tab, a parametrized analysis section. Here, you can effortlessly search for a particular project type and instantly access its detailed statistics, empowering you to gain a deeper understanding of its performance.

Join us on this journey of discovery as we navigate the NEAR blockchain landscape. Our NEAR Labels Dashboard awaits you, offering unparalleled insights into the world of decentralized finance, non-fungible tokens, and more. Start exploring now and unlock the true potential of data-driven decision-making!

Methodology

The design of this dashboard is based on the utilization of two primary tables from Flipside's database: near.core.dim_address_labels and near.core.fact_transactions. These tables serve as the foundation for the data analysis and insights presented within the dashboard.

Thenear.core.dim_address_labels table provides a comprehensive set of labels associated with NEAR addresses. These labels enable us to categorize and classify projects and project types within the NEAR ecosystem. By leveraging this table, we can delve into specific projects and project types, examining their performance metrics such as gas fees, user counts, transaction counts and transactions per user.

The near.core.fact_transactions table encompasses transaction-related data, allowing us to extract valuable information about transaction volumes, user interactions, and other relevant metrics. This table serves as a vital component in evaluating project engagement and identifying projects with the most loyal and active user base.

By combining these two tables, we are able to construct a holistic and comprehensive analysis of the NEAR blockchain. The dashboard's first two tabs incorporate all available Near data, ensuring that no specific date range is imposed, providing a complete and up-to-date view of the ecosystem.

Please note that we exclude Null project types and projects from our queries.