PapasotLP actions on Tinyman
    Updated 2023-01-03
    -- 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 lp.date, lp.apaa, 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
    group by 1,2
    Run a query to Download Data