mohammadhETH Deposited or Withdrawn
    Updated 2022-06-28
    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