date_trunc('day',block_timestamp) as day,

repay_contract_symbol,

--repayments

avg(repayed_amount_usd) as repayed_amount_usd,

count(DISTINCT compound.repayments.borrower) as distinct_repayers,

count(compound.repayments.borrower) as repayments

FROM compound.market_stats

JOIN compound.repayments

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

AND

( repay_contract_symbol = 'WBTC'

OR repay_contract_symbol = 'WBTC2'

OR repay_contract_symbol = 'ETH'

OR repay_contract_symbol = 'DAI'

OR repay_contract_symbol = 'USDC'

OR repay_contract_symbol = 'USDT'

)

GROUP BY day,

repay_contract_symbol

ORDER BY 1 DESC