mariyaAamount of gALGO3 mint during Governance commitment period
    Updated 2022-04-27
    --The Governance Commitment Period Started March 31st 2022 12:00:00 GMT and Ended April 14th 6:00:00 GMT(For Folks Finance Liquid Staking)
    --gALGO3 asset ID = 694432641
    with sndrs as (
    SELECT
    sender,
    TX_MESSAGE:dt:itx[0]:txn:xaid as asst,
    TX_MESSAGE:dt:itx,
    TX_MESSAGE:dt:itx[0]:txn:aamt/1e6 as during_gov_amount,
    BLOCK_TIMESTAMP
    FROM
    algorand.application_call_transaction


    WHERE
    TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) = 'm'

    AND
    asst=694432641
    AND
    BLOCK_TIMESTAMP>='2022-03-31' and BLOCK_TIMESTAMP<='2022-04-14 6:00:00'
    --AND
    --TX_MESSAGE:string like '%RXI3PCQNQKI3WJ2XM4ORAJRLXLYYYJFZVCO4F3LIZD56RPPZLGX2UVQ5LU%'

    )
    SELECT
    date_trunc(day,BLOCK_TIMESTAMP),sum(during_gov_amount)
    FROM
    sndrs
    group BY
    date_trunc(day,BLOCK_TIMESTAMP)
    Run a query to Download Data