Abbas_ra21Aave Eth remove
Updated 2022-09-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
with withdraw AS (select
date_trunc('{{Timeframe}}', BLOCK_TIMESTAMP) AS date,
sum(WITHDRAWN_TOKENS) AS ETH_Amount,
count(distinct DEPOSITOR_ADDRESS) AS distinct_User_number,
count(*) AS events_number
from ethereum.aave.ez_withdraws
where SYMBOL like '%ETH%' and date between '2022-07-15' and '2022-09-15'
group by 1),
borrow AS (select
date_trunc('{{Timeframe}}', BLOCK_TIMESTAMP) AS date,
sum(BORROWED_TOKENS) AS ETH_Amount,
count(distinct BORROWER_ADDRESS) AS distinct_User_number,
count(*) AS events_number
from ethereum.aave.ez_borrows
where SYMBOL like '%ETH%' and date between '2022-07-15' and '2022-09-15'
group by 1)
select
A.date AS date,
A.ETH_Amount+B.ETH_Amount AS "ETH Amount",
avg("ETH Amount") over (order by A.date, A.date rows between 6 preceding and current row) as "7 day MA",
A.distinct_User_number+B.distinct_User_number AS "distinct User number",
avg("distinct User number") over (order by A.date, A.date rows between 6 preceding and current row) as "7 day distinct user MA",
A.events_number+B.events_number AS "events number",
avg("events number") over (order by A.date, A.date rows between 6 preceding and current row) as "7 day events MA"
from withdraw A inner join borrow B on A.date=B.date
Run a query to Download Data