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
35 stars 10 forks source link

0x883CcEdaa962e0b39dAAbC88Ded96b20df50de55 and 0xD81152389720712E74FaBb14C12a4A14BdB6869d Air drop Farmer Report #286

Closed MisakaCenter closed 2 years ago

MisakaCenter commented 2 years ago

Related Safe Addresses

Safe address

0x74cb633d1cf1a4a73f621c630a3b1b003450e5a3
0x386f1721fce8df5c50a6c4dfb92fad894c4eb51a
0x9626b7fa440e8c7001b72aac31a9e47150e58d8c
0xc7768a53234a72b53a980c977eb07c8c8f5e76a1
0x62eeefab55104bc0d1ae2ad181e2b67476e5ef47
0x44c21334524ed8ade10d18a2e3b1636c60f0289b
0x67575860eefc18b98c6ff2cd50f7c7684fa85676
0x47ba9203e1d8cd5b25a063329ae88a6755a6e0bc
0x38b074e474afda6967868e2b12b829dc815bf3fd
0xc7768a53234a72b53a980c977eb07c8c8f5e76a1
0x62eeefab55104bc0d1ae2ad181e2b67476e5ef47
0xa4c69fc9d85b6a3ffeeeb58c18ae6777a1960d0c

Created by 0xD81152389720712E74FaBb14C12a4A14BdB6869d

Safe address:

0xc76c8e9bd5a2341dd7cf5ad17ed2ccf647e102b4
0x56c2366b0f7a64d49a4ff7b04c28ddb813edc588
0xfa002b29130bdb1f464473e7c524c1c287f1c969
0xe452420eede6a8075470a5decd40ef3e1f6d2493
0xc1964ebd9814624e0fa4bd20bb314982ba26baf2
0x60b7817343f1f74a03b6c8ed043bd1d5e4ade760
0x999c2dd89039284e95346bd15b56ba1e82139b81
0xffe39a197e1e5e05ca077fe0eac402e25bd3844a
0xee64aa7c1273339fb12fcc603b889666ed0d1621
0xaa41296be944072430708491915e9b7efeb3ed36

Created by 0x883CcEdaa962e0b39dAAbC88Ded96b20df50de55

Reasoning

data is at Sheet 1 and sheet 2 (in the comment)

First, through the sheet, we can find that except for 0x62eeefab55104bc0d1ae2ad181e2b67476e5ef47, the safe address created in same day. All the addresses have no valid transactions or any digital asset in history.

Second, mention the first and last transactions only exist on the created time day, and the time between the transactions is no more than 1 day(most less than 2 hours).

