Introduction:

Aave is a financial protocol for lending and borrowing digital currencies. 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.

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.

Questionon:

How much gas was used by delegates voting in Aave in the past 90 days? In the past 180? How much gas on average is spent by voters in a single vote?

Content:

1.Genral Metrics

Aave Voter , Voter Transection and Proposal Status in 90 and 180 days

Daily Proposal in Aave

Daily Voter each Proposal ID

Daily Aave by Type of Vote (Yes/No)

2.Fee consumed

Tolerance of Deligitated Fee for voting in Aave Divided By 180/90 Days

The fees paid by voters per proposal ID

Average/Max/Total/Minimum delegation fee paid by voters on Aave

3.Top Voter Consume Fee

Compare the top 10 Aave voters in terms of voting power and compare them to those who have paid higher fees among them

Compare the top 10 Aave proposals in terms of number of voters and compare them to proposals with higher fees paid by the voters

Compare the top 10 voters in terms of number of votes and compare them to 10 users who have paid the highest fees for voting

Method:

I used the tables ethereum.core.fact_transactions and ethereum.aave.ez_votes to answer questions about a topic. I segmented the data based on time using a SQL query with the CASE method, differentiating between the last 180-91 days and the last 90 days based on the block timestamp.