supply as (SELECT date_trunc('week',block_timestamp) as daily,sum(ISSUED_TOKENS) as vol,count(DISTINCT tx_id) as tx, sum(SUPPLIED_USD) as usd

from flipside_prod_db.aave.deposits where SYMBOL='AAVE'

and daily>='2022-01-01' GROUP BY 1),

WITHDRAWN as(

SELECT date_trunc('week',block_timestamp) as daily,sum(WITHDRAWN_TOKENS) as vol,count(DISTINCT tx_id) as tx, sum(WITHDRAWN_USD) as usd

from flipside_prod_db.aave.withdraws where SYMBOL='AAVE'

and daily>='2022-01-01' GROUP BY 1)

select

supply.daily as date,supply.vol as supply_amount, supply.tx as supply_TXN, supply.usd as supply_Volume

,WITHDRAWN.vol as WITHDRAWN_amount, WITHDRAWN.tx as WITHDRAWN_TXN, WITHDRAWN.usd as WITHDRAWN_Volume,

sum(supply_amount) over (order by Date) as cumsupply_amount,

sum(supply_TXN) over (order by Date) as cumsupply_TXN,

sum(supply_Volume) over (order by Date) as cumu_supply_Volume,

sum(WITHDRAWN_amount) over (order by Date) as cum_WITHDRAWN_amount,

sum(WITHDRAWN_TXN) over (order by Date) as cum_WITHDRAWN_TXN,

sum(WITHDRAWN_Volume) over (order by Date) as cum_WITHDRAWN_Volume

from supply left join WITHDRAWN on supply.daily=WITHDRAWN.daily order by 1 desc