In this analysis, I create visualizations in term of Daily AAVE supplied and withdrawn on Aave protocol & Daily AAVE staked and unstaked.

What is AAVE?

Aave is a decentralised non-custodial liquidity market protocol where users can participate as depositors or borrowers. Borrowers have the option of borrowing in an overcollateralized (perpetually) or undercollateralized (one-block liquidity) method, while depositors offer liquidity to the market in exchange for passive income.

AAVE serves as the focal point for governing the AAVE Protocol. Voting and decision-making for AAVE Improvement Proposals take place through AAVE (AIPs). In addition, AAVE can be staked inside the protocol Safety Module to give the protocol and depositors security and insurance. The protocol pays staking rewards and fees to stakers.

In order to visualize the AAVE supplied and withdrawn on Aave protocol, I used the table “flipside_prod_db.aave.deposits” and “flipside_prod_db.aave.withdraws”. The key to identify is “symbol” = AAVE. 

In order to visualize the AAVE staked and unstaked, I used the table “ethereum.core.fact_token_transfers”. The key to identify are “origin_function_signature” and “contract_address”. Based on the sample transaction, we can see that if “origin_function_signature” = 0xadc9772e, it shows staking. If “origin_function_signature” = “0x1e9a6950”, it shows unstaking. The contract_address must be “0x4da27a545c0c5b758a6ba100e3a049001de870f5”, a contract address of (stkAAVE)

The provided data represents monthly statistics related to stake and unstake activities, including the number of transactions, the amount staked or unstaked, and the corresponding amount in USD. These figures offer insights into the trends and patterns of stake and unstake actions during the given period.

In March 2023, there were 225 unstake transactions recorded, with a total monthly amount of 65,034.35. The equivalent amount in USD was approximately 4,865,807.69. On the other hand, stake activities in the same month involved 730 transactions, amounting to 81,832.62. The corresponding USD value for these stakes reached around 6,085,332.99.

In April 2023, there were 202 unstake transactions, totaling 96,619.86, with a corresponding USD amount of roughly 7,347,891.42. Stake activities, however, involved 508 transactions, with a monthly stake amount of 64,647.19. The USD equivalent for these stakes was approximately 4,898,493.96.

Moving to May 2023, stake activities saw 255 transactions, amounting to 64,941.03. The USD value for these stakes reached around 4,207,741.89. Conversely, there were 64 unstake transactions, with a monthly amount of 80,960.86. The corresponding USD value for these unstakes was approximately 5,611,237.43.

In June 2023, stake activities involved 40 transactions, with a total stake amount of 9,464.31. The USD equivalent for these stakes reached approximately 599,551.53.

Examining the data from February 2023, there were 740 stake transactions recorded, totaling 83,654.32. The equivalent USD value for these stakes was approximately 7,236,491.10. Conversely, unstake activities involved 200 transactions, amounting to 70,094.49. The corresponding USD value for these unstakes reached around 6,232,350.99.

Finally, in January 2023, there were 1,123 stake transactions, with a monthly amount of 93,426.04. The equivalent USD value for these stakes was approximately 6,402,984.80. Unstake activities involved 261 transactions, totaling 118,476.72, with a corresponding USD amount of roughly 9,511,153.41.

The data provides insights into the monthly trends of stake and unstake actions, including the number of transactions and the amounts involved. It illustrates the varying levels of engagement in staking and unstaking throughout the given period.

In conclusion, the analysis of the provided charts and data reveals significant insights into the monthly trends and patterns of various financial activities. It showcases fluctuations in the number of addresses, transactions, and amounts in USD for deposits and withdrawals, as well as the trends in stake and unstake activities.

Regarding deposits and withdrawals, there were notable variations in the number of addresses and transactions month by month. The total amounts involved in these transactions also fluctuated, indicating changing patterns of usage within the financial system.

Similarly, the stake and unstake activities exhibited monthly variations in the number of transactions and the amounts staked or unstaked. The corresponding USD values for these actions also varied, suggesting shifts in investor behavior or market conditions.

The given chart presents data on the monthly number of addresses, transactions, and amounts in USD for deposits and withdrawals over a period of six months from January to June 2023. Overall, there were variations in the figures across the months, indicating fluctuations in the usage of the financial system.

In June 2023, there were 200 addresses involved in deposit transactions, with a total of 387 transactions recorded. The corresponding amount for these deposits reached approximately $462,409,986.72. On the other hand, withdrawals in the same month involved 192 addresses, with a slightly higher number of transactions, totaling 481. The total amount withdrawn amounted to around $390,983,046.59.

Moving back to May 2023, deposit activities were more prominent with a significantly higher number of addresses, 1,174, and a larger number of transactions, 2,937. The total value of these deposits was substantially larger, amounting to approximately $10,664,487,252.68. Withdrawals in May involved 845 addresses, with 3,030 transactions recorded. The overall withdrawal amount for the month was roughly $10,622,800,340.58.

Looking further back to April 2023, deposit transactions involved 1,692 addresses and 4,591 transactions, resulting in a total value of around $5,815,516,010.04. In terms of withdrawals, 1,281 addresses were engaged in approximately 4,802 transactions, with a total withdrawal amount of about $6,283,438,881.77.

In March 2023, the number of addresses involved in deposit transactions increased to 3,703, with a substantial number of transactions, totaling 12,023. The cumulative amount of deposits surged to approximately $24,610,370,273.39. Withdrawals in the same month saw 2,610 addresses engaged in 12,912 transactions, resulting in a total withdrawal amount of approximately $24,819,895,775.18.

In February 2023, deposits accounted for 2,681 addresses and 6,707 transactions, with a cumulative value of around $4,579,446,604.24. Concurrently, withdrawals involved 1,684 addresses and 6,792 transactions, amounting to approximately $4,668,623,469.75.

Finally, in January 2023, there were 3,792 addresses involved in deposit transactions, with a significant number of transactions, totaling 10,812. The overall amount deposited in this month was approximately $4,157,642,650.29. Withdrawals, on the other hand, saw 2,410 addresses engaged in 9,035 transactions, resulting in a cumulative withdrawal amount of about $4,358,564,695.77.

In conclusion, the data from the chart reveals fluctuations in the number of addresses, transactions, and amounts in USD for deposit and withdrawal activities over the span of six months.