Solana - Saber Proposals & Gauges
Create a visualization showing the total amount of SBR locked over time and voter participation rates.
What is Saber?
- Saber is an automated market maker and liquidity pool on Solana designed for extremely efficient trading between similarly priced (pegged) assets, without an opportunity cost.
- This trading activity results in fees for providers of liquidity, resulting in a safer, lower-risk staking opportunity representing real world transaction volume.
Asset Types
- Saber generally allows for trading between assets that mean revert in price. There are several assets that Saber specializes in:
- USD Stablecoins: There are hundreds of dollar-based stablecoins in existence, ranging from dollar-backed stablecoins like USDC and Tether, decentralized stablecoins such as UST, and native Solana stablecoins such as Cashio.
- Bridged assets: There are a large number of bridges that lead to Solana, and Saber is the primary liquidity source to exchange between the different bridged assets. One example is the renBTC-BTC pool, which allows swapping between the Ren and FTX versions of Bitcoin. Many stablecoins are also bridged assets; Saber is the primary way for Solana users to navigate between different chains.
- Staking derivatives: Saber is the largest venue for trading SOL staking derivatives such as Marinade SOL and Lido SOL.
Saber Governance
- Proposals
- Gauges
Description of work:
- In this Bounties we want to Create a visualization showing the total amount of SBR locked over time and voter participation rates Including:
- 1- Total amount of SBR locked over time
- 2- Number of wallets that have locked SBR actually voted on a gauge
- 3- Number of wallets that have locked SBR actually voted on a proposal
- 4- Number of wallets that have voted on proposals and gauges
Note:
- We use the
solana
schema andsolana.fact_gov_actions
table
1 ---> Total amount of SBR locked over time
-
In this section we want to get the:
- Total amount of SBR that is locked on a daily basis
- Number of unique lockers on a daily basis
-
We use the
solana.fact_gov_actions
table and get Total amount of SBR locked on a daily basis bysum(amount)
and get Number of unique lockers on a daily basis bycount(distinct signer)
According to the above chart, it can be seen that:
- The maximum SBR lock volume is for Jun 6, 2022, Mar 9, 2022 and Jun 1, 2022, respectively.
- On Jun 1, 2022, we see the largest number of unique wallets that have locked the SBR
- The number of unique wallets that lock SBR is declining over time
- Total SBR amount locked is 513M
- Total unique wallets that have locked SBR is 864
2 ---> Number of wallets that have locked SBR actually voted on a gauge
In this section we want to get the Number of wallets that have locked SBR actually voted on a gauge
- We first get all signer that have locked SBR and join them with
solana.fact_gauges_votes
on signer and voter thencount(distinct voter)
3 ---> Number of wallets that have locked SBR actually voted on a proposal
In this section we want to get the Number of wallets that have locked SBR actually voted on a proposal
- We first get all signer that have locked SBR and join them with
solana.fact_proposal_votes
on signer and voter thencount(distinct voter)
According to the above results, it is clear that the wallets that have locked the SBR are more voted on a gauge
4 ---> Number of wallets that have voted on proposals and gauges
- In this section we want to get the number of wallets that have voted on proposals and gauges
- We first get all signer that have locked SBR and join them with
solana.fact_proposal_votes
on signer and voter and join withsolana.fact_gauge_votes
on signer and voter thencount(distinct voter)
According to the above results, it is clear that the just 7 unique wallet locked SBR and voted on proposals and gauges