date_trunc('day', block_timestamp) as date,

sum(repayed_amount_usd) Repayed_USD,

count(distinct payer) as Payer,

from compound.repayments

WHERE block_timestamp >= CURRENT_DATE -30

GROUP by date, repay_contract_symbol