with top_holders as (

SELECT distinct user_address as toke_holder, round(avg(balance),2) as token_volume

FROM

flipside_prod_db.ethereum.erc20_balances

WHERE SYMBOL = 'TOKE'

and balance_date >= '2022-01-01' and balance_date <= '2022-01-31'

and contract_address = '0x2e9d63788249371f1dfc918a52f8d799f4a38c94'

and contract_label = 'tokemak'

GROUP BY toke_holder

order by token_volume desc limit 25

)

select distinct user_address as toke_holder, round(avg(balance),2) as token_volume

FROM

flipside_prod_db.ethereum.erc20_balances

WHERE SYMBOL = 'TOKE'

and balance_date >= '2022-06-15' and balance_date <= '2022-06-22'

and contract_address = '0x2e9d63788249371f1dfc918a52f8d799f4a38c94'

and contract_label = 'tokemak'

and user_address in (select toke_holder from top_holders)

GROUP BY toke_holder

order by token_volume desc