msg_value:sender::string as Liquidity_provider,

msg_value,

msg_value:contract::string as Contract_pair,

msg_value:execute_msg:provide_liquidity:assets[0]amount/1e6 as UST,

case when msg_value:coins[0]:denom::string = 'uusd' then 'UST'

else 'LUNA'

end as token1,

msg_value:execute_msg:provide_liquidity:assets[0]:amount/1e6 as amount,

msg_value:execute_msg:provide_liquidity:assets[0]:info:token:contract_addr::string as token2

from terra.msgs

where msg_value like '%provide_liquidity%'