sinahosseinzadehUntitled Query
Updated 2022-08-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with table1 as (
select top 10 voter as whale_address, sum(voting_power) as whale_weight
from ethereum.core.ez_snapshot
where voter not in ('0xD9A8bf5A0f51fd33E81cec86b0e9761D29ED8A2B', '0x8DEa94aC7A9625e16195961059f88945aad80472', '0xe29074dF944657963a135a3dBA0A81c24D5df140',
'0x37234aEd028E0814437FB19F45F0E6075748B706', '0x61e681391dD71e183764A20AEF5Cfd3b2f1435C7', '0x03f946Edda019aa760B724F7947015b36533CBBF',
'0xBa03EcA6b692532648c4da21840fB9Af578147A2', '0x02aE1C8BFD8F2E7d0452Dd2fcDbBD711fF92d321', '0xc87b3Aa99A33E929e1558857597d53Ed413aeEc7')
group by whale_address
order by whale_weight desc
),
table2 as (select voter as wallet_address, sum(voting_power) as wallet_weight
from ethereum.core.ez_snapshot
where voter not in (select whale_address from table1)
group by wallet_address)
select 'Whales' as users, sum(whale_weight) as total from table1
union
select 'Users' as users, sum(wallet_weight) as total from table2
group by users
Run a query to Download Data