amirozatop 5 swap to
Updated 2022-06-09
9
1
2
3
4
5
6
7
›
⌄
select case when SWAP_to_ASSET_ID=0 then 'algo' else ASSET_NAME end ASSET_NAME,count(SWAP_to_ASSET_ID) asset_count
from flipside_prod_db.algorand.swaps
left join flipside_prod_db.algorand.asset on asset_id=SWAP_to_ASSET_ID
where date(BLOCK_TIMESTAMP) in ('2022-05-11','2022-05-12')
group by 1
order by 2 DESC
limit 5
Run a query to Download Data