freemartianDaily goBTC & goETH Burn
Updated 2022-05-21
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select sum(asset_amount)/1000000 as burn_amount, date_trunc('day', block_timestamp) as DATE,
(CASE
when asset_id = '386195940' then 'goETH'
when asset_id = '386192725' then 'goBTC'
else 'others'
end) as asset
from flipside_prod_db.algorand.asset_transfer_transaction
where asset_receiver = 'ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4'
and asset_id in ('386192725', '386195940')
and block_timestamp::date > '2022-02-01'
group by asset, DATE
Run a query to Download Data