Algorand Week: Gard + Yieldly 2022 Yieldly Staking Pool Analysis

    in this work we want to find the most popular Yieldly staking pools by Amount of YLDY staked, Total number of stakers, Average amount staked, number of addresses participating in Yieldly staking Pool in 2022, wallets participating in staking pools but committing less amounts, ALGO price impact the number of users participating and staking pools and find standout wallets that have staked in a lot of these Yieldly staking pools

    Question1: Yieldly staking pools by the amount of YLDY staked

    we extract application ids related to all Yieldly staking pools from https://app.yieldly.finance/pools. then we do a left join on application_call_transaction table and asset_transfer_transaction using tx_group_id field, then we group results on days of year and application id of pools to find the amount of YLDY staked in pools during 2022. Results and charts are shown below.

    Loading...
    Loading...

    According to the chart above, it can be concluded that YLDY/ALGO pool has the highest staked amount with 39.5%. AKITA with 12.7%, NURD with 9.67%, and ARCC pool_2 with 7.67% are in the following ranks.

    Question 2: Yieldly staking pools by the amount of YLDY staked daily

    To answer this question, we use the results of the previous question.

    Loading...

    According to the chart above, it can be concluded that The YLDY / ALGO pool has the highest volume of staked Yieldly during the days of 2022, and also staked amounts of Yieldly in this pool increased daily since 2022. From Mar 13 to Mar 17, the amount of staked Yieldly decreased in all pools sharply and then increased again.

    To answer this question, we act like the previous question, with the difference that we group the obtained records only based on the application id of the pools to find top 10 popular Yieldly staking pools. Results and charts are shown below.

    Loading...
    Loading...

    Total number of addresses participating in Yieldly staking Pool

    To answer this question, we need to find the number of unique addresses that stakes Yieldly in the relevant pools in 2022.

    Loading...

    Total number of addresses staking in Yieldly Staking Pool per pool

    Loading...
    Loading...

    According to the chart above, it can be concluded that the YLDY/ALGO pool has the highest number of staking addresses and 24.06 of all 25.42 stakers are in YLDY/ALGO pool(about 95%).

    Average amount staked in Yieldly staking pools

    Loading...
    Loading...

    Staking pools participants over time

    Loading...
    Loading...

    Based on the above results, we can see that participation in the staking pools is in a downward trend.

    Wallets participating in staking pools in 2022

    Loading...
    Loading...

    Wallets participating in staking pools but committing less amounts in 2022

    Loading...
    Loading...

    According to the chart above, it can be concluded that Participation in all staking pools is in a downward trend, and from Mar 13th to Mar 17th, we see the lowest participation in staking pools. also for ALCH Pool, we have can see an increase in participation since Apr 18th

    ALGO price impact the number of users participating and staking pools

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

    According to the chart above, it can be concluded that Algo's price is in a downward trend in 2022 and this downward trend has not had an effect on staking pools amount. The downward trend in Algo prices has a direct impact on the number of participating users

    The number of wallets that have the most participation in the pools with staked amount

    Loading...

    According to the chart above, it can be concluded that 'NLRIBKJZEUCRLYZY72Z3GQW4ROJYCRZIOOABXDTZKFPLJGVBMFA3GZB5SE' address participates in all 27 staking pools and has the highest Yieldly staked amount.