flipside

    Show the total amount of gALGO3 minted over time by day including outside the governance commitment period. Has a lot of gALGO3 been minted outside the governance commitment period?
    AryanShow the total amount of gALGO3 minted over time by day including outside the governance commitment period. Has a lot of gALGO3 been minted outside 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 TX_GROUP,
    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 ASSET_ID = '694432641'
    AND TRY_BASE64_DECODE_STRING(algorand.application_call_transaction.tx_message :txn :apaa [0] :: STRING)='m'
    AND algorand.asset_transfer_transaction.inner_tx = 'true'
    )

    SELECT
    sum(amount) as Amount,
    date
    from mint
    GROUP BY date
    Run a query to Download Data