hour( block_timestamp) as hours,

date_trunc('hour', block_timestamp) as date,

sum(repayed_amount_usd) Repayed_USD,

count(distinct payer) as Individual_Addresses,

count(distinct tx_id) transactions

--, repay_contract_symbol

from compound.repayments

WHERE block_timestamp >= CURRENT_DATE -30 --date_trunc('hour', block_timestamp) = '2021-04-25T21:00:00Z' --

GROUP by --repay_contract_symbol,

hours, date