Aave Delegates' Gas Usage
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?

Concepts
What is AAVE?
Aave is a decentralized non-custodial liquidity protocol where users can participate as depositors or borrowers. Depositors provide liquidity to the market to earn a passive income, while borrowers are able to borrow in an overcollateralized (perpetually) or undercollateralized (one-block liquidity) fashion.Read more: https://docs.aave.com
WHAT IS GAS?
Gas refers to the unit that measures the amount of computational effort required to execute specific operations on the Ethereum network.
Since each Ethereum transaction requires computational resources to execute, each transaction requires a fee. Gas refers to the fee required to execute a transaction on Ethereum, regardless of transaction success or failure.
Calculation of transaction fee
Let's say Jordan has to pay Taylor 1 ETH. In the transaction, the gas limit is 21,000 units and the base fee is 10 gwei. Jordan includes a tip of 2 gwei.
The total fee would now be: units of gas used * (base fee + priority fee) where the base fee is a value set by the protocol and the priority fee is a value set by the user as a tip to the validator.
i.e 21,000 * (10 + 2) = 252,000 gwei or 0.000252 ETH.
Read more: https://ethereum.org/en/developers/docs/gas/
Methodology
I am azin. in this analyssis we are going to examine how much gas have used of AVVE voting. the AAVE proposals are submits on ethereum chain. for this porpose we extracted AAVE voting transaction from ethereum.core.fact_event_logs with conndition:ORIGIN_TO_ADDRESS='0xec568fffba86c094cf06b22134b23074dfe2252c' and EVENT_NAME='VoteEmitted'
After that we joined these information to transaction table in order to find gas information. also we extracted the voting activity by below code:
EVENT_INPUTS['id'] as id,EVENT_INPUTS['votingPower'] as votingPower
In this analysis we tried to explore the AAVE gas information in points of view of gas used, gas price, tx fee and usd tx fee.