binhachonCelsius Swaps - #2
    Updated 2022-06-20
    with celsius_wallets as (
    select
    *
    from flipside_prod_db.crosschain.address_labels
    where address_name ilike '%celsius%'
    ),
    swap_activity as (
    select
    *
    from flipside_prod_db.crosschain.ez_swaps
    where origin_from_address in (select address from celsius_wallets)
    )
    select
    symbol_in,
    symbol_out,
    count(*) as number_of_swaps,
    sum(amount_in_usd + amount_out_usd) / 2 as volume
    from swap_activity
    group by 1, 2
    Run a query to Download Data