SELECT

date_trunc('day',block_timestamp) AS date, sum(SUPPLIED_USD) AS supply

FROM

flipside_prod_db.aave.deposits

WHERE

symbol ='AAVE'

GROUP BY date, symbol, aave_version),

pools_withdraws AS (

SELECT

date_trunc('day',block_timestamp) AS date1, sum(WITHDRAWN_USD) AS withdraws

FROM

flipside_prod_db.aave.withdraws

WHERE

symbol ='AAVE'

GROUP BY date1, symbol, aave_version

SELECT

supply, date, withdraws

FROM

pools_supplies, pools_withdraws

GROUP BY

date ,supply, withdraws

ORDER BY

date