Third, the initial ETH of 0x883CcEdaa962e0b39dAAbC88Ded96b20df50de55(call It de55) came from 0xD81152389720712E74FaBb14C12a4A14BdB6869d(call It 69d). (https://etherscan.io/txs?a=0x883ccedaa962e0b39daabc88ded96b20df50de55&p=2)

82.35% of de55’s ETH came from 69d, and 20.62% of ETH transferred to 69d. They both have many transactions with the FTX exchange.

Above all, we can draw the conclusion that 69d and de55 are controlled by the same person.

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 = lower('0xa4c69fc9d85b6a3ffeeeb58c18ae6777a1960d0c')

and chain analysis.

Safe Address

0x7FCD3D9A08816F6Dd19faa7942eFae2F746ed1d2

MisakaCenter commented 2 years ago

sheet1:

address | entity | entity_cat | tx_count | current_balance | tx_first_datetime | tx_last_datetime | Creator | safe address create time -- | -- | -- | -- | -- | -- | -- | -- | -- 0x74cb633d1cf1a4a73f621c630a3b1b003450e5a3 |   |   | 2 | 0 | 2022-07-30 18:19:55 | 2022-07-30 20:18:41 | 0xD81152389720712E74FaBb14C12a4A14BdB6869d | Jul-30-2022 10:19:55 AM +UTC 0x386f1721fce8df5c50a6c4dfb92fad894c4eb51a |   |   | 2 | 0 | 2022-07-30 15:51:49 | 2022-07-30 19:22:29 | 0xD81152389720712E74FaBb14C12a4A14BdB6869d | Jul-30-2022 07:51:49 AM +UTC 0x9626b7fa440e8c7001b72aac31a9e47150e58d8c |   |   | 2 | 0 | 2022-07-30 15:42:07 | 2022-07-30 19:12:23 | 0xD81152389720712E74FaBb14C12a4A14BdB6869d | Jul-30-2022 07:42:07 AM +UTC 0xc7768a53234a72b53a980c977eb07c8c8f5e76a1 |   |   | 3 | 0 | 2022-07-30 15:51:49 | 2022-08-01 19:37:38 | 0xD81152389720712E74FaBb14C12a4A14BdB6869d | Jul-30-2022 07:51:49 AM +UTC 0xc76c8e9bd5a2341dd7cf5ad17ed2ccf647e102b4 |   |   | 2 | 0 | 2022-07-30 17:05:43 | 2022-07-30 18:56:19 | 0x883CcEdaa962e0b39dAAbC88Ded96b20df50de55 | Jul-30-2022 09:05:43 AM +UTC 0x56c2366b0f7a64d49a4ff7b04c28ddb813edc588 |   |   | 2 | 0 | 2022-07-30 16:19:05 | 2022-07-30 19:18:57 | 0x883CcEdaa962e0b39dAAbC88Ded96b20df50de55 | Jul-30-2022 08:19:05 AM +UTC 0x62eeefab55104bc0d1ae2ad181e2b67476e5ef47 |   |   | 6 | 0 | 2022-05-08 23:26:00 | 2022-08-01 19:11:15 | 0xD81152389720712E74FaBb14C12a4A14BdB6869d | May-08-2022 03:26:00 PM +UTC 0x44c21334524ed8ade10d18a2e3b1636c60f0289b |   |   | 2 | 0 | 2022-07-30 18:51:17 | 2022-07-30 18:58:54 | 0xD81152389720712E74FaBb14C12a4A14BdB6869d | Jul-30-2022 10:51:17 AM +UTC 0x67575860eefc18b98c6ff2cd50f7c7684fa85676 |   |   | 2 | 0 | 2022-07-30 18:15:54 | 2022-07-30 20:24:05 | 0xD81152389720712E74FaBb14C12a4A14BdB6869d | Jul-30-2022 10:15:54 AM +UTC 0xfa002b29130bdb1f464473e7c524c1c287f1c969 |   |   | 2 | 0 | 2022-07-30 16:41:23 | 2022-07-30 19:06:58 | 0x883CcEdaa962e0b39dAAbC88Ded96b20df50de55 | Jul-30-2022 08:41:23 AM +UTC 0x47ba9203e1d8cd5b25a063329ae88a6755a6e0bc |   |   | 2 | 0 | 2022-07-30 15:34:04 | 2022-07-30 19:09:25 | 0xD81152389720712E74FaBb14C12a4A14BdB6869d | Jul-30-2022 07:34:04 AM +UTC 0x38b074e474afda6967868e2b12b829dc815bf3fd |   |   | 2 | 0 | 2022-07-30 18:43:33 | 2022-07-30 18:57:23 | 0xD81152389720712E74FaBb14C12a4A14BdB6869d | Jul-30-2022 10:43:33 AM +UTC 0xe452420eede6a8075470a5decd40ef3e1f6d2493 |   |   | 2 | 0 | 2022-07-30 16:36:21 | 2022-07-30 19:13:46 | 0x883CcEdaa962e0b39dAAbC88Ded96b20df50de55 | Jul-30-2022 08:36:21 AM +UTC

sheet2:

address | entity | entity_cat | tx_count | current_balance | tx_first_datetime | tx_last_datetime | creator | create time -- | -- | -- | -- | -- | -- | -- | -- | -- 0xc1964ebd9814624e0fa4bd20bb314982ba26baf2 |   |   | 2 | 0 | 2022-07-30 17:55:39 | 2022-07-30 20:05:35 | 0x883CcEdaa962e0b39dAAbC88Ded96b20df50de55 | Jul-30-2022 09:55:39 AM +UTC 0x60b7817343f1f74a03b6c8ed043bd1d5e4ade760 |   |   | 2 | 0 | 2022-07-30 18:24:20 | 2022-07-30 20:14:45 | 0x883CcEdaa962e0b39dAAbC88Ded96b20df50de55 | Jul-30-2022 10:24:20 AM +UTC 0x999c2dd89039284e95346bd15b56ba1e82139b81 |   |   | 3 | 0 | 2022-07-30 15:14:18 | 2022-07-30 19:05:02 | 0x883CcEdaa962e0b39dAAbC88Ded96b20df50de55 | Jul-30-2022 07:14:42 AM +UTC 0xffe39a197e1e5e05ca077fe0eac402e25bd3844a |   |   | 2 | 0 | 2022-07-30 17:29:05 | 2022-07-30 19:46:55 | 0x883CcEdaa962e0b39dAAbC88Ded96b20df50de55 | Jul-30-2022 09:29:05 AM +UTC 0xc7768a53234a72b53a980c977eb07c8c8f5e76a1 |   |   | 3 | 0 | 2022-07-30 15:51:49 | 2022-08-01 19:37:38 | 0xD81152389720712E74FaBb14C12a4A14BdB6869d | Jul-30-2022 07:51:49 AM +UTC) 0x62eeefab55104bc0d1ae2ad181e2b67476e5ef47 |   |   | 6 | 0 | 2022-05-08 23:26:00 | 2022-08-01 19:11:15 | 0xD81152389720712E74FaBb14C12a4A14BdB6869d | May-08-2022 03:26:00 PM +UTC 0xee64aa7c1273339fb12fcc603b889666ed0d1621 |   |   | 2 | 0 | 2022-07-30 17:33:21 | 2022-07-30 20:00:43 | 0x883CcEdaa962e0b39dAAbC88Ded96b20df50de55 | Jul-30-2022 09:33:21 AM +UTC) 0xa4c69fc9d85b6a3ffeeeb58c18ae6777a1960d0c |   |   | 2 | 0 | 2022-07-30 18:41:39 | 2022-07-30 20:09:02 | 0xD81152389720712E74FaBb14C12a4A14BdB6869d | Jul-30-2022 10:41:39 AM +UTC 0xaa41296be944072430708491915e9b7efeb3ed36 |   |   | 2 | 0 | 2022-07-30 18:11:31 | 2022-07-30 20:16:26 | 0x883CcEdaa962e0b39dAAbC88Ded96b20df50de55 | Jul-30-2022 10:11:31 AM +UTC

data download (same as above): result_data.zip

MisakaCenter commented 2 years ago

already hunted by others