Step 1: Get a list of bots
In this step, we want to get the list of robots. A robot address is detected when it has more than 15 to 20 movements per minute. Then, using the swap table, we find a list of addresses that have had more than 20 transfers in a period of one minute in the past 60 days, and group them based on the number of time intervals and the number of exchanges. In the last step, we sort by the number of swaps and select the top 30 items in the list. We now have a list of robots
Step 2: Find the list of successful transactions by bots
In this step, we list the transactions that have been successful and have been done in the past 60 days and have been done by robots, these transactions are based on the result of step one, in which we obtained a list of robots' addresses
Step 3: Get a list of successful user transactions
At this step, it is enough to get a list of successful transactions that have not been done by bots. We now have a list of successful transactions of the last 60 days by users