shadilUntitled Query
Updated 2022-03-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select balance_date as date,
sum(
case when (balance >= 35000 and balance < 150000) then 1 else 0 end
) as members,
sum(
case when (balance >= 150000) then 1 else 0 end
) as whales
from ethereum.erc20_balances
where symbol='BANK'
and balance_date >= '2022-01-01'
and balance >= 35000 and balance < 150000
GROUP BY date
order by date
Run a query to Download Data