MLDZMNswap pair
    Updated 2022-06-24
    with tb1 as (select
    BASE64_DECODE_BINARY(tx_message:txn:apaa[1]::String)::string,BASE64_DECODE_string(tx_message:txn:note::String),
    *
    from algorand.application_call_transaction
    where BASE64_DECODE_BINARY(tx_message:txn:apaa[1]::String)::string = '03'
    and BASE64_DECODE_string(tx_message:txn:note::String) = 'Reach 0.1.10'
    ),

    tb2 as (select
    APP_ID,
    count(distinct TX_GROUP_ID) as no_use
    from algorand.application_call_transaction
    where TX_GROUP_ID in (select TX_GROUP_ID from tb1)
    group by 1
    order by 2 desc
    limit 5)


    select
    case
    when APP_ID=711293358 then 'TINY to Vestige'
    when APP_ID=777747637 then 'ALGO to Vestige'
    when APP_ID=777628254 then 'USDC to ALGO'
    when APP_ID=773172535 then 'ALGO to Chips'
    when APP_ID=779142716 then 'goMINT to ALGO'
    end as swap_pairs,
    no_use as swap_count
    from tb2

    Run a query to Download Data