Try Quests to earn cryptoAave - 7. AAVE and stAAVE movements
Create visualizations showing the following: Daily AAVE supplied and withdrawn on Aave protocol. Daily AAVE staked and unstaked.
Method:
In this dashboard I analyzed:
- the number of AAVE deposits, depositors, and daily amount of deposited AAVE
- the number of AAVE Withdraws, Withdrawers, and daily amount of withdrawn AAVE
- the Total amount of deposited/withdrawn tokens (in USD) and their total number of transactions
- the number of AAVE Staked, Stakers, and daily amount of Staked AAVE
- the number of AAVE Unstaked, Unstakers, and daily amount of Unstaked AAV
Used Tables:
> * flipside_prod_db.aave.deposits > * flipside_prod_db.aave.withdraws > * ethereum.core.ez_token_transfers > >
When a user stakes AAVE, receives stAAVE and when the user wants to unstake its AAVE it should repay the received stAAVE and because of it, in this dashboard, I only used data related to AAVE.
The average price of AAVE has been added to each chart as a reference.
AAVE Deposits
The following graphs show the number of AAVE deposits, depositors, and daily amount of deposited AAVE. The average price of AAVE also has been added to each chart as a reference.
By looking at both transaction types we can see similar behavior between deposited AAVE and withdrawn AAVE (both of them have peaked on close dates - but not similar dates.
Deposits and Withdraws of Other Tokens
The following graphs show the Total amount of deposited/withdrawn tokens (in USD) and the total number of transactions on each side for each one of the tokens
Conclusion:
- The price of AAVE and changes in it played an important role in the number of Deposits/Withdraws/Stakes/Unstakes and amount of Deposits/Withdraws/Stakes/Unstakes (after each jump or drop in the price we can see an increase in those numbers)
- Most of the activities happened before August 2021
- The most used Token in the AAVE protocol is ETH and AAVE is not even in top 5