mohammadhETH Deposited or Withdrawn
Updated 2022-06-28
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select count(distinct ORIGIN_FROM_ADDRESS) as number_users,sum (AMOUNT) as sum_amount,date_trunc('day',block_timestamp) as block_day,
avg(AMOUNT) as avg_volume,
case
when ORIGIN_FUNCTION_SIGNATURE ='0x00f714ce' then 'withdrawn'
when ORIGIN_FUNCTION_SIGNATURE = '0xb6b55f25' then 'deposit'
end as TX_TYPE
from ethereum.core.ez_eth_transfers
where ORIGIN_TO_ADDRESS =lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419')
and block_day >='2022-04-01'
and TX_TYPE is not null
group by block_day,TX_TYPE
Run a query to Download Data