Introduction

Aave is a decentralized finance (DeFi) platform that allows users to lend, borrow, and earn interest on cryptocurrency. As with any blockchain-based platform, votingtransactions on Aave require the use of gas, which is a fee paid to miners for processing transactions. Gas prices on the Ethereum network can be highly volatile, and the cost of gas can significantly impact the user experience and cost of using the Aave platform.

In this dashboard, we will do a deep-dive analysis regarding Aave Goverenance activities and delegates' gas usage for the past 90 days

Approach

The dashboard will focus on three tables:

• ethereum.aave.ez_votes
• ethereum.aave.ez_proposals
• ethereum.core.fact_transactions.

The first table will provide information about voting activity, while the second and third tables will be joined to determine gas costs for proposals and votes. The analysis will be conducted over a 90-day period, with the ability to adjust parameters for different timelines. The focus will be on the last 90 days for this analysis.