MetiocregoBTC and goETH mint vs redeem
Updated 2022-04-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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