select
case
when asset_transferred='386195940' then 'goETH'
when asset_transferred='386192725' then 'goBTC'
end as asset,
sum(asset_amount)/1e8 as circulating_supply
from algorand.asset_transfer_transaction where sender ='ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4' and asset_amount is not null
--limit 100
group by asset