What was our Method to find the airdrop Farmers :
First let tell you some information about who was eligible to get the airdrop:
- safe addresses that created before Aug 18, 2022
- Minimum number of txs made: 1
- Minimum value stored in Safes: No minimum value
second thing we must say here is that for collecting the safe addresses that created before Aug 18, 20022 and the creator address of them I used
ethereum.core.fact_event_logs table, which the origin to address of the transactions was in :
0x12302fe9c02ff50939baaaaf415fc226c078613c | Safe: Proxy Factory 1.0.0 |
---|---|
0x76e2cfc1f5fa8f6a5b3fc4c8f4788f0116861f9b | Safe: Proxy Factory 1.1.1 |
0x88cd603a5dc47857d02865bbc7941b588c533263 | Safe: Proxy Factory 0.1.0 |
0xa6b71e26c5e0845f74c812102ca7114b6a896ab2 | Safe: Proxy Factory 1.3.0 |
0x0fb4340432e56c014fa96286de17222822a9281b | Safe: Proxy Factory |
0x50e55af101c777ba7a1d560a774a82ef002ced9f | Safe: Proxy Factory 1.1.0 |
then with help of safe addresses that I collected and with ethereum.core.ez_token_transfers and ethereum.core.ez_eth_transfers tables I found the safe_addresses that stored any USDC, DAI, SAI, USDT, WETH or ETH which they are eligible for airdrop which these addresses by default have more than 1 transaction
Now let’s explain what was our method to finding the airdrop farmers among these addresses:
-
first we had to make sure that creator addresses does not belong to some platform or something, so we only included safe addresses which their creator address were not in Ethereum.core.dim_labels table
\
-
with help of ethereum.core.fact_transactions table we calculated the transactions number of each creator, and we only included the safe_addresses that their creator address have 2 or less than 2 transactions, you need some ETH to pay the TX_fee and these creators must take ETH from someone, am I right? We will find out
\
-
some addresses sent some ETH to above creators to cover TX fee and creating safe wallet, I collected the addresses that sent ETH to 2 or more addresses from creator addresses that are in number 2 section which are 300 addresses, also that I only included the addresses that are not in Ethereum.core.dim_labels table other thing we have here is that I just included creator addresses that the difference of time between creating safe address and receiving ETH is less than 72 hours
\
-
in the end I collected the safe addresses that belonging to addresses that sent ETH and addresses that received ETH, these addresses in my opinion have the highest to be airdrop farmers which their number is 43
Ethereum tables especially token transfers table does not have all time activity for safe_addresses or the creator address of them
Picture source : Link

