shahdadi-9ptm8YUntitled Query
    Updated 2022-05-21
    with LP as (
    select
    CASE
    when array_size(tx_message:txn:apas) = 3 then tx_message:txn:apas[2]
    when array_size(tx_message:txn:apas) = 2 then tx_message:txn:apas[1]
    END as lp_token,
    sum(1) as count

    from algorand.application_call_transaction

    WHERE
    block_timestamp::date >= '2022-01-01'
    and try_base64_decode_string(tx_message:txn:apaa[0]::string) IN ('mint', 'burn')
    and app_id IN (552635992)

    group by 1
    order by 2 desc
    )

    select asset.asset_name as lp_name, LP.count as count

    from LP as lp, algorand.asset as asset

    where lp.lp_token = asset.asset_id and lp_name like '%btc'

    order by count desc
    Run a query to Download Data