block_id,

block_timestamp,

tx_id,

msg_value:sender::string as sender,

msg_value:execute_msg:swap:offer_asset:amount / POW(10,6) as swap_amount,

msg_value:execute_msg:swap:offer_asset:info:native_token:denom::string as swap_currency,

tx_status

FROM terra.msgs

WHERE tx_id = '5BA5CB9A6D9EB02E6285EE7846341DE314FDA85F1653CC0D7173CB7CBDDC4DA0'

LIMIT 1