count (distinct tx_id)as txs,

pool_name,

sum(amount_usd) as amountusd,

platform,

direction

from flipside_prod_db.ethereum.dex_swaps

where TOKEN_ADDRESS = lower('0xf59257E961883636290411c11ec5Ae622d19455e')

and block_timestamp>'2022-04-01'

group by 2, 4, 5