Solana Protocol Feature

    Q97. Choose a defi protocol from the following list and create a dashboard with the new Flipside layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the protocol and what is happening on it.

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    The following chart shows the number of users who have locked the SBR to receive the veSBR governance token and the amount of SBR they have locked in terms of the day from January 1:

    Loading...
    Loading...
    Loading...

    Introduction:

    Saber is the leading automated market maker (AMM) and a leading DEX built on the Solana blockchain. It is famous for providing diverse liquidity pools, including stablecoin pairs. The governance of liquidity pools has been recently turned into a community-based system. SBR, Saber native token holders, by locking their SBR and obtaining veSBR, can vote for rewards distributions. The Tribeca governance protocol is adopted using these tokens to cast votes for each pool with gauges. The vital part of this protocol is locking native tokens (SBR) on each pool, and the gauges are determined based on the amount of SBR and duration of locked.

    The SBR lockers are the most influential and prominent users in the Saber protocol. Therefore, it is worth studying their behavior.

    db_img

    Methodology

    The solana.core.fact_events and solana.core.fact_swaps tables have been utilized to find the total number of unique users, total transactions, number and amount of swaps per day and to find the amount of staking on Saber.

    On the final part I managed to evaluate SBR locking and found some noteworthy information about that.

    The investigation time of this bounty is since January 1st.

    As can be seen in the diagram, the general trend of token locking has been downward. This downward trend can be interpreted as saturating the willingness of users to invest in government tokens.

    First lets start with the total number of unique users and transactions:

    One of the most important part of each DEX is the number of swappers and amount of swaps per day:

    In the number of unique daily users, Saber has experienced a pick on June 19 th that is a good sign to see that amount of swappers and swaps during the bear market and after that the downward trend has begun.

    In terms of the swap amount like similar with unique users, from the beginning of May (the highest number in on June 18th), a completely upward trend can be seen. After this date, we see a completely downward trend until June 25 th, and again after this date, we can see an upward trend.

    Another noteworthy part that we are going to investigate is the staking activity on Saber:

    From the chart above, we can understand that the maximum number of stake SOLs was on Jan 24, and after that, the number and amount of staking started to decrease. We can conclude that this downtrend is because of continuing bear market that discourages users from staking their tokens on the Defi platforms.

    Concluusion

    During this bounty, we tried to create a dashboard with the new Flipside layout that can refresh once a day, highlighting the total number of users, total number of transactions, number of swappers per day, swap amount per day, staking activity, and Finally locking SBR and veSBR governance token activity that I think are the most critical factors helps show the "health" of the Saber protocol.