SELECT

DATE_TRUNC('day', block_timestamp) AS transaction_date,

tx_hash,

MAX(

CASE

WHEN function_name = 'makePayment' THEN decoded_input_data:"borrower"::STRING -- Assuming borrower is in input

ELSE NULL

END

) AS borrower_address,

MAX(

CASE

WHEN function_name = 'makePayment' THEN decoded_output_data:"amount"::FLOAT / POW(10, 6) -- Assuming amount is in output

ELSE NULL

END

) AS payment_amount

FROM ethereum.core.ez_decoded_traces

WHERE function_name = 'makePayment'

AND from_address = LOWER('0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0')

GROUP BY DATE_TRUNC('day', block_timestamp), tx_hash

HAVING borrower_address IS NOT NULL

SELECT

borrower_address,

transaction_date,

tx_hash,

payment_amount,

ROW_NUMBER() OVER (PARTITION BY borrower_address ORDER BY transaction_date, tx_hash) AS borrower_tx_order

FROM payment_transactions

ORDER BY borrower_address, borrower_tx_order;