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_dep,

date_trunc('day', block_timestamp) as dt

from all_tx

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

and deposit like '%deposit%'

and tx_status != 'FAILED'

group by 1,3

),

withdraw as (

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

'withdraw' as wthdraw,

date_trunc('day', block_timestamp) as dt4

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,3

),

borrow as (

select 'borrow' as borrow,

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

date_trunc('day', block_timestamp) as dt2

from all_tx

where borrow like '%borrow%'