KaskoazulMinted goETH and goBTC
Updated 2022-04-08
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
›
⌄
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