Pmisha-bmlMdxswap.from.10
    Updated 2022-05-03
    SELECT
    s.swap_to_asset_id,
    b.asset_name as swap_from_token,

    count(*) as swaps,
    sum(swap_from_amount) as volume
    from algorand.swaps s left outer join algorand.account_asset b on s.swap_to_asset_id=b.asset_id
    where swap_from_asset_id ='694432641'
    group by 1,2
    order by 3 desc
    Run a query to Download Data