Create visualizations showing the following:

• Daily AAVE supplied and withdrawn on Aave protocol.

• Daily AAVE staked and unstaked.

Methodology:

• Find daily amount of deposit and withdraw $AAVE on Aave protocol by using deposits and withdraws tables of Aave schema on Flipside crypto.

• Find daily number of transactions deposit and withdraw $AAVE.

• Find daily amount of stake and unstake $stAAVE on Aave protocol by using fact_event_logs table of Ethereum schema on Flipside crypto. The contract address of stAAVE on Ethereum is equal to 0x4da27a545c0c5B758a6BA100e3a049001de870f5.

  stake transactions have event_name = 'Staked'

  unstake transactions have event_name = 'Redeem'

• Find daily number of transactions stake and unstake $stAAVE.

• There is a huge spike on Deposit $AAVE on May 6, 2021 and withdraw on May 5, 2021. More than 750M $AAVE is withdrawn from protocol and next day is deposited almost same amount into protocol.
• Amount of Deposit and Withdraw $AAVE is decreasing over time. This is shown in both Aave amount and USD amount charts but due to the decrease in the price of this token, it is more intense in the USD chart.
• The maximum number of users deposited on protocol was 129 users on Jan 28, 2021 and the minimum users who withdrawn from protocol was 102 users on May 23, 2021.

AAVE movements

stAAVE movements

• There is a huge spike on stake $stAAVE on Oct 21, 2020 and withdraw on May 11, 2022. More than 733K $stAAVE staked on protocol and more than 400K $stAAVE unstaked on protocol.
• Amount of Deposit and Withdraw $AAVE hasnt notable change over time.
• The maximum number of users deposited on protocol was 1326 users on Oct 3, 2020 and the minimum users who withdrawn from protocol was 90 users on Feb 14, 2021.

• May 2021 was on top based on volume of deposited $AAVE and Apr 2022 was on floor based on volume of deposited this token on protocol.
• Jan 2021 was on top based on number of deposited transactions and Feb 2022 was on floor based on number of deposited transactions on protocol.
• Feb 2021 was on top based on volume of withdrawn $AAVE and Jun 2022 was on floor based on volume of withdrawn this token on protocol.
• Jan 2021 was on top based on number of withdrawn transactions and Apr 2022 was on floor based on number of withdrawn transactions on protocol.

• Oct 2020 was on top based on volume of staked $stAAVE and Jun 2022 was on floor based on volume of staked this token on protocol.
• Oct 2020 was on top based on number of staked transactions and Jan 2022 was on floor based on number of staked transactions on protocol.
• Jun 2022 was on top based on volume of unstaked $stAAVE and Jul 2021 was on floor based on volume of unstaked this token on protocol.
• Feb 2021 was on top based on number of unstaked transactions and Jul 2022 was on floor based on number of unstaked transactions on protocol.