INTRODUCTION🤝

AAVE is a lending system that allows users to lend, borrow, and earn interest on crypto assets. The platform is a decentralized money market protocol where users can participate as either borrowers or lenders. Here, borrowers can borrow cryptocurrencies by paying variable interest rates. At the same time, the lenders provide liquidity to the market to earn passive income in the form of interest. In simpler words, Aave is a decentralized finance (DeFi) lending platform that creates an open and transparent system that works without the involvement of any intermediaries.

Running on the Ethereum blockchain, the Aave protocol aims to simplify the borrowing and lending of cryptocurrencies. The Aave protocol is essentially a system of smart contracts that manages the funds and enables instant loans. As per the whitepaper, the protocol algorithmically decides the interest rates for borrowers and lenders on its own. For borrowers, the protocol calculates the interest rate based on the funds available in the pool and the amount of funds the borrower requires. For lenders, the interest rate is calculated based on the earn rate and withdrawals at any time

METHODOLOGY🤏

• Flipside tables will be used for this analysis

• The ethereum.aave.core.ez_swaps function will be utilized to obtain the overall count of votes and voters. Subsequently, it will be merged with the ethereum.fact.transactions table to extract the gas consumption data.

• To get the transaction fees -> gas used * gas price/1e9 * price of ETH in USD. But ofcourse, the transaction fees column is available already on the tables and shall be used.

AIM🎯

The purpose of this dashboard is to provide analysis and answer questions related to the gas consumption of delegate voting in Aave over the past 90 and 180 days. The following metrics will be examined:

• The proposal Id's will be accompanied by the total number of votes and voters, as well as the daily number of votes and voters recorded for the past 90 and 180 days.

• Furthermore, the daily gas usage, total gas used, and average gas used per vote for the past 90 and 180 days will be provided in decimal format.

• Additionally, a comparison will be presented between the corresponding days of the past 90 and 180 days.

AAVE GOVERNANCE?

The Aave Governance V2 represents a thrilling advancement in on-chain governance, featuring delegated voting and proposition abilities, as well as swift protocol upgrades through short time lock executors and governance improvements via long time lock executors. This guarantees that the protocol can readily adapt to fluctuations in market conditions and improve key aspects of the protocol over time.