date_trunc('{{Time_Interval}}', BLOCK_TIMESTAMP)::date as date,

symbol,

COUNT(DISTINCT TX_HASH) as borrowe_cnt,

COUNT(DISTINCT BORROWER_ADDRESS) as borrower_cnt,

sum(BORROWED_TOKENS) as vol_token,

sum(BORROWED_USD) as vol_usd,

sum(borrowe_cnt) over (partition by symbol order by date) as cum_borrowe_cnt,

sum(vol_token) over (partition by symbol order by date) as cum_vol_token,

sum(vol_usd) over (partition by symbol order by date) as cum_vol_usd

FROM ethereum.aave.ez_borrows

WHERE AAVE_VERSION = 'Aave V2'

GROUP by 1,2

order by 1