mariyabETH being held
    Updated 2022-03-27

    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