rahobroken-OPGov-V2-top_del
Updated 2023-05-01
99
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_del as (
select
block_number,
date(block_timestamp) as date,
delegation_type,
delegator,
from_delegate old_delegate,
to_delegate as delegate,
raw_previous_balance/pow(10,18) as old_bal,
raw_new_balance/pow(10,18) as new_bal,
tx_hash
from optimism.core.fact_delegations
order by date desc
),
wallet_name as (
select
owner,
ens_name,
label
from crosschain.core.ez_ens
),
latest_bal as (
select
delegate,
new_bal as current_bal
from all_del
where (delegate, block_number) in (
select
delegate,
max(block_number)
from all_del
group by delegate
)
)
Run a query to Download Data