Pmisha-bmlMdxstblt.popularity
    Updated 2022-04-03
    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