Dashboard Structure

Introduction
General Overview
Types of Supply
- Liquid $NEAR
- Locked $NEAR
- Staked $NEAR
Conclusion
Methodology

Dashboard Method

Using Flipside Tables of NEAR I'll track the supply of $NEAR:

To get the Total Supply:

near.core.fact_blocks 

Get the Max(Total_Supply) per Month

To get the Staked Supply:

Get Transactions from near.core.fact_actions_events_function_call 
where method_name = 'deposit_and_stake'

And then using the logs from

near.core.fact_transactions

I get all the staked amount per validators, finally add all per Month.

To get the Circulating Supply:

Using the Data from https://explorer.near.org/stats I create a table with values from each Month.

After that I join every supply using the Month and get the Liquid and Locked Supply:

Locked Supply = Total Supply - Circulating Supply
Liquid Supply = Total Supply - Locked Supply - Staked Supply.

I used this Query From JackGuy as reference in how to calculate the supply https://flipsidecrypto.xyz/jackguy/q/2023-04-16-07-41-pm-HB6HaY

Dashboard Sources

Near Explorer Stats

Near Token Supply

Near Logo

MetricsDAO Bounty Question

The goal of this is to create a dashboard that breaks out the circulating supply of NEAR into staking, locked and liquid NEAR. You can use the circulating supply stat chart on the NEAR Explorer as a guide for total circulating balance https://explorer.near.org/stats .

We want to show net staked NEAR, net locked NEAR, and net liquid NEAR over time. The staked portion can be accomplished with the factstakingpool_balances table. Locked NEAR will need to be calculated by tracking funds disbursed by the contract lockup.near. An important note: locked NEAR may or may not be staked!

Ideally this dashboard will have an aggregated view of staked NEAR, locked NEAR, and liquid NEAR over time. This dashboard will also have 3 separate charts illustrating, locked, staked, and liquid NEAR over time. Lastly, this dashboard will have inflow/outflow for each locked, staked, and liquid NEAR over time.

Tips

Use the lockup.near address to determine gross locked NEAR.

An example workflow can be found in this contract address: https://nearblocks.io/address/edf7be8afbd206f6948daf68e79e83a5bfa0adbe.lockup.near

The first transaction on that contract is an example of locking NEAR, with the first receipt including important metadata like the owner account and lockup period https://nearblocks.io/txns/83vSUu6qXhYBnwMD4SvCt3jqreBgc7fqJCorREyjq62p#execution

$NEAR Supply