2844MOST POPULAR STABLECOIN
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select date_trunc ('day',block_timestamp) as date,
sum(swap_from_amount) as volume,
swap_from_asset_id,
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
from flipside_prod_db.algorand.swaps
where swap_from_asset_id in ('31566704','312769','465865291')
and block_timestamp >= '2022-05-01' and block_timestamp < '2022-07-01'
group by date,swap_from_asset_id
order by date desc
Run a query to Download Data