headitmanagerToken and Swaps
    Updated 2022-06-18
    with address_tbl as (select address,address_name from crosschain.address_labels where project_name like '%celsius network%')
    , swaps as (select count(*),symbol_out from crosschain.ez_swaps inner join address_tbl
    on address_tbl.address=crosschain.ez_swaps.token_in
    group by symbol_out)
    , swaps_byplatform as (select count(*),platform from crosschain.ez_swaps inner join address_tbl
    on address_tbl.address=crosschain.ez_swaps.token_in
    group by platform)
    , wallet_from as (select count(*),origin_from_address from crosschain.ez_swaps inner join address_tbl
    on address_tbl.address=crosschain.ez_swaps.token_in
    group by origin_from_address
    order by count(*) DESC
    limit 10 )
    , wallet_to as (select count(*),origin_to_address from crosschain.ez_swaps inner join address_tbl
    on address_tbl.address=crosschain.ez_swaps.token_in
    group by origin_to_address
    order by count(*) DESC
    limit 10)
    select * from swaps
    Run a query to Download Data