adambalaMember Roles
Updated 2022-03-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with IFFF
as (
select distinct user_address ,balance
,date_trunc('day',balance_date) as date
from ethereum.erc20_balances
where balance_date::date > current_date-1
and contract_address ='0x2d94aa3e47d9d5024503ca8491fce9a2fb4da198'
group by 1,2,3
)
select date,count(distinct user_address ),
IFF( balance >=35000, IFF(balance between 35000 and 150000,'member','WHALE'),'OTHER')
from IFFF
group by 1,3
Run a query to Download Data