KaskoazulMinted goETH and goBTC
    Updated 2022-04-08
    with MINT_GOBTC as (
    select block_timestamp::date as fecha,
    sum(tx_message:txn:aamt/pow(10,8)) as mint_goBTC
    from algorand.transactions
    where sender = 'ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4'
    and ASSET_ID = 386192725
    group by 1
    ),

    MINT_GOETH as (
    select block_timestamp::date as fecha,
    sum(tx_message:txn:aamt/pow(10,8)) as mint_goETH
    from algorand.transactions
    where sender = 'ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4'
    and ASSET_ID = 386195940
    group by 1
    )

    select btc.fecha,
    btc.mint_goBTC,
    eth.mint_goETH
    from MINT_GOBTC btc
    inner join MINT_GOETH eth
    on btc.fecha = eth.fecha
    Run a query to Download Data