where contract_address='0x2e9d63788249371f1dfc918a52f8d799f4a38c94'

group by 2)

, sell as (select sum(amount) as sell ,from_address as address from ethereum.core.ez_token_transfers

where contract_address='0x2e9d63788249371f1dfc918a52f8d799f4a38c94'

group by 2)

, total_holder as (select ifnull((buy-sell),0) as diff ,buy.address from buy left join sell

on buy.address=sell.address

order by diff DESC)

, pool1 as (select sum(AMOUNT_IN_USD),sum(AMOUNT_OUT_USD), sum(AMOUNT_OUT_USD)-sum(AMOUNT_IN_USD) as diff ,POOL_NAME from ethereum.core.ez_dex_swaps where POOL_NAME in (select POOL_NAME from ethereum.core.dim_dex_liquidity_pools

where TOKEN0='0x2e9d63788249371f1dfc918a52f8d799f4a38c94' or token1='0x2e9d63788249371f1dfc918a52f8d799f4a38c94')

group by POOL_NAME)

, pool2 as (select sum(AMOUNT_IN_USD),POOL_NAME from ethereum.core.ez_dex_swaps where POOL_NAME in (select POOL_NAME from ethereum.core.dim_dex_liquidity_pools

where TOKEN0='0x2e9d63788249371f1dfc918a52f8d799f4a38c94' or token1='0x2e9d63788249371f1dfc918a52f8d799f4a38c94')

and sender in(select address from total_holder)

group by POOL_NAME)

select * from pool1