11. Total Liquidity Dashboard

    This dashboard visualizes two things, firstly the average total liquidity per day in all of Aave's pools, and secondly the change in liquidity in each of Aaves V2 liquidity pools over time. The daily liquidity has increased massively over recent months, and the point of highest liquidity in 2021 is more than 10 fold the highest point in 2020. One of the biggest liquidity increases came at the end of April, where total liquidity jumped from around five billion USD to over fourteen billion USD in a matter of weeks. This jump could be in part to a set of new governance proposals that occured in April, and Curve Finance launched a Polygon pool that is deposited into Aave. Aave's V2 pools have also, in general, increased significantly over the course of the year. The two most popular pools, WETH and USDC, both increased more than 100 fold since December 2020. The only pool which seems to have slightly decreased over time is BUSD, which went from a high of about sixteen million in March 2021 to about 9 million in September. Methodology: Since the liquidity data in Aave's market stats is hourly, I had to get the average since I wanted to find the daily total liquidity. To find the average Aave liquidity per day, I first grouped by day and took the sum of the liquidity from Aave's market stats and divided this sum by 24. For the chart showing the liquidity in Aave's V2 pools over time, I found the average for each day for each pool from Aave's market stats. I made four different tables, with each having the average pool liquidity, and each being on a day three months apart from the others. I then joined them together, allowing me to contrast the data from four different months in three month intervals. The data only goes back to December 2020, as that is when Aave's V2 pools were released. I decided to use a logarithmic scale for the y-axis as the data points were too far apart for a good representation on a linear scale.