-- forked from b646a302-8cc0-46cc-b9a6-f4e8869bb050
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