date_trunc('day',block_timestamp) as day,

borrower,

repay_contract_symbol,

sum(repayed_amount_usd) as sum_repay

FROM compound.repayments

WHERE block_timestamp >= getdate() - interval '30 days'

AND repayed_amount_usd > 0

GROUP BY day, repay_contract_symbol, borrower

ORDER BY borrower