select address

from flipside_prod_db.crosschain.address_labels

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

)

SELECT ORIGIN_FROM_ADDRESS, sum(AMOUNT_IN_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_IN_USD > 0

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

GROUP BY ORIGIN_FROM_ADDRESS

ORDER BY swap_count DESC