date(block_timestamp) as block_date,

sum(msg_value:execute_msg:borrow_stable:borrow_amount / POW(10,6)) as borrowed_amount_usd

from terra.msgs

WHERE msg_value:execute_msg:borrow_stable is not null

group by block_date;