Aave is a decentralized cryptocurrency platform that allows users to borrow and lend crypto. Aave uses smart contracts to automate the process, with preset rules on how funds are distributed, how collateral is handled, and how fees are assessed.

Aave specializes in overcollateralized loans, meaning that users will need to deposit crypto worth more than the amount that they wish to borrow. This protects lenders from losing money due to loan defaults and allows the Aave protocol to liquidate the collateral if it drops too much in value.

Aave also offers a native crypto token (AAVE) that can be traded on most exchanges or staked in the Aave platform to earn interest. Staking is how crypto miners earn rewards for validating transactions on a proof-of-stake blockchain like the one that underlies Aave.

In this dashboard, we are going to check the proposals, the number of votes and voters, as well as the gas consumed in these votings on the Aave platform in the two time periods of the last 90 days and the last 180 days.

We will also check other parameters such as the users who participated the most in the voting and the proposals that had the most participation of users and which proposals had the most gas consumption.

And for this purpose, we have used the following tables:

ethereum.aave.ez_votes

ethereum.core.fact_transactions

In the last 180 days, 5.3k users participated in voting and registered 12.2k votes.

In the last 180 days, 83 proposals have been placed on the Aave platform.

In the last 180 days, 97.2k gas has been used for each vote given by users.

In the last 180 days, a total of 1.189B gas has been used on voting.

In the last 90 days, Proposal 147 has had the most participation of users Also, proposal 147 has consumed the most gas.

And almost all the proposals have been passed by the votes of the users, except the proposal 142, which the users were against.

And proposal 180 had the least participation of users and proposal 147 had the most participation of users.

And you can also see the 10 users who recorded the most votes in the proposals, and 4 users with 48 votes had the most votes in the last 90 days.

As you can see in the graph of daily gas used per vote, gas used for each vote was close to 100K on almost all days, except for a few days when it exceeded this amount.

In the last 180 days, Proposal 127 has had the most participation of users Also, proposal 127 has consumed the most gas.

In the last 180 days, proposal 180 had the least participation of users and proposal 127 had the most participation of users.

In the last 180 days, like the result we got in the last 90 days, it can be seen that the amount of gas consumed for each vote is close to 100K, except for a few days that exceeded this amount.

In the last 180 days, the only proposal that users did not support was proposal 142.

The user 0xa0efd27acc781549d5b78e89e561aa0903932d56 had the highest participation in voting with 78 votes.

In the last 90 days, 1.39k users participated in voting and registered 3.04k votes and in the last 180 days, 5.3k users participated in voting and registered 12.2k votes.

In the last 90 days, a total of 300.837M gas has been used on voting and in the last 180 days, a total of 1.189B gas has been used on voting.

The average gas consumption for each vote in both time periods of the last 90 and 180 days was very close to each other(97K,98K).

In general, proposal 127 had the most participation and gas consumption, and proposal 180 had the least participation.

And the only proposal that users did not support was proposal 142.

In the last 90 days, 1.39k users participated in voting and registered 3.04k votes.

In the last 90 days, 53 proposals have been placed on the Aave platform.

In the last 90 days, 98.9k gas has been used for each vote given by users.

In the last 90 days, a total of 300.837M gas has been used on voting.