freemartianOther Pools Mint Count
    Updated 2022-05-20
    with liquidity_action as (
    select
    try_base64_decode_string(tx_message:txn:apaa[0]::string) as apaa, date_trunc('day', block_timestamp) as DATE, tx_id,
    (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 liquidity_action
    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 >= '2022-02-10'
    )

    select la.DATE, la.apaa, count(la.tx_id) as mint_count,
    (case
    when aa.address = 'KX6S647W6BEN6XHEJVMXK3UYLVNGT2Q6PHQSF5AA2JSSDFSOX7R4MESXRY' then 'Yieldly-ALGO'
    when aa.address = '5XQEBPFLVR5WOGZNVSLHVKELRDP2LVVLB44OWZ7WA3JKQ72SYTD6MVZTWI' then 'PLANET-ALGO'
    when aa.address = 'XLNMBK3GMC4YEF562DMEOZEYTNDWJLQRN2GFQ3MGLVNIJTOTVGVD75DVKM' then 'Defly Token-ALGO'
    else 'others'
    end) as pool
    from algorand.account_asset aa
    join liquidity_action la on aa.asset_id = la.liquidity_action
    where pool!= 'others'
    and la.apaa = 'mint'
    group by 1,2, pool
    Run a query to Download Data