select address

from flipside_prod_db.crosschain.address_labels

where BLOCKCHAIN='ethereum' and PROJECT_NAME ='celsius network'

)

SELECT SYMBOL_OUT, sum(AMOUNT_OUT_USD) as vol, COUNT(DISTINCT tx_hash) as swap_count FROM ethereum.core.ez_dex_swaps

where ORIGIN_FROM_ADDRESS in (select address from cel)

and AMOUNT_OUT_USD > 0

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

GROUP BY SYMBOL_OUT

ORDER BY vol DESC