Pmisha-bmlMdxstblt.popularity
Updated 2022-04-03
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
case
when swap_from_asset_id='31566704' then 'USDC'
when swap_from_asset_id='312769' then 'USDT'
when swap_from_asset_id='465865291' then 'STBL'
end as stablecoin,
sum(swap_from_amount) as volume,
count (distinct tx_group_id) as numberswp,
count(distinct swapper) as unqwlt
from algorand.swaps
where block_timestamp between '2022-03-01' and '2022-03-31'
group by 1 having stablecoin is not null
Run a query to Download Data