zayataUntitled Query
Updated 2022-04-28
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select asset.asset_name,
count(*) as swaps
from algorand.swaps swap
left join algorand.asset asset
on swap.swap_to_asset_id = asset.asset_id
where block_timestamp::date BETWEEN '2022-03-01' AND '2022-03-31'
and swap_from_asset_id = 0
and swap_from_amount > 0
group by asset.asset_name
order by swaps desc
limit 10
Run a query to Download Data