PS0G1Daily AAVE supplied and withdrawn on Aave protocol.
    Updated 2022-08-13
    With deposit As (
    Select date_trunc('day',block_timestamp) As date, count(DISTINCT tx_id) As tx_supplied_count,sum(supplied_usd) As supplied_volume
    From flipside_prod_db.aave.deposits
    Where block_timestamp > '2022-01-01'
    And symbol = 'AAVE'
    Group By 1
    Order By date ASC
    ),
    withdraw As (
    Select date_trunc('day',block_timestamp) As date, Count(DISTINCT tx_id) As tx_withdrawn_count,sum(withdrawn_usd) As withdrawn_volume
    From flipside_prod_db.aave.withdraws
    Where block_timestamp > '2022-01-01'
    And symbol = 'AAVE'
    Group By 1
    Order By 1
    )
    Select a.date,tx_supplied_count,supplied_volume,tx_withdrawn_count,withdrawn_volume
    From withdraw a
    Left Join deposit b
    On a.date=b.date
    Order By date ASC
    Run a query to Download Data