PapasotPopular LPs Tinyman
    Updated 2022-05-17
    -- original query adjusted from a grand prize submission, https://app.flipsidecrypto.com/dashboard/tinyman-lp-actions-M-FbJm
    -- Original author Phairot_max

    with lp_id as (select date_trunc('day', block_timestamp) as date,
    try_base64_decode_string(tx_message:txn:apaa[0]::string) as apaa,
    case when array_size(tx_message:txn:apas) = 2 then tx_message:txn:apas[1]
    when array_size(tx_message:txn:apas) = 3 then tx_message:txn:apas[2]
    end as lp_id,
    tx_id
    from algorand.application_call_transaction
    where try_base64_decode_string(tx_message:txn:apaa[0]::string) in ('mint', 'burn') and app_id in (552635992) and block_timestamp::date >= '2022-03-10')

    select acc_ass.asset_name, count(distinct lp.tx_id) as num_txs
    from algorand.account_asset acc_ass
    join lp_id lp on
    acc_ass.asset_id = lp.lp_id
    where lp.apaa = 'mint'
    group by 1
    order by num_txs desc
    limit 12
    Run a query to Download Data