date_trunc('day', block_timestamp) as date,

sum(msg_value:execute_msg:borrow_stable:borrow_amount::float) / pow(10,6) as daily_borrow_amount

FROM terra.msgs

WHERE tx_status = 'SUCCEEDED'

AND msg_value:execute_msg LIKE '%borrow_stable%'

GROUP BY 1

),

repay as (

SELECT

date_trunc('day', block_timestamp) as date,

sum(msg_value:coins[0]:amount) / pow(10,6) as daily_repay_amount

FROM terra.msgs

WHERE tx_status ='SUCCEEDED'

AND msg_value:execute_msg LIKE '%repay_stable%'

GROUP BY 1

),

liquidations as (

SELECT

date_trunc('d', block_timestamp) as date,

sum(event_attributes:"0_repay_amount"::float) / pow(10,6) as loan_autorepay_amount

FROM terra.msg_events

WHERE event_type = 'from_contract'

AND event_attributes:"0_action" LIKE '%liquidate_collateral%'

AND tx_status = 'SUCCEEDED'

GROUP BY 1

ORDER BY 1

),

earn as (

select

*,

daily_borrow_amount - daily_repay_amount as net_daily_borrow