PapasotAlgofi Governance 3
    Updated 2022-04-20
    select *,
    try_base64_decode_string(tx_message:txn:note::string) as message,
    regexp_replace(message, '^af/gov1:j{"com":|}$|,.*') as amount
    -- amount/1e6 as Algo
    from algorand.application_call_transaction
    WHERE
    app_id = '465818260' AND
    block_timestamp > '2022-03-30'
    AND
    try_base64_decode_string(tx_message:txn:note::string) like 'af/gov1:j{"com":%'

    Run a query to Download Data