p as ( SELECT block_timestamp:: Date as Date, sum(amount) AS bEth_p

from anchor.collateral WHERE currency='terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun' and event_type= 'provide' group by 1 order by 1 asc)

,

w AS ( SELECT block_timestamp:: Date as Date, sum(amount) AS bEth_w

from anchor.collateral WHERE currency='terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun' and event_type= 'withdraw' group by 1 order by 1 asc )

select

p.Date, sum(p.bEth_p) as provide, sum(w.bEth_w) as withdraw, provide-withdraw as changes

from p left join w on p.Date=w.Date where p.Date<='2022-03-29' and p.Date>'2021-12-29' group by 1 order by 1 asc