mariyabETH being held
Updated 2022-03-27
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
'bETH' as bAsset,
m.msg_value:contract,
l.label as other_usage,
(sum(msg_value:execute_msg:provide_liquidity:assets[1]:amount/1e6))/820000 as amount_used
from terra.msgs m join terra.labels l
on m.msg_value:contract = l.address
where msg_value:execute_msg:provide_liquidity:assets[0]:info:token:contract_addr = 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun'
and msg_index = 1
group by 1,2,3
order by 3 desc