rahoUntitled Query
Updated 2022-09-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- DelegateVotesChanged
-- select
-- date(block_timestamp),
-- event_inputs['delegate']as delegate,
-- event_inputs:newBalance/power(10,18) as current_bal,
-- event_inputs:newBalance/pow(10,18) - event_inputs:previousBalance/power(10,18) as net_change,
-- sum(current_bal) as cbal
-- from ethereum.core.fact_event_logs
-- where event_name = 'DelegateVotesChanged'
-- and contract_address = lower('0xC18360217D8F7Ab5e7c516566761Ea12Ce7F9D72')
select
voter,
voting_power,
proposal_title
from ethereum.core.ez_snapshot
where space_id = 'ens.eth'
and voting_power > 1