MetiocregoBTC and goETH mint vs redeem
    Updated 2022-04-26
    with
    mints as (
    select
    block_timestamp::date as date,
    count(distinct asset_receiver) as minters,
    count(distinct tx_id) as mints
    from algorand.asset_transfer_transaction where sender ='ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4' and asset_amount is not null
    and asset_transferred in ('386195940','386192725')
    group by 1
    ),
    redeems as (
    select
    block_timestamp::date as date,
    count(distinct sender) as redeemers,
    count(distinct tx_id) as redeems
    from algorand.asset_transfer_transaction where asset_receiver ='ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4' and asset_amount is not null
    and asset_transferred in ('386195940','386192725')
    group by 1
    )
    SELECT
    x.date,
    redeemers,
    sum(redeemers) over (order by x.date) as cum_redeemers,
    redeems,
    sum(redeems) over (order by x.date) as cum_redeems,
    minters,
    sum(minters) over (order by x.date) as cum_minters,
    mints,
    sum(mints) over (order by x.date) as cum_mintings,
    redeems/(redeems+mints) as redeems_rate,
    1-redeems_rate as mints_rate,
    redeemers/(redeemers+minters) as redeemers_rate,
    1-redeemers_rate as minters_rate
    from mints x
    full join redeems y where x.date=y.date
    order by 1 asc
    Run a query to Download Data