hbd19943. ETH Withdraw from AAVE
Updated 2022-09-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with all_data as (select
case
when block_number < '15537351' then 'Pre-Merge'
when block_number >= '15537351' then 'Post-Merge' end as date_status,*
FROM ethereum.aave.ez_withdraws
where block_timestamp >= '2022-09-04' and block_timestamp < '2022-09-27')
select
date(block_timestamp) as "Date",
date_status as "Timeline",
count(*) as "Number of ETH Withdrawals",
count(distinct DEPOSITOR_ADDRESS) as "Number of Withdrawers",
sum(WITHDRAWN_TOKENS) as "Amount of ETH Withdrawn"
from all_data
where symbol = 'WETH'
group by 1 , 2
order by 1
Run a query to Download Data