count(DISTINCT borrower_address) as borrowers,

count(DISTINCT tx_hash) as borrows,

sum(borrowed_usd) as usd_volume

from ethereum.aave.ez_borrows

where block_timestamp::date >= CURRENT_DATE -30

group by 1

UNION ALL

select 'Compound' as platform,

count(DISTINCT borrower) as borrowers,

count(DISTINCT tx_hash) as borrows,

sum(loan_amount_usd) as usd_volume

from ethereum.compound.ez_borrows

where block_timestamp::date >= CURRENT_DATE -30

group by 1