Methodology

Dashboard Objective

Explain the Impact of AlibabaCloud Partnership with Near, Show an Overview of Validator Activity and Staked $NEAR in the Blockchain. Show Liquidity Staking Protocols Effects in the Staked Supply of $NEAR.

Dashboard Structure

Introduction
Overview
- Activity in Near After the Announcement
- $NEAR Staked Supply
- Yield on Near Staking
Validators
- Validators in Near
- Active Validators and Seat Price - Change over Time
- Validators by Pool Type
- Stake Pool Size ($NEAR) of Active Validators
Liquidity Staking Protocols
- Liquidity Staking in Near
- Liquidity Staking Protocols in Near
Key Takeaways
Methodology

Dashboard Method

Using Flipside Tables of Near I'll track the activity using:

Table Used to get Near Activity:

near.core.fact_prices - Price of $NEAR
near.core.fact_transactions - Transactions and Active Users

Table Used to get Validators:

near.core.fact_staking_pool_daily_balances - Validators Addresses and Stake Pool Size


About the Data Sources:

I Forked Rmas SQL from its dashboard 
https://flipsidecrypto.xyz/rmas/near-validators-and-staking-FOhH36

Most of the Charts Related to Stake, Liquidity Stake Protocols, and Validators have Forked Rmas Source Code.

However, I take my analysis in another Direction with the goal of adding value with different kinds of Charts and date aggregation.

At the end of each Source Code from my Charts is possible to see my adjustments to the Forked SQL Code.

Dashboard Sources

Near + Alibaba Image from Near Blog Post Article

Stake Wars Image from Near Blog Post Article

Near Logo from Cryptologos

Rmas Dashboard

Near Explorer (Validators)

MetricsDAO Bounty Question

CoinDesk Article
In the article above you can read about NEAR’s upcoming collaboration with Alibaba Cloud. This collab is going to boost the visibility of NEAR in APAC and make it easier for Alicloud users to spin up NEAR validators, hosted on there. Please research some insights into validators on NEAR:

Number of validators

Seat price

Validators using poolv1.near vs pool.near, the new updateable pool factory

NEAR staked per validator in the active set

NEAR staked total

Effects of liquid staking solutions

Yield on NEAR staking

NEAR partners with AlibabaCloud