from ethereum.erc20_balances

where symbol = 'TOKE' and balance_date = '2022-01-01' and amount_usd is not null

order by amount_usd desc

limit 15),

today as (select user_address, label, address_name, label_type, price, balance, amount_usd

from ethereum.erc20_balances

where symbol = 'TOKE' and balance_date = '2022-06-20' and amount_usd is not null and user_address in (select user_address from jan)

select a.user_address, a.label, a.address_name, a.label_type, a.price as price_jan, b.price as price_june,

a.balance as balance_jan, a.amount_usd as balance_usd_jan,

b.balance as balance_june, b.amount_usd as balance_usd_june,

(balance_june - balance_jan) as token_balance_change,

(balance_usd_june - balance_usd_jan) as usd_change

from jan a

left join today b on a.user_address = b.user_address