boomer77asadexx4
Updated 2022-03-29
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with newtable as (select count (tx_group_id) as TxCount, swap_to_asset_id as AssetID
from algorand.swaps
where swap_to_amount > 0 and block_timestamp >= '2022-01-01'
group by assetid
order by txcount desc limit 11), newtable2 as (select * from algorand.asset)
select newtable.TxCount, newtable.AssetID, newtable2.asset_name
from(
newtable inner join newtable2 ON newtable.AssetID=newtable2.asset_id
)
order by txcount desc
Run a query to Download Data