Open Analytics Bounty: ETH (September 25)

    Open analytics bounties are all about deep dive dashboards into one specific topic.

    Loading...

    What is the purpose of this dashboard?

    As you know, we have three different versions of AAVE, in this dashboard, we want to compare things like borrowers, depositors, and transactions in different versions and wallets.

    Loading...
    Loading...

    AAve Borrower and Transactions count

    In the first step, we want to measure the ratio of borrowers and the number of transactions in different versions of AAve

    Loading...
    Loading...

    The selected period is 90 days. As you can see,Aave v2 has significantly more values than versions Aave V1 and Aave V2 so we decided to focus more on Aave V2.

    The top left graph shows daily borrowers in the last 90 days. As you can see, the graph fluctuates a lot, but it reached its highest value on August 14 and 15.

    In the graph on the right, which shows the number of daily transactions, we have the highest value on September 2

    AAve Depositors and Transactions count

    In the second step, we want to measure the loan ratio of depositors and the number of transactions in different versions of AAve.

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

    As you can see, Aave v2 has the same values compared to the borrowers, in the deposit mode, it is still significantly higher than the Aave V1 and Aave Amm versions, although the other versions are slightly higher than the borrowers in the deposit mode.

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

    Deposit and Withdraw in ez_eth_transfers table

    in this step, we want to check the depositor, an average of the deposit and after that check, the withdrawers, withdrawals and withdraws in ez_eth_transfers table. after that compare them to gather.

    Group 1: Daily Depositor and Withdrawer

    As can be seen in the two charts above, both charts have almost the same behavior, when the deposit increased, the borrower's also increased. For example, we can refer to July 26 or August 4, in fact, this relationship is a direct relationship

    Group 2: Daily Deposit and Withdrawals

    It is very normal that group 2 charts behave similarly to group 1 charts. Because as deposits increase naturally the number of depositors also increases, but this is not always the case as sometimes a whale can deposit a large amount and support a large number of borrowers.

    Group 3: Daily average of Deposit per depositor and Withdrawals per withdrawer

    As you can see, withdrawals have a more regular trend than deposits, but in general, a downward trend and then a slow upward trend can be considered for withdrawals, but in deposits, the beginning and end of the chart are almost the same, but during The average deposit period has decreased

    Find sensitive points

    At this point, we want to review the most important ones together

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