headitmanagerToken and Swaps
Updated 2022-06-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
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