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
    db_img

    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 and solana.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 by sum(amount) and get Number of unique lockers on a daily basis by count(distinct signer)

    Loading...
    Loading...

    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
    Loading...
    Loading...

    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 then count(distinct voter)
    Loading...

    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 then count(distinct voter)
    Loading...

    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 with solana.fact_gauge_votes on signer and voter then count(distinct voter)
    Loading...

    According to the above results, it is clear that the just 7 unique wallet locked SBR and voted on proposals and gauges