Description of work

StarkNet is a layer-2 chain that ensures interoperability with Ethereum mainnet. People are using it to move real ETH to StarkNet and enjoy its higher speed of transaction and lower fees. In this bounty we want to examine deposited and withdrawn for ETH bridged to StarkNet or from Ethereum. To do this, we examine the following:

• How many ETHs have been deposited or withdrawn bridged to StarkNet or from Ethereum?
• How many depositors deposited or withdrawn bridged to StarkNet or from Ethereum?

Note

• We use the [ethereum.core] schema and [fact_transactions] table
• StarkNet proxy contract on Ethereum is 0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419
  • etherscan
• The Deposit method is 0xb6b55f25
  • origin_function_signature = '0xb6b55f25' ---> etherscan
• The Withdraw method is 0x00f714ce
  • origin_function_signature = '0x00f714ce' ---> etherscan
• When a Deposit is made, an address bridged an ETH value to StarkNet with StarkNet proxy contract
  • Sample transaction
• When a Withdraw is made, an address bridged an ETH value from StarkNet to Ethereum with StarkNet proxy contract
  • Sample transaction
• For find the amount of Withdraw in [fact_transactions] table we use the [(tx_json:receipt:logs[0]:decoded:inputs:amount::float)/1e18], because the value eth_value field is empty in Withdraw mode

1 ---> How many ETHs have been deposited or withdrawn bridged to StarkNet or from Ethereum?

According to the results, it is clear that

• It can be seen that users bridge more to StarkNet (deposit) on a daily basis
• The highest value bridged to StarkNet (deposit) is May 10, followed by May 22 and May 24

According to the results, it is clear that

• More users Deposit (bridged to StarkNet) than Withdraw (bridged to Ethereum)
• From the amount of 486 ETH that is bridged, 446.4543593 ETH is related to Deposit, ie about 91.8% of the total amount of ETH and 40.03 ETH is related to Withdraw, ie about 8.23%
• From 24702 number of transaction that is bridged, 23096 is related to Deposit, ie about 93.5% of the total number of transaction and 1607 is related to Withdraw, ie about 6.51%
• The results show that users withdraw a small amount of ETH

2 ---> How many depositors deposited or withdrawn bridged to StarkNet or from Ethereum?

According to the results, it is clear that

• The total number of unique depositors is 18572
• Out of 18572 depositors, 18491 have Deposited and 1341 have done Withdraw
• According to the results, it is clear that 1260 users have done both Withdraw and Deposit

Conclusion

According to the results and the analysis performed, it was found that more users Deposit to StarkNet, and the volume of ETH and more transactions to bridge to StarkNet have been recorded.

According to the results, it is clear that

• Address 0x96845db35a4e43d217a633e02312fa4668d947ff with 20.553163629 ETH has made the most Deposit amount, approximately 4.6% of the total Deposit amount
• Address 0xdec2216fcbf07810d29f25c439ba6214436c4f36 with 1.265 ETH did the most with Withdraw, approximately 3.16% of total Withdraw