eslamis-darkatdistribution 7
Updated 2022-09-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with metamask as (
select distinct origin_from_address as unique_address
from ethereum.core.fact_event_logs
where lower(contract_address) = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
)
,
metamask2 as ( SELECT CURRENT_BAL,user_address
from ethereum.core.ez_current_balances join metamask on user_address = unique_address
where symbol = 'ETH' and TOKEN_NAME='Native Ether')
select count(user_address) as number_of_wallets,
case when CURRENT_BAL < 1 then '0 < ETH < 1'
when CURRENT_BAL >= 1 and CURRENT_BAL < 10 then '1 < ETH < 10'
when CURRENT_BAL >= 10 and CURRENT_BAL < 100 then '10 < ETH < 100'
when CURRENT_BAL >= 100 and CURRENT_BAL < 1000 then '100 < ETH < 1000'
when CURRENT_BAL >= 1000 and CURRENT_BAL < 10000 then '1000 < ETH < 10000'
else 'ETH > 10000' end as distribution
from metamask2
group by distribution
ORDER by number_of_wallets DESC
Run a query to Download Data