Try Quests to earn cryptoAave Delegates' Gas Usage
The GAS has been used by Aave governance in specified periods of time (90 and 180 days)
What is Aave?
Aave is a decentralised non-custodial liquidity market protocol where users can participate as suppliers or borrowers. Suppliers provide liquidity to the market to earn a passive income, while borrowers are able to borrow in an overcollateralised (perpetually) or undercollateralised (one-block liquidity) fashion.
Website
Community Discord server
introdution
Delegates voting in Aave proposals is an evolution of on-chain governance after Governance V2, allowing unique features such as delegated voting, proposition powers and etc.
This on-chain data dashboard aims to provide unique insight into GAS usage for proposals voted in the last 90 and 180 days. We have calculated and compared the amount and volume of GAS used in the voting process which allows users to monitor that usage in mentioned intervals (3 and 6 last month).
intro
Gas is essential to the Ethereum network. It is the fuel that allows it to operate, in the same way that a car needs gasoline to run.
Whats 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.
Gas fees are paid in Ethereum's native currency, ether (ETH). Gas prices are denoted in gwei, which itself is a denomination of ETH - each gwei is equal to 0.000000001 ETH (10-9 ETH). For example, instead of saying that your gas costs 0.000000001 ether, you can say your gas costs 1 gwei. The word 'gwei' itself means 'giga-wei', and it is equal to 1,000,000,000 wei. Wei itself (named after Wei Dai, creator of b-money) is the smallest unit of ETH.
Check out for more information
In this dashboard, I manage to use 3 tables: ethereum.aave.ez_votes ethereum.core.fact_transactions and ethereum.core.ez_balance_deltas.
first of all I select block_timestamp, tx_hash, voter, tx_fee, gas_used, gas_price from ethereum.aave.ez_votes and join them to the ethereum.core.fact_transactions then I join them to the daily Ethereum price that has been calculated from ethereum.core.ez_balance_deltas table in the needed specified timeframes to reach the table that I need.
after creating the table I calculate and show information in 5 main dashboard tabs:
- the first tab is the introduction of course.
- the second one is monitoring voters, they vote, and how those parameters related to the GAS usage in the past 90 days.
- the third tab is the same as the second tab but in 180 days timeframe.
- the fourth tab is comparing GAS usage in 90days and 180 days; for a better understanding of changes I break down 180 days into two periods first one is 180 days ago to 90 days ago and the second period is 90 days ago until the current day, then I analyze the changes.
- and in the fifth tab I present the conclusion for this dashboard.
