hours,

Repayed_USD,

avg(Payer) as Payer,

repay_contract_symbol

from (

select

hour( block_timestamp) as hours,

date_trunc('day', block_timestamp) as date,

sum(repayed_amount_usd) Repayed_USD,

count(distinct payer) as Payer,

repay_contract_symbol

from compound.repayments

WHERE block_timestamp >= CURRENT_DATE -30

GROUP by hours, repay_contract_symbol, date

group by hours, Repayed_USD, repay_contract_symbol