-- forked from afc2ca2e-9d1b-4f80-b415-d194bf2cb4eb
SELECT
avg(borrow_volume_usd),
median(borrow_volume_usd),
avg(borrow_events),
median(borrow_events)
FROM (
SELECT
borrower_address,
-- symbol,
sum(BORROWED_USD) as borrow_volume_usd,
count(DISTINCT tx_hash) as borrow_events,
min(block_timestamp) as first_borrow_time
FROM ethereum.aave.ez_borrows
--WHERE symbol in ('SNX', 'UNI', 'MKR')
WHERE symbol like 'UNI'
AND aave_version LIKE 'Aave V2'
GROUP BY 1
ORDER BY borrow_volume_usd DESC
)