rahoAave On-chain
Updated 2023-03-03
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with all_votes as (
select
date(block_timestamp),
proposal_id,
voter,
voting_power/pow(10,18) as vpower,
support,
tx_hash
from Ethereum.aave.ez_votes
order by 2 desc
),
names as (
select
*
from crosschain.core.ez_ens
),
vote_turnout as(
select
date(block_timestamp),
proposal_id,
proposal_tx,
proposer,
status,
targets
from ethereum.aave.ez_proposals
order by 2 desc
),
historical_votes as (
select
voter,
sum(vpower) as vp_cast,
count(proposal_id) as proposals_voted
from all_votes
Run a query to Download Data