Optimism Airdrop 1 - Background → Source - (Image link)

The Optimism Foundation’s Airdrop #1 rewards those who have been instrumental as early adopters and active users of projects in the Optimism ecosystem. To celebrate our Ethereum roots, The Optimism Foundation also want to welcome active L1 participants who can help scale Ethereum’s innovations, culture, and values to Layer 2. In total, 248,699 addresses are eligible to claim OP in this initial airdrop.

Optimism airdrop has six sets of criteria. Two for Optimism users that target early adopters and active project users, and four for L1 Ethereum, which target active contribution, positive-sum behaviors, and active participation. Each set is distinct, meaning that an address can be eligible for multiple and allocated a sum of tokens accordingly. A snapshot of addresses was taken on 03-25-2022 0:00 UTC. The allocations and criteria are shown in the picture below

The amount of OP tokens that an address receives is cumulative, meaning that the sum of OP tokens allocated for each matching criteria set is the amount that an address is eligible to claim (overlap bonuses are not cumulative).

✍️ Description of Work

Earlier this summer, Optimism offered an airdrop to users. In this dashboard, we want to examine Optimism Airdrop 1. For this, we check the following:

• How many users claimed optimism airdrop?
  • Total User Claimed, Daily Claim by User
• How much of total airdrop was claimed?
  • Total Amount Claimed, Daily Claim by Amount (OP)
• How many wallets are still holding tokens from airdrop?
  • Total OP Transferred, Daily OP Transfer, Holders
• How much of users delegated their OPs? 
  • Total User and Amount (OP) Delegated, Daily Delegate by User and Amount (OP)

🧠 Methodology

To deal with this dashboard, we use optimism.core schema and fact_event_logs, fact_token_transfers, fact_delegations and fact_hourly_token_prices tables.

• Optimism Airdrop contract address is 0xfedfaf1a10335448b7fa0268f56d2b44dbd357de== → Link
• The total amount of OPs allocated in Optimism: Airdrop is 214,748,364.80 OPs distributed among 248,699 eligible users. → Source

🔍 Base Query:

First, we obtain all the transactions related to claiming using the fact_event_logs table and the contract_address field, provided that:

select 
  		block_timestamp,
		event_inputs:recipient as address,
  		event_inputs:amount as op_amount_claimed
  		from optimism.core.fact_event_logs
  		where origin_to_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
		and contract_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
		and event_name = 'Claimed'
		and tx_status = 'SUCCESS'
		and origin_function_signature = '0x2e7ba6ef'

• The query above gives us the list of all transactions of users who have claimed the OP related to Optimism: Airdrop along with the claim amount of each user.

🔍 Claim user and total OP claimed:

• Using the result of the above query, we count the total number of users (count address) and calculate the sum of the amounts (sum(op_amount_claimed/1e18)) that they have claimed.

🔍 Holders:

• Find transfer transactions: In order to calculate that users who have claimed their OP still hold it or have transferred it (transfer, swap, etc.), we use the fact_token_transfers table to find the transactions related to the transfer of the OP token (where transfer.contract_address = '0x4200000000000000000000000000000000000042') from wallets that have claimed their OP and these transactions occurred after the claim date (transfer date >= claim date):

  
  Currently, we have the transactions related to the OP token transfer of the users who have claimed and these transactions were after the claim date.

In the next step, we calculate the total number of transfers for each user (sum(transfer_amount) over (partition by origin_from_address) as total_transfer_amount) and divide the users into three categories:

• Users who have transferred all their claimed OP tokens → total_transfer_amount >= claim_amount
• Users who have transferred some of their claimed OP tokens → total_transfer_amount < claim_amount
• Users who do not have any transactions related to the transfer of their OP after the claim date.

Finally, we get the list of holders and some of the OPs that have held

🔍 Delegate:

To get the users who have delegated, we use fact_delegations and find the delegations transactions related to the users who have claimed, provided that:

where delegations.delegator = claim.address and delegations.block_timestamp >= claim.block_timestamp 
and delegations.delegation_type = 'First Time Delegator''First Time Delegator' and status = 'SUCCESS'

All results obtained and calculations are from 2022-09-27 and earlier

1 → OP Token daily price from ==2022-05-31== onwards

2 → Optimism Airdrop Overview

3 → How many users claimed optimism airdrop and How much of total airdrop was claimed?

✅ Observations

