AryanHow much gALGO3 was minted during the governance commitment period?
    Updated 2022-04-24
    with mint as (
    SELECT
    DATE_TRUNC('day', algorand.application_call_transaction.block_timestamp) AS date,
    algorand.application_call_transaction.tx_id AS Tr_ID,
    algorand.application_call_transaction.SENDER AS snd ,
    algorand.application_call_transaction.TX_GROUP_ID AS GROUP_ID,
    algorand.application_call_transaction.tx_message:dt:itx[0]:txn:aamt/pow(10,6) AS amount
    FROM algorand.application_call_transaction JOIN algorand.asset_transfer_transaction
    ON algorand.application_call_transaction.tx_id = algorand.asset_transfer_transaction.tx_id
    WHERE date >= '2022-3-31 0:00:00' AND date <= '2022-4-14 6:00:00'
    AND ASSET_ID = '694432641'
    AND algorand.asset_transfer_transaction.inner_tx = 'true'
    AND TRY_BASE64_DECODE_STRING(algorand.application_call_transaction.tx_message :txn :apaa [0] :: STRING)='m'
    )
    SELECT
    sum(amount) as Amount,
    date
    from mint
    GROUP BY date
    Run a query to Download Data