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