KaskoazulTinyman Mint/Burn
    Updated 2022-03-03
    SELECT
    block_timestamp::date as fecha,
    count(distinct tx_id),
    try_base64_decode_string(tx_message:txn:apaa[0]::string) as Action
    FROM algorand.application_call_transaction
    WHERE
    fecha >= '2022-01-01'
    AND try_base64_decode_string(tx_message:txn:apaa[0]::string) IN ('mint', 'burn')
    AND app_id IN (552635992) --Tinyman
    GROUP BY 1,3
    Run a query to Download Data