• As you can see, out of 248,699 eligible users, 149,025 users, i.e. 59.92%, have claimed their OP tokens by 2022-09-27.

• Of the total 214748364.80 allocated OP, 158648793.01 OP has been claimed, which means about 73.88% of all allocated tokens.

  The percentage of claimed tokens is higher than the percentage of users, and this means that the users who have been allocated more tokens have claimed their tokens.

• You can see that in the first days that OP Airdrop can be claimed, the largest number of users and the largest number of tokens have been claimed

• 45 of the users 32431.8 OP have been assigned to them, all of which have been claimed.

4 → How many wallets are still holding tokens from airdrop?

We divide this section into three subsections:

• OP token transfer (transfer, swap, etc.)
• OP token transfer (transfer, swap, etc.) on a daily basis
• Holders
  • Review of users who have not had any transfer
  • Review of users who have not transferred + users who have transferred but not transferred all the claimed OPs

✅ Observations

• As you can see, about 132k, i.e. 88.6% of users have transferred their tokens (transfer, swap, etc.)
• About 138.9M OP transferred, that is about 87.5%
• Of all the users who have transferred, 101.5K of them have transferred all the tokens they have claimed, that is, about 68.1% of all the users who have claimed have transferred all their tokens.
• Out of all the users who transferred, 30.6K of them did not transfer all the tokens they claimed and transferred only a part of it.
• It means that 20.51% of all users who have made a claim have transferred, but they have not transferred all their tokens.

✅ Observations

• You can see that the users who have transferred their claimed token have mostly done the transfer in the first few days of claiming.
• You can see that the users who had the largest number of claim tokens (32431.8 OP) about 36 users transferred all 32431.8 OP
• Users who had the highest number of tokens allocated for claim made more transfer

4-1 → OP token transfer (transfer, swap, etc.)

4-2 → OP token transfer (transfer, swap, etc.) on a daily basis

4-3 → Holders (users who have not had any transfer)

✅ Observations

• You can see that about 17k users, that is 11.41%, have not transferred any tokens and have holded all the claimed tokens in their wallets.
• Users who have not made any transfer have about 15.4M OP, which is about 9.71% of the total number of claimed tokens.
• 7 of the users who are assigned 32431.8 OP have not made any transfer and are among the top holders.

4-4 → Holders (Review of users who have not transferred + users who have transferred but not transferred all the claimed OPs)

✅ Observations

• In total, about 47.6K users still hold claimed OP in their wallets, which means about 31.9% of all users who have claimed
  • 🔝 As mentioned in section 4-1, 101.5k users have transferred all their OP claims, that is 68.1%.
• The total amount of OP that is currently in the wallets of users who have claimed is 19.78M OP, which means that about 12.47% of the total number of claimed OPs is holded.
  • 🔝 As mentioned in section 4-1, 138.9M OP has been transferred, which is about 87.53%.

Currently, there are a total of 47.6K holders who hold 19.78M OP.

5 → How much of users delegated their OPs?

✅ Observations

• About 92.7k of the claimed OP users have delegated themselves, that is, about 62.2% of the users have delegated.
• About 99M OP (==62.4%==) has been delegated
• As you can see, most of the users who delegated delegated on the same day they claimed and immediately after claiming.

✔️ Final Conclusion

After checking OP Airdrop, we got the following results:

> * Out of 248,699 eligible users, 149,025 users, i.e. 59.92%, have claimed their OP tokens > * Of the total 214748364.80 allocated OP, 158648793.01 OP has been claimed, which means about 73.88% of all allocated tokens. > * 132k (88.6%) of users have transferred their tokens (transfer, swap, etc.) → about 138.9M OP transferred, that is about 87.5% > * Of all the users who have transferred, 101.5K of them have transferred all the tokens they have claimed, that is, about 68.1% of all the users who have claimed have transferred all their tokens. > * Out of all the users who transferred, 30.6K of them did not transfer all the tokens they claimed and transferred only a part of it. > * 17k (11.41%) users, have not transferred any tokens and have holded all the claimed tokens in their wallets. > * Users who have not made any transfer have about 15.4M OP, which is about 9.71% of the total number of claimed tokens > * 47.6K users still hold claimed OP in their wallets > * The total amount of OP that is currently in the wallets of users who have claimed is 19.78M OP > * 92.7k of the claimed OP users have delegated themselves, that is, about 62.2% of the users have delegated → about 99M OP (==62.4%==) has been delegated