SELECT
*,
sum(new_borrower) over (partition by symbol order by min_week) as total_borrowers
FROM (
SELECT
min_week,
symbol,
count(*) as new_borrower
FROM (
SELECT
borrower_address,
symbol,
min(date_trunc('week', block_timestamp)) as min_week
FROM ethereum.aave.ez_borrows
WHERE symbol in ('SNX', 'UNI', 'MKR')
AND aave_version LIKE 'Aave V2'
GROUP BY 1,2
) GROUP BY 1,2
)