headitmanagerETH Deposited or Withdrawn(number of transactions) per day
Updated 2022-06-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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