Query Breakdown 🔨

This SQL query calculates various supply metrics related to the NEAR blockchain, taking into account locked and staked tokens. The main objective is to break down the total supply into circulating, locked, staked, and liquid supply on a daily basis.

The query processes data from different tables and views such as near.core.fact_receipts, near.core.fact_blocks, lockup_receipts, and others.

It starts by extracting information about lockup contracts, vesting contracts, staking balances, and daily locked and staked supply. It then joins this data to calculate the total supply, total staked supply, circulating supply, locked supply, and other related metrics. Finally, it outputs the results in a well-structured format providing details for each day from October 13, 2020, onwards.

🙌🏾 Credits to @rmas for the query, I literally had to dump all my queries cause they didn't reach data accuracy.

Near Supply Breakdown