with

a as (

select distinct user_address,

max(balance) as balance

from flipside_prod_db.ethereum.erc20_balances

where contract_address = '0x2e9d63788249371f1dfc918a52f8d799f4a38c94'

and balance_date between '2022-01-01' and '2022-01-31'

and label is null

group by 1

order by 2 desc

limit 20

),

now as (

select

user_address ,

balance ,

amount_usd

from ethereum.erc20_balances

where lower(contract_address) = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84' )

and balance_date::date = current_date - 1

and user_address in ( select user_address from a)

),

b as (

now.user_address,

now.balance as now,

a.balance as past

from now inner join a on NOW.user_address=A.user_address

group by 1,2,3

select

*

from A