hessCelsius wallets swapped from
    Updated 2022-06-18
    with celsius as ( select address
    from flipside_prod_db.crosschain.address_labels
    where PROJECT_NAME = 'celsius network'
    )

    select symbol_in , platform, count(DISTINCT(TX_HASH)) as total_swaps , sum(AMOUNT_IN_USD) as total_amount
    from ethereum.core.ez_dex_swaps
    where ORIGIN_FROM_ADDRESS in ( select address from celsius) and platform in ('sushiswap' , 'uniswap-v2' )
    group by 1,2
    order by 3 desc




    Run a query to Download Data