(select distinct tx_id, *

from terra.msgs

where msg_module = 'wasm'

and msg_value:contract = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'),

deposit as

(select msg_value:execute_msg::string as deposit,

sum(msg_value:coins[0]:amount/1e6) as amount_depo,

avg(msg_value:coins[0]:amount/1e6) as average_depo,

date_trunc('day', block_timestamp) as day1

from genesis

where msg_value:coins[0]:denom = 'uusd'

and deposit like '%deposit%'

and tx_status != 'FAILED'

group by 1,4),

withdraw as

(select sum(msg_value:execute_msg:send:amount/1e6) as withdraw,

date_trunc('day', block_timestamp) as day2

from terra.msgs

where msg_module = 'wasm'

and msg_value:execute_msg:send:contract = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'

and tx_status != 'FAILED'

and msg_value:execute_msg:send:msg like '%redeem%'

group by 2),

borrow as

(select 'borrow' as borrow,

sum(msg_value:execute_msg:borrow_stable:borrow_amount/1e6) as amount_bor,

avg(msg_value:execute_msg:borrow_stable:borrow_amount/1e6) as average_bor,

date_trunc('day', block_timestamp) as day3

from genesis

where borrow like '%borrow%'

and tx_status != 'FAILED'

and msg_value like '%borrow%'