Yousefi_1994Top 10 tokens that Celsius network wallets most swap to
    Updated 2022-07-14
    with celsius_wallet_address as(
    select
    address as wallet
    from crosschain.address_labels
    where address_name ='celsius wallet'
    )

    select
    symbol_in as token,
    count(symbol_in) as number_of_swaps_to,
    sum(amount_in_usd) as volume_of_swaps_to
    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
    group by symbol_in
    order by volume_of_swaps_to desc, number_of_swaps_to desc
    limit 10

    Run a query to Download Data