*,

sum(borrow_volume_usd) over (partition by symbol order by week) as total_borrow_volume_usd,

sum(borrow_events) over (partition by symbol order by week) as total_borrow_events_usd

FROM (

SELECT

date_trunc('week', block_timestamp) as week,

symbol,

sum(BORROWED_USD) as borrow_volume_usd,

count(DISTINCT tx_hash) as borrow_events,

count(DISTINCT borrower_address) as borrowers

FROM ethereum.aave.ez_borrows

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

AND aave_version LIKE 'Aave V2'

GROUP BY 1,2