alizarei73withdraw & supplied
    Updated 2022-08-12
    select
    a.BLOCK_TIMESTAMP::date as date,
    a.AAVE_VERSION,
    sum(a.SUPPLIED_USD) as SUPPLIED,
    sum(SUPPLIED) over( order by date) as CUM_SUPPLIED,
    sum(b.WITHDRAWN_USD) as WITHDRAW,
    sum(WITHDRAW) over(order by date) as CUM_WITHDRAW
    FROM flipside_prod_db.aave.deposits a
    JOIN flipside_prod_db.aave.withdraws b
    ON a.BLOCK_TIMESTAMP = b.BLOCK_TIMESTAMP
    where a.symbol = 'AAVE' and a.BLOCK_TIMESTAMP >= '2021-01-01'
    GROUP by 1,2
    Run a query to Download Data