repay_contract_symbol,

sum(repayed_amount_usd) as repaid_usd

FROM compound.repayments

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

GROUP BY repay_contract_symbol