0xKARTOD commented 2 years ago

Related Safe Addresses

List of addresses that have yellow 🟡 and green 🟢 score: See all info at Methodology part

green_and_yellow_addresses_reworked.csv https://dune.com/queries/1277996

List of addresses that have red 🔴 score:

red_addresses_reworked.csv https://dune.com/queries/1268823/2173773 ~ 500 addresses

All addresses list:

score_results_reworked.csv https://dune.com/queries/1262047/2162924

Reasoning

In this report we tried to analyze the addresses of airdrop farmers. All the data was obtained using the Dune Analytics database.

A ranking system was built for airdrop addresses based on the following parameters:

Number of transactions in a given period.
Specific fees per transaction - fees to transactions ratio
Created after GIP-29
Made by the same wallet

Of course, satisfying one of these points is not proof that the address is a farmer. For example I could create a Safe address in 2021, but have only 3-4 transactions during GIP-29. Therefore, a model for evaluating such wallets on a 100-point system was proposed.

Methodology

First of all, let us mention three important references to Dune query:

Using the query [2], let's look at the number of Safe addresses created by one wallet and build the distribution. In a recent tweet I already mentioned wallet 0x5769770f5efe8fb017fb09b6de3b2d096668377d - this address created 5900 Safe addresses in the period from early 2022 to August 18, 2022 (hereinafter - event period).

It turned out that during the period of this event:

At least 5 wallets created more than 100 Safe addresses
13 wallets with more than 50 Safe addresses
And etc.

Next, using the query [3], let's look at the activity considering all the official master copies (singlet) in the Ethereum main network:

0x8942595A2dC5181Df0465AF0D7be08c8f23C93af (0.1.0)
0xb6029EA3B2c51D09a50B53CA8012FeEB05bDa35A (1.0.0)
0xaE32496491b53841efb51829d6f886387708F99B (1.1.0)
0x34CfAC646f301356fAa8B21e94227e3583Fe3F5F (1.1.1)
0x6851d6fdfafd08c0295c392436245e5bc78b0185 (1.2.0)
0xd9db270c1b5e3bd161e8c8503c55ceabee709552 (1.3.0)
0x3e5c63644e683549055b9be8653de26e0b4cd36e (1.3.0L2)

Namely, the following parameters - the number of transactions during this period, fees spent on transactions and the relative fees ( Fees / number of transactions ). Gas spend on txs is a good indicator on how valuable a txs was for the executor at the time of the tx .

Thus, the following important data were obtained:

The maximum number of transactions is 2,256
The maximum Fees to tx ratio - 1.49

But now how do we determine what is the optimal number of transactions to determine the airdrop farmer? Is the creation of a Safe Address proof that it is a farmer? We need to come up with a system or methodology to measure activity, amount of gas spent, address creation in 2022, etc.

Let's make the following grading system, where the maximum is 100 points:

If the address was made in 2022 (during GIP-29), it gets a penalty of 10 points
If the original address has more than 1 Safe address, it gets -30 points
If the number of transactions at that Safe address is <3, it gets -15 points
Also a penalty of (1450 - txs count)/48, that is, the maximum penalty will be 30 points
As well as a penalty for the amount of gas per transaction (1.18 - fees per txs ratio)*12.7, so the maximum penalty will be the size of 15 points.

Why 1450 txs and 1.18 fees?

Let's first look at the number of transactions for each wallet. We see that the maximum number of transactions is 2256, but further we see a big gap between the first and second address, between the second and third, that is up to values ~900 transactions distribution has dedicated steps, which is best to smooth. So the best we can do is to take the average of the first five addresses and get 1450. Similar steps are done for gas.

Changes:

Lots of feedback has been received directly on the forum, that is why we have changed the criteria and methodology for calculating the score.

Tx fees

First of all, we excluded gas from consideration in this methodology. First, because the price of gas varies depending on the period you want to consider. And secondly, not a few users simply save and wait for the right time when the price of gas is lowest, and only then make a transaction.

Related Safe Addresses

Let's go a little deeper into the Related Safe Addresses system and say that if, for example, the original wallet has two addresses, he gets a penalty of 5 points (30 before).

