maybeyonasop_gov_users_indi
Updated 2022-07-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with
delegations as (
select
block_timestamp,
tx_hash,
event_inputs:delegator::string as user,
event_inputs:fromDelegate::string as prev_delegate,
event_inputs:toDelegate::string as current_delegate,
rank() over(partition by user order by block_timestamp desc) as rank
from optimism.core.fact_event_logs
where contract_address = '0x4200000000000000000000000000000000000042' -- OP governance token
and event_name = 'DelegateChanged'
-- and event_inputs:delegate::string = '0x62a43123fe71f9764f26554b3f5017627996816a' -- Flipside Governance Wallet - flipsidecrypto.eth
order by block_timestamp desc
)
select
count(user) as delegates
from delegations
where rank = 1
and current_delegate = lower('{{DELEGATE_ADDR}}')
-- group by 1
limit 100
Run a query to Download Data