symbol,

COUNT(DISTINCT TX_HASH) as borrowe_cnt,

COUNT(DISTINCT BORROWER_ADDRESS) as borrower_cnt,

sum(BORROWED_TOKENS) as vol_token,

sum(BORROWED_USD) as vol_usd,

vol_usd / borrower_cnt as avg_vol_pr_borrower

FROM ethereum.aave.ez_borrows

WHERE symbol in ('SNX', 'UNI', 'MKR')

AND AAVE_VERSION = 'Aave V2'

GROUP by 1