Hi, I’m a computer engineering student and this semester I had to design a “big data” project. I decided to analyze periodic transactions on Ethereum blockchain.
I downloaded the entire Ethereum blockchain and then I analyzed it using Spark.
The idea is to take all the transactions of each address, then I sort the blocks of each transaction, I calculate the difference between each block and finally I calculate the standard deviation of this array. In that way when an address has a low standard deviation, it means that, that address creates periodic transactions.
Now I’m visualizing the results and I’m a bit surprised.
Standard deviation: it indicates how the transactions are periodic. The more this value is low, the more the transactions are periodic.
Period: mean number of blocks between each transactions of an address
Number of blocks: number of blocks that contains transactions of the current address
Value: the whole value transacted by an address
As you can see there are a lot of address that received exactly 101 Ethereum, by a lot of little periodic transactions. Can you help me to understand what kind of activity these address were doing?