COUNT (DISTINCT a.BORROWER) as new_borrower,

SUM (new_borrower) OVER (ORDER BY "date") as acm_new_borrower

FROM (

Select BLOCK_TIMESTAMP::date as "date",

BORROWER,

ROW_NUMBER() OVER (PARTITION BY BORROWER ORDER BY "date") as SrNo

FROM ethereum.maker.ez_flash_loans

WHERE BLOCK_TIMESTAMP >= '2022-01-01' AND TX_STATUS = 'SUCCESS'

) a

WHERE a.SrNo = 1

GROUP BY a."date"

ORDER BY a."date"