from flipside_prod_db.ethereum.erc20_balances

where balance_date = '2022-06-21'

and contract_label = 'tokemak'

and symbol = 'TOKE'

order by 2 desc

)

select date(block_timestamp) as day , POOL_NAME , count(DISTINCT(tx_hash)) as swap

from ethereum.core.ez_dex_swaps

where token_out = lower('0x2e9d63788249371f1DFC918a52f8d799F4a38C94') or token_in = lower('0x2e9d63788249371f1DFC918a52f8d799F4a38C94')

and tx_to in ( select wallet from t1)

group by 1,2