• The top ten suppliers and the actual amount they sent are listed on the left in a column form.
• In all the percentage wheels above we can see that USDC takes the first spot with over 43% supply asset, over 31% supplier and 51.5% supply amount.

• In the two first graphs bello we can see how much of each asset has been supplied to the protocol.
• For example on Nov 6th, 4691 USDT assets were supplied to the protocol the rest of the assets can be seen by double clicking on their name in the legend.
• On the same day as the last line 4673 suppliers sent the amount of assets on that day to the protocol.
• In the second row we see the amount or volume per asset and the graph on the right shows us how much volume was supplied on each day and how much has been withdrawn.

• The daily transactions and daily unique use count of the protocol is shown bellow in the first two graphs.
• We can see the peek of activity in Aug 5th and Oct 11th where the most transactions and a noticeable amount of unique users are shown.
• In the first percentage wheel we can see that over 42% of transactions were supply actions.
• And the unique user who supplied are 37.5% of the whole unique user base.

• According to the stats bellow we can see that 4.23B worth of volume were supplied in 111.3k number of transactions by 29.1k unique users.
• The daily unique suppliers and transaction numbers per day is broken down in the second row of graphs and we can see the peeks in Oct 5th and 8th and 18th and Nov 6th.
• Most of the supply amount got transferred on Aug 4th and over 900M.

• The percentage wheels above tell us that total borrow per assets first place is for USDC with 62.7% of total asset counts. The unique borrowers for USDC conclude 57% of total unique user count. Finally we have the volume of borrowed per asset which in the first place we have USDC again with 52.7% of total value of borrowed assets.
• The top twenty borrowers are shown on the left with the amount of money that they have borrowed from this protocol.

• Now lets take a look at borrow stats, last updated on Nov 17th, 24.2k borrowers were lent to 3.29B worth of volume in 87.2k different transactions.
• The second row graphs first and foremost tell us how many borrow transactions happened on each day and how many borrowers were unique and the total amount of volume borrowed on each day.
• As you can see on Sep 22nd and Oct 11th and Nov 3rd we have the most amount of unique users and transactions.
• On Aug 4th we had the most amount of borrowed in USD. which is over 767M

• The daily unique borrower per asset and the number of borrowed assets on a daily basis, are shown bello in a normalized form.
• on Nov 17th the most amount of asset and unique borrower belongs to USDC asset but the most value and volume borrowed on that date belong to sUSD.
• The daily amount of borrow and repay are shown in the final graph from Aug 17th to Nov 17th and we can see the in debt value line comes over the deadline on Oct 17th.

Conclusion

• In conclusion of what we studied on this article about this protocol we can say that a lot of people have actually gained benefit from it.
• The decentralization of Aave(OP) V3 will help the majority of people to get goods from it and it doesn’t just concern a small portion of users.
• We can see that on some days the unique user base actually goes higher than 5k and a large portion of these users actually supply this trend and help it to grow more which is a good thing both for gaining’s and the cooperation of the users.
• The most used asset on this protocol, both for supplying and borrowing is USDC which not only has the most value bot the most number of assets used.

Add Text Here

Borrow stats

Supply stats

Overall stats

Method

I used the optimism.core.fact_event_logs table with Aave v3 pool contract = 0x794a61358d6845594f94dc1db02a252b5b4814ad

To collect all the transactions and all other data that I will need.

I divided the transaction to 5 category base on their unique ORIGIN_FUNCTION_SIGNATURE :

ORIGIN_FUNCTION_SIGNATURE = '0xf7a73840' then 'Deposit'

ORIGIN_FUNCTION_SIGNATURE='0x8e19899e' then 'Withdraw'

ORIGIN_FUNCTION_SIGNATURE='0xd5eed868' then 'Borrow'

ORIGIN_FUNCTION_SIGNATURE='0x563dd613' or ORIGIN_FUNCTION_SIGNATURE='0xdc7c0bff' then 'repay'

ORIGIN_FUNCTION_SIGNATURE='0x42b0b77c' then 'FlashLeon'

for token amount I needed the price for each one of them, so I used optimism.core.fact_hourly_token_prices

in the daily Value in the pool and debt graph, the starting date was Aug 04, 2022

AAVE V3 Overview

The Aave Protocol is decentralised non-custodial liquidity protocol where users can participate as suppliers, borrowers or liquidators. Suppliers provide liquidity to a market and can earn interest on the crypto assets provided, while borrowers are able to borrow in an overcollateralized fashion. Borrowers can also engage in one-block borrow transactions (”flash loans”), which do not require overcollateralization.

V3 of the Aave Protocol augments the core concepts of Aave Protocol (aTokens, instant liquidity, stable rate borrowing, credit delegation, etc.) with new features in following area.