Aave_Deposited as (

select

BLOCK_TIMESTAMP::date as date,

sum(ISSUED_TOKENS) as ETH_Deposited,

sum(ETH_Deposited) over(order by date) as Cum_ETH_Deposited

from ethereum.aave.ez_deposits

where

BLOCK_TIMESTAMP >= '2022-09-08' and BLOCK_TIMESTAMP < '2022-09-15'

and symbol = 'WETH'

and ISSUED_TOKENS > 0

group by 1

),

Aave_Withdrawn as (

select

BLOCK_TIMESTAMP::date as date,

sum(WITHDRAWN_TOKENS) as ETH_Withdrawn,

sum(ETH_Withdrawn) over(order by date) as Cum_ETH_Withdrawn

from ethereum.aave.ez_withdraws

where

BLOCK_TIMESTAMP >= '2022-09-08' and BLOCK_TIMESTAMP < '2022-09-15'

and symbol = 'WETH'

and WITHDRAWN_TOKENS > 0

group by 1

),

Aave as (

select *,

ETH_Deposited - ETH_Withdrawn as Net_ETH_Deposit,

avg(Net_ETH_Deposit) over(order by d.date ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as Seven_D_Moving_Average,

sum(Net_ETH_Deposit) over(order by d.date) as Cum_Net_ETH_Deposited,

'Aave' as Porotocol

from Aave_Deposited d join Aave_Withdrawn w on d.date = w.date

),