Methodology

Dashboard Objective

Show Aave Delegates Gas Usage in Ethereum, in the last 180, 90, and 30 days and reach conclusions for the amount of total fees based on their governance activity over time.

Dashboard Structure

Introduction
Aave Voting Activity by "Days"
- Aave Governance Activity on the last "Days"
- Aave Governance Top Gas Guzzlers on the last "Days"
Comparison of Timeframes
- Aave Governance Comparison of Timeframes
Conclusion
Methodology

Dashboard Method

Using Flipside Tables of Ethereum I'll track the activity of Aave votes with the Aave tables and then look at their transaction fees using the transaction hash of the votes during the selected timeframe.

--Table Used to get the Votes transaction hash, and information about the voter, proposal and time:

ethereum.aave.ez_votes

--Table used to get the Transaction Fees with the transaction hash previously obtained, using a join to get also the USD price:

from ethereum.core.fact_transactions
  left join (
    select
      date_trunc('day', hour) as day1,
      avg(price) as price
    from ethereum.core.fact_hourly_token_prices
    where symbol LIKE 'WETH'
    group by 1 
  ) on day1 = date_trunc('day', block_timestamp)

Dashboard Sources

Aave Image

Aave Icon from Aave Website

MetricsDAO Bounty Question

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?

Popex404