mohammadh2)Aave-7.AAVE and stAAVE movements
    Updated 2022-08-11
    with A as (select
    date_trunc('day', block_timestamp) as block_day,
    count(distinct TX_ID) as deposit_tx_count,
    count(distinct DEPOSITOR_ADDRESS) as deposit_unique_users,
    sum(SUPPLIED_USD) as usd_deposit,
    sum(ISSUED_TOKENS) as aave_deposit,
    sum(usd_deposit) over (order by block_day asc) as deposit_usd_accumulation,
    sum(deposit_unique_users) over (order by block_day asc) as deposit_user_accumulation,
    sum(aave_deposit) over (order by block_day asc) as deposit_aave_accumulation,
    sum(deposit_tx_count) over (order by block_day asc) as deposit_tx_accumulation
    from flipside_prod_db.aave.deposits
    where BLOCK_TIMESTAMP >= '2022-01-01'
    and SYMBOL='AAVE'
    group by block_day),

    B as (select
    date_trunc('day', block_timestamp) as block_day,
    count(distinct TX_ID) as withdrawn_tx_count,
    count(distinct DEPOSITOR_ADDRESS) as withdrawn_unique_users,
    sum(WITHDRAWN_USD) as usd_withdrawn,
    sum(WITHDRAWN_TOKENS) as aave_withdrawn,
    sum(usd_withdrawn) over (order by block_day asc) as withdrawn_usd_accumulation,
    sum(aave_withdrawn) over (order by block_day asc) as withdrawn_aave_accumulation,
    sum(withdrawn_unique_users) over (order by block_day asc) as withdrawn_user_accumulation,
    sum(withdrawn_tx_count) over (order by block_day asc) as withdrawn_tx_accumulation
    from flipside_prod_db.aave.withdraws
    where BLOCK_TIMESTAMP >= '2022-01-01'
    and SYMBOL='AAVE'
    group by block_day)

    select * from A join B using (block_day)


    Run a query to Download Data