headitmanagerETH Deposited or Withdrawn(number of transactions) per day
    Updated 2022-06-27
    with all_data as
    ( select eth_to_address,eth_from_address,amount , block_timestamp , case
    when eth_to_address=lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419') then 'Ethereum to starknet'
    when eth_from_address=lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419') then 'starknet to Ethereum'
    end as type
    from ethereum.core.ez_eth_transfers
    where
    eth_to_address=lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419')
    or
    eth_from_address=lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419')
    )

    select count(distinct eth_to_address) as val , block_timestamp::date,'starknet to Ethereum' as type from all_data where type='starknet to Ethereum'
    group by block_timestamp::date
    UNION
    select count(distinct eth_from_address) as val,block_timestamp::date,'Ethereum to starknet' as type from all_data where type='Ethereum to starknet'
    group by block_timestamp::date
    Run a query to Download Data