mariyaMintings volume
    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,
    (case when ( BLOCK_TIMESTAMP>='2022-03-31' and BLOCK_TIMESTAMP<='2022-04-14 6:00:00') then TX_MESSAGE:dt:itx[0]:txn:aamt/1e6 end) as during_gov_amount,
    (case when not( BLOCK_TIMESTAMP>='2022-03-31' and BLOCK_TIMESTAMP<='2022-04-14 6:00:00') then TX_MESSAGE:dt:itx[0]:txn:aamt/1e6 end) as out_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
    --TX_MESSAGE:string like '%RXI3PCQNQKI3WJ2XM4ORAJRLXLYYYJFZVCO4F3LIZD56RPPZLGX2UVQ5LU%'

    )
    SELECT
    sum(during_gov_amount) as amount,'in gornance period' as duration
    FROM
    sndrs
    union
    SELECT
    sum(out_gov_amount) as amount,'out of gornance period' as duration
    FROM
    sndrs

    Run a query to Download Data