select

block_timestamp::date as date,

symbol_in,

platform,

count(DISTINCT TX_HASH) as tx_count,

sum(AMOUNT_IN_USD) as swap_amount

from ethereum.core.ez_dex_swaps

where ORIGIN_FROM_ADDRESS in (select address from flipside_prod_db.crosschain.address_labels where PROJECT_NAME = 'celsius network')

and platform in ('sushiswap' , 'uniswap-v2', 'uniswap-v3')

group by 1,2, 3

order by 3 desc