If the purse has three Safe addresses - penalty of 15 points If more than or equal to 5, then a penalty of 30 points And the highest penalty, if more than 100 Safe addresses - 45 points

Also, we took into account the two addresses: '0x9e0bce7ec474b481492610eb9dd5d69eb03718d5' - Tokemak address 0x5769770f5efe8fb017fb09b6de3b2d096668377d' - Staker App address We treat them and the related addresses as separate addresses

Transactions Added regular transactions such as "Transfer", not only official master copies. Instead of calculating something by formula, taking averages, and so on, let's just say the following:

If the address has 0 transactions, then we impose a penalty of 50 points
If the address has 1 transactions, minus 40 points
If the address has 1 to 3 transactions - that is, the minimum number of transactions requested in GIP-29, then a penalty of 30 points

We also add a couple of points for addresses that have more than 50 transactions

Difference in the time of Safe address creation

A new parameter to consider is the time difference in creating addresses (with the exception of Tokemak and Staker App). For example, if the same user creates two addresses 1 hour apart, is that suspicious? I think so. And what if it happens on one day, for example? - That's not so bad. So again we introduce a penalty system and calculate the minimum and average interval between the addresses for each original address. The query below will help us with this.

https://dune.com/queries/1261299

If the minimum difference is less than 1 hour - remove 25 points If 3 hours - 15 points

If the average is less than 5 hours and there is only one Safe address, another penalty of 5 points

Score calculation

Given that the maximum penalty will be 100 (if the address has more than 100 Safe addresses, has less than 1 transaction in the GIP-29 period, if there are additional Safe addresses and they were created less than 1 hour apart) the Score is now calculated as:

Score in range from 0 to 33 then red circle 🔴
Score in range from 33 to 66 then yellow circle 🟡
Score > 66 then green 🟢

Safe Address

0x1B491d59846cb605A24a4690Df631946E52a2D0e

df158888 commented 2 years ago

Well, you will be the whale of Gnosis. This project will become yours. excellent

jimmylao888 commented 2 years ago

I don't think this is more reasonable, I think the community is more important, thank you

0xKARTOD commented 2 years ago

If the address was made in 2022, it gets a penalty of 10 points ? I don't think it's right ,please be careful..

I think it makes sense: First of all, we only take off 10% of the total points - that is not that big a deal.

Second, if the address was made during the GIP-29 period, from 2022-01-01 to 2022-08-18 (not before 2022), then suspicion may arise - whether it is an ordinary user or it is a farmer who just wants to get airdrop. Of course this is not direct proof that he is a farmer, so only 10%.

Also, we have a lot of addresses on our lists that were done in 2022 and yet made the green and yellow lists

EjayFang commented 2 years ago

Great, I have two safes, one I haven't used, and I don't expect this one to get an airdrop, and deduct points for it

washiontan commented 2 years ago

和什么时候创建的关系度应该降低的。什么时候创建都是用户啊，创建多个的才是。

EjayFang commented 2 years ago

So, when a person has two safes and the other one is not used, does this also deduct points?

EjayFang commented 2 years ago

Also, if I only have two safes and I need one to be bound to an address and the other to a different person, can I deduct points?

0xKARTOD commented 2 years ago

You mean there are only 6500 real users? What a stupid proposal that killed most of the real users

This does not mean that the green and yellow ones are real addresses/users. These are only users who are somehow worthy of this airdrop - active users of this project. If you think the orange ones are also worthy - I can tell you that most of them have 1 transaction.

0xKARTOD commented 2 years ago

Also, if I only have two safes and I need one to be bound to an address and the other to a different person, can I deduct points?

You mean that one of Safe address was created by (for example) address number 1 and the second by number 2?

hinesec commented 2 years ago

又搞什么幺蛾子啊

EjayFang commented 2 years ago

Also, if I only have two safes and I need one to be bound to an address and the other to a different person, can I deduct points?

You mean that one of Safe address was created by (for example) address number 1 and the second by number 2?

I mean, I have a safe bound to a and one bound to b and they are different people and I can't tie their money together, so I think it is reasonable for one person to have two safes, the condition should change

PulsarNetwork commented 2 years ago

