farid-c9j0VMUntitled Query
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select block_timestamp::date as date,
case
when swap_to_asset_id=0 then 'Algo'
else asset_name
end as asset_name, count(*) as swap_count
from algorand.swaps
left join algorand.asset
on swap_to_asset_id=asset_id
where block_timestamp::date BETWEEN '2022-05-07' and '2022-05-15'
group by date, swap_to_asset_id,asset_name
order by swap_count desc
Run a query to Download Data