Yousefi_1994Tokens that Celsius wallets conduct the most swap to
    Updated 2022-06-20
    with celsius_wallet_address as(
    select
    address as wallet
    from crosschain.address_labels
    where address_name ='celsius wallet'
    )

    select
    symbol_out as token,
    count(symbol_out) as number_of_swaps_to,
    sum(amount_out_usd) as volume_of_swaps_out
    from celsius_wallet_address celsius
    join crosschain.ez_swaps swaps
    on celsius.wallet = swaps.origin_from_address
    where symbol_in is not null and symbol_out is not null
    and amount_in_usd is not null and amount_out_usd is not null
    and platform in('sushiswap','uniswap-v2')
    group by token
    order by volume_of_swaps_out desc, number_of_swaps_to desc
    limit 10

    Run a query to Download Data