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'

GROUP BY day, repay_contract_symbol