date_trunc('day', block_timestamp) as date,

count(distinct tx_hash) as tx_count,

count(distinct from_address) as unique_user,

sum(value) as Collateral,

sum(CAST(utils.udf_hex_to_int(CONCAT('0x', SUBSTR(input_data, 139, 64))) AS NUMERIC)/1e18 )AS musd_borrow

from mezo.testnet.fact_transactions

where

to_address = '0x20faea18b6a1d0fcdbccfffe3d164314744baf30' --BorrowerOperations contract

and tx_succeeded = 'True'

and ORIGIN_FUNCTION_SIGNATURE = '0x8e54c119' --adjustTrove

group by 1

order by date asc