trunc(block_timestamp, 'week') as date,

SUM(msg_value:execute_msg:borrow_stable:borrow_amount / POW(10,6)) as borrowed_amount

FROM terra.msgs

LEFT OUTER JOIN terra.labels c

ON msg_value:contract::string = c.address

WHERE msg_type = 'wasm/MsgExecuteContract'

AND msg_value:contract = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'

AND msg_value:execute_msg:borrow_stable IS NOT NULL

AND block_timestamp >= CURRENT_DATE - 56

GROUP BY 1

ORDER BY 1 DESC

LIMIT 100