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

avg(TOKEN_PRICE) as avg_price,

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,

vol_token / borrower_cnt as avg_vol_pr_borrower,

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

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

sum(vol_usd) over (order by date) as cum_vol_usd,

avg(borrowe_cnt) over (order by date rows between 6 PRECEDING and current row) as "MA 7-date Borrows",

avg(borrower_cnt) over (order by date rows between 6 PRECEDING and current row) as "MA 7-date Borrower",

avg(vol_token) over (order by date rows between 6 PRECEDING and current row) as "MA 7-date Token Volume",

avg(vol_usd) over (order by date rows between 6 PRECEDING and current row) as "MA 7-date USD Volume"

FROM ethereum.aave.ez_borrows

WHERE symbol ilike ('SNX')

AND AAVE_VERSION = 'Aave V2'

GROUP by 1

order by 1