Hello sir, 0x5769 who created 5k Safes is not a user. In fact, it's operated by Staker App wallet for creating user wallets in batches. Please see https://github.com/safe-global/safe-user-allocation-reports/issues/365 for details. (I do think most of the Safes it created should be denied airdrop, but not all)

EjayFang commented 2 years ago

Of course there is a problem with having multiple safes at the same time, but this number needs to be changed, otherwise it will hurt normal users

0xKARTOD commented 2 years ago

Also, if I only have two safes and I need one to be bound to an address and the other to a different person, can I deduct points?

You mean that one of Safe address was created by (for example) address number 1 and the second by number 2?

I mean, I have a safe bound to a and one bound to b and they are different people and I can't tie their money together, so I think it is reasonable for one person to have two safes, the condition should change

I see. Let me explain and refer to my previous reply.

Of course here we deduct 30 points immediately for a second account made in 2022. Note: if you made address A before 2022 and address B in 2022, i.e. you actually have two addresses, points are not deducted. Naturally, there's a good chance that addresses with more than 1 Safe address are farmers, but again, that's just a guess.

Plus, I will say that there is a good example, when the owner of the Safe address also has other Safe addresses and thus gets a yellow circle. In this example is clearly seen when one of the addresses is passive - that is, has few transactions, etc., and the other is active and has 1700 transactions

EjayFang commented 2 years ago

1700 transactions

What is the concept of 1700 transactions, how many people will have 1000 transactions in their own addresses

EjayFang commented 2 years ago

Don't take high requirements to filter users, when a person needs 1700 transactions to qualify by himself, this is already unqualified

0xKARTOD commented 2 years ago

@EjayFang and @PulsarNetwork , it's make sence - let me think what I can do

PulsarNetwork commented 2 years ago

About the number of transactions, have you considered token transactions besides normal transactions?

For example: https://etherscan.io/address/0x2dbb38ddd7ae50b215bd0359a2793974ad545f81#tokentxns

This address interacts with a relayer to forward token swap transactions. Therefore, there's only 1 tx history. But from etherscan you can see plenty of token txns

billionmonero commented 2 years ago

Well, you will be the whale of Gnosis. This project will become yours. excellent

yeah next time just ask for my private key

MccreeFei commented 2 years ago

It's not fair

wyt159 commented 2 years ago

渣渣项目方，空投规则总是改过来改过去的。妈个巴子。

wyt159 commented 2 years ago

我的只有2个真实钱包，都被刷下来了。垃圾项目方

cyt1234567158 commented 2 years ago

拿2021gas来比较2022年8月的gas，你也是人才

orrvan commented 2 years ago

30.03... hurt my heart

RENXINPAN commented 2 years ago

This proposal doesn't look very smart. Looking for airdrop farmers doesn't mean excluding new users

hisen2fighting commented 2 years ago

If the original address has more than 1 Safe address, it gets -30 points?????Points will be deducted for having two safe deposit boxes? This is obviously a wrong decision. First of all, not to mention whether this is an official function or not, and one of the times that happened to me was that there was a network or web page problem before, resulting in no response. I repeatedly submitted the creation transaction twice, so I have two safe deposit boxes. If these are all points deduction items, I would like to know what is the significance of this screening. Simply designate insiders directly. This is not something that ordinary users like us can enjoy. feel angry. LOL

cyt1234567158 commented 2 years ago

如果行得通，你快照22年干毛线？直接212年的不就行了。脑瘫一样

Jaywongg commented 2 years ago

In order to complete the rabbit hole task, in August I created a wallet. Experienced the project. Now you are hurting real users by doing this.

cyt1234567158 commented 2 years ago

有交易还不是用户？要你爹天天陪着你，你才知道你爹爱你吗？

cyt1234567158 commented 2 years ago

幸好都不像你这种脑瘫，不然区块链早死了。绝对脑子有问题才去这样算，是不是到目前为止除了写代码一事无成呀？

wyt159 commented 2 years ago

你是项目方么？这般骂我。我也没有惹你。

---Original--- From: @.> Date: Sat, Sep 17, 2022 00:13 AM To: @.>; Cc: @.**@.>; Subject: Re: [safe-global/safe-user-allocation-reports] Safe Airdrop Farmersby @KARTOD (Issue #442)

幸好都不像你这种脑瘫，不然区块链早死了。绝对脑子有问题才去这样算，是不是到目前为止除了写代码一事无成呀？

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.Message ID: @.***>

cyt1234567158 commented 2 years ago

你是项目方么？这般骂我。我也没有惹你。 … ---原创---来自：@.> 日期：2022 年 9 月 17 日星期六上午 00:13 至：@.>; 抄送：@.**@.>; Subject: Re: [safe-global/safe-user-allocation-report] Safe Airdrop Farmers by @Kartod (Issue #442 ) 幸好都绝对是你这种脑瘫，这样区块链早死了。算了，是不是除了写代码一事无呀？ — 直接回复此邮件，在 GitHub 上查看，或退订。您收到此消息是因为您发表了评论。消息 ID：@.***>

不是，我是骂提这个规则的人

cyt1234567158 commented 2 years ago

绝对是脑瘫。一开始就是寻求覆盖范围，这家伙上路6500地址。要不直接宣布内部空投或者大户算了，也别要用户了，自己去玩

cyt1234567158 commented 2 years ago

绝对是脑瘫。一开始就是寻求覆盖范围，这帮人上来投6500个地址。要不直接宣布内部空缺或者大户算了，也别用户了，自己去玩

wyt159 commented 2 years ago

我只是个小韭菜，原本2个有空投的，现在也不达标。我不是项目方，也不曾提案过，也不曾为这傻逼项目方做过任何事。不知为啥你骂我。

---Original--- From: @.> Date: Sat, Sep 17, 2022 00:16 AM To: @.>; Cc: @.**@.>; Subject: Re: [safe-global/safe-user-allocation-reports] Safe Airdrop Farmers by @KARTOD (Issue #442)

cyt1234567158 commented 2 years ago

safe卡过，保险箱估计很多人创建了两个剩下的分数看gas 说白了这提案的人自己有大量地址，而且是21年做的这规则，就呵呵了。幸亏这提案的傻逼不是做项目了，不然早黄了改行了

wirelessfuture commented 2 years ago

The link to the CSV is broken, can you please fix it?

0xKARTOD commented 2 years ago

The link to the CSV is broken, can you please fix it?

Yep, sorry. Work in progress

wirelessfuture commented 2 years ago

No problem sir!

freedomwant commented 2 years ago

It's shameful to determine real users by gas fees, because you have to realize that a gas fee can be the cost of living for a family for a day.

freedomwant commented 2 years ago

Are you only responsible for the rich, I don't understand

cyt1234567158 commented 2 years ago

你只对有钱人负责吗，我不懂

有钱人是他爹，肯定得负责

konami0334 commented 2 years ago

Check the witch's right, as judged by the score, then I dare say, this advice, he created address all conform to the standards and drop more than 50 points, he must have been the biggest beneficiaries and when by gas costs to judge whether the hunter drop strange rules, it makes people feel unacceptable, I save the cost of gas is wrong? Is safe for rich people? When poor people save gas fees are airdrop hunters, then we don't have to be! Because you only need to serve a few rich people

0xEuuuler commented 2 years ago

All addresses greater than 50 points were created before 2022, which means that all new users in 2022 are fake, are you serious?

xsalivan commented 2 years ago

why did you remove the wallet address list ?

cyt1234567158 commented 2 years ago

垃圾，地址别删吧。等查女巫。笑死了

0xKARTOD commented 2 years ago

why did you remove the wallet address list ?

Work in progress. Sorry

xsalivan commented 2 years ago

My wallet is for 2022. I hope you don't remove me from the list :))

0xKARTOD commented 2 years ago

My wallet is for 2022. I hope you don't remove me from the list :))

I'm reworking my system. will write about what has changed in "Changes" part

cyt1234567158 commented 2 years ago

几万个地址，被你搞成6500 我可以认为你自己至少拥有5000+地址。说实话没见过这么恶心的。别人需要的是用户，好家伙，你全部给自己。会乞讨呀

safe-global / safe-user-allocation-reports

Safe Airdrop Farmers by @KARTOD #442

Related Safe Addresses

Reasoning

Methodology

Why 1450 txs and 1.18 fees?

Changes:

Safe Address