granadohoTotal gALGO3 was minted during the Governance Commitment Period
    Updated 2022-04-23
    with tx_list as (
    select
    distinct tx_group_id
    from algorand.transactions
    where asset_id in (0, 694432641)
    and tx_type in ('axfer', 'pay')
    and tx_type_name in ('asset transfer', 'payment')
    and block_timestamp::date >= '2022-03-31' and block_timestamp::date <= '2022-04-14'
    )

    select
    sum(tx_message:txn:aamt/1e6) as total_galgo3
    from algorand.transactions
    where asset_id = '694432641'
    and tx_type_name = 'asset transfer'
    and tx_type = 'axfer'
    and tx_group_id in (select * from tx_list)


    Run a query to Download Data