Ali3NETH Withdrawals from AAVE
Updated 2022-09-22
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select case when block_timestamp >= '2022-08-01' and block_timestamp < '2022-09-15' then 'Before Merge'
when block_timestamp >= '2022-09-15' then 'Post Merge' else null end as timespan,
block_timestamp::date as date,
count (distinct tx_hash) as tx_count,
count (distinct depositor_address) as Users_Count,
sum (withdrawn_tokens) as Volume,
sum (withdrawn_usd) as Usd_Volume
from ethereum.aave.ez_withdraws
where timespan is not null and symbol = 'WETH'
group by 1,2
Run a query to Download Data