ErsvangALGO-Top-10-DEX-token_to_get_galgo3
    Updated 2022-04-24
    --¿Cuáles son los 10 más populares para intercambiar para obtener gALGO3?

    select
    count(algorand.swaps.tx_group_id) as transaction_per_token,
    IFNULL(algorand.asset.asset_name,'Algo') as token_to_get_galgo3
    from
    algorand.swaps
    left join
    algorand.asset
    on
    algorand.swaps.swap_from_asset_id = algorand.asset.asset_id
    where
    swap_to_asset_id = '694432641'
    group by token_to_get_galgo3
    order by 1 desc
    limit 10
    Run a query to Download Data