alizarei73withdraw & supplied
Updated 2022-08-12
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
a.BLOCK_TIMESTAMP::date as date,
a.AAVE_VERSION,
sum(a.SUPPLIED_USD) as SUPPLIED,
sum(SUPPLIED) over( order by date) as CUM_SUPPLIED,
sum(b.WITHDRAWN_USD) as WITHDRAW,
sum(WITHDRAW) over(order by date) as CUM_WITHDRAW
FROM flipside_prod_db.aave.deposits a
JOIN flipside_prod_db.aave.withdraws b
ON a.BLOCK_TIMESTAMP = b.BLOCK_TIMESTAMP
where a.symbol = 'AAVE' and a.BLOCK_TIMESTAMP >= '2021-01-01'
GROUP by 1,2
Run a query to Download Data