search

safe-global / safe-user-allocation-reports

The proposed list of SAFE user allocations has been published on the Safe forum.
Creative Commons Zero v1.0 Universal
34 stars 10 forks source link

answer/ Airdrop farmer report #117 #511

Open 0x9J opened 2 years ago

0x9J commented 2 years ago

THIS IS A REPORT REFERS TO #117

Replying to

image

-

image

This is Airdrop Farmer's exec.

image

This is normal user's exec. And we do see the difference. Also, this "Fees to transactions ratio: 0" method is based on what Safe official twitter RETWEET.

Related Safe Addresses

0x624014b2c9e148dd8c1b5e00385cf86e77edae0a 0x939af5ad7fd35c63a86c14e70d89ea541383d26d 0xa95f95cac47035ec89911e6ff67c5876b88dcd80 0x6813d52ad95cfbf2a97cc2a260829184bd7bb15f 0x0cbd42f76427514073ce71b51895620ab8276fd7 0xd9525821e86c69249ea0964ced080ad055ea94a5 0x8a5c79f15ad766584cc383de97af758ade54113f 0x7ed52e469e703ca2efd78319e98c27f1cc9b7692 0x9d75962c692355c9377295aa2590383f5852e702 0xf26a06760d4f8dce81a86dd75767cb274fe2f051

Reasoning

1.All these 10 Safe address were created by same address :0x9c7c3f9b59d42874c803964ee16c82ce67097f7a 2.Only have transaction history in 2 specific dates: 2021-08-24/2021-08-27 3.Numbers of transactions: minimum 3 maximum 6.

  1. Fees to transactions ratio: 0. All transactions are "pay gas and transfer nothing" which not any of Safe normal user would do.
image

As can see in the screenshot. The transaction was made by only paying gas but no ether/erc20 token being transfered. And this applies to all the transactions from those 10 Safe addresses.

Methodology

with target as ( select from url('https://raw.githubusercontent.com/safe-global/safe-user-allocation-reports/main/safe_user_allocations_reworked.csv', CSVWithNames) ), transactions as ( select t1. from ethereum.transactions t1 join target t2 on t1.to_address = t2.safe_address )

select distinct to_address from transactions where from_address = '0x9c7c3f9b59d42874c803964ee16c82ce67097f7a'

Safe Address

0xfADD9521EbA86Df0D89B92C5D105f445E3CA9479