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,

msg_value:contract::string as contract_address,

c.address_name as contract_label

FROM terra.msgs

LEFT OUTER JOIN terra.labels c

ON msg_value:contract::string = c.address

WHERE msg_value:contract = 'terra1tndcaqxkpc5ce9qee5ggqf430mr2z3pefe5wj6'

AND msg_value:execute_msg:swap IS NOT NULL

AND block_timestamp >= CURRENT_DATE - 7

LIMIT 100