shahdadi-9ptm8YJanuary balance of top holder and current balance
Updated 2022-06-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with a as(select user_address,balance as January_balance
from flipside_prod_db.ethereum.erc20_balances
where contract_address=lower('0x2e9d63788249371f1DFC918a52f8d799F4a38C94') and BALANCE_DATE ='2022-01-31'
order by balance desc limit 10
),b as(
select user_address ,balance as curent_balance
from flipside_prod_db.ethereum.erc20_balances
where contract_address=lower('0x2e9d63788249371f1DFC918a52f8d799F4a38C94') and BALANCE_DATE=CURRENT_DATE and user_address in (select user_address from a)
)
select a.user_address,January_balance,curent_balance,case when (curent_balance - January_balance) > 0 then 'purchased more'
when (curent_balance - January_balance) = 0 then 'hold' when (curent_balance - January_balance) < 0 then 'sold' end as situation
from a join b on a.user_address=b.user_address
Run a query to Download Data