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).

Optimism

Optimism is a fast, stable, and scalable L2 blockchain built by Ethereum developers, for Ethereum developers. Built as a minimal extension to existing Ethereum software, Optimism's EVM-equivalent architecture scales your Ethereum apps without surprises.

Website, Twitter, Discord

✍️ 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 &gt;= claim.block_timestamp 
and delegations.delegation_type = 'First Time Delegator''First Time Delegator' and status = 'SUCCESS'

📅 All results obtained and calculations are from 2022-11-15 and earlier

1️⃣ → OP Token Daily Price from ==2022-05-31== Onwards

2️⃣ → Optimism Airdrop - Overview

3️⃣ → Optimism Airdrop - Total Airdrop Claim

4️⃣ → Optimism Airdrop - Daily airdrop claim

✅ Observations

As you can see, out of 248,699 eligible users, 150.7K users, i.e. 60.6%, have claimed their OP tokens by 2022-11-16.
Of the total 214748364.80 allocated OP, 159753706.66 OP has been claimed, which means about 74.4% 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.
Approximately 77K (51.1%) users have claimed between 500 and 1000 OPs and 40K (26.8%) users have claimed less than 500 OPs.

5️⃣ → 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

5️⃣🔵1️⃣ → OP token transfer (transfer, swap, etc.)

✅ Observations

As you can see, about 134.7k, i.e. 89.4% of users have transferred their tokens (transfer, swap, etc.)
About 141.7M OP transferred, that is about 88.7%
Of all the users who have transferred, 105.2K of them have transferred all the tokens they have claimed, that is, about 69.8% of all the users who have claimed have transferred all their tokens.
Out of all the users who transferred, 29.5K of them did not transfer all the tokens they claimed and transferred only a part of it.
It means that 19.6% of all users who have made a claim have transferred, but they have not transferred all their tokens.

5️⃣🔵2️⃣ → OP token transfer (transfer, swap, etc.) on a daily basis

✅ 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

5️⃣🔵3️⃣ → Holders (users who have not had any transfer)

✅ Observations

You can see that about 15.94k users, that is 10.58%, have not transferred any tokens and have holded all the claimed tokens in their wallets.
Users who have not made any transfer have about 14.02M OP, which is about 8.78% of the total number of claimed tokens.
5 of the users who are assigned 32431.8 OP have not made any transfer and are among the top holders.

5️⃣🔵4️⃣ → Holders (Review of users who have not transferred + users who have transferred but not transferred all the claimed OPs)

✅ Observations

In total, about 45.4K users still hold claimed OP in their wallets, which means about 30.2% of all users who have claimed
- 🔝 As mentioned in section 5️⃣🔵1️⃣, 105.2k users have transferred all their OP claims, that is 69.8%. → 69.8% + 30.2% = 100% of all users who have claimed :slightly_smiling_face:
The total amount of OP that is currently in the wallets of users who have claimed is 18.06M OP, which means that about 11.3% of the total number of claimed OPs is holded.
- 🔝 As mentioned in section 5️⃣🔵1️⃣, 141.7M OP has been transferred, which is about 88.7%. → 88.7% + 11.3% = 100% of the total OP claimed :slightly_smiling_face:

Currently, there are a total of 45.4K holders who hold 18.06M OP.

6️⃣ → How much of users delegated their OPs?

✅ Observations

About 91.5k of the claimed OP users have delegated themselves, that is, about 60.7% of the users have delegated.
About 97.3M OP (==60.9%==) has been delegated
As you can see, most of the users who 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. 60.6%, have claimed their OP tokens > * Of the total 214748364.80 allocated OP, 159753706.66 OP has been claimed, which means about 74.4% of all allocated tokens. > * 134.7K ==(89.4%) of users have transferred their tokens (transfer, swap, etc.) → about 141.7M OP transferred, that is about 88.7% > * Of all the users who have transferred, 105.2K of them have transferred all the tokens they have claimed, that is, about 69.8% of all the users who have claimed have transferred all their tokens. > * Out of all the users who transferred, 29.5K (19.5%) of them did not transfer all the tokens they claimed and transferred only a part of it. > * 15.94k (10.58%) 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 14.02M OP, which is about 8.78% of the total number of claimed tokens > * 45.4K (30.2%) 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 18.06M OP (11.3%) > * 91.5k of the claimed OP users have delegated themselves, that is, about 60.7% of the users have delegated → about 97.3M OP (60.9%==) has been delegated

🔗 Links

Tweet link for this dashboard: OP Airdrop (Redux)
Discord: Yousefi_1994#7190
Twitter: Yousefi_1994
Related link: My previous dashboard about OP Airdrop

flipside

flipside

Optimism - OP Airdrop (Redux)

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

Optimism

✍️ Description of Work

🧠 Methodology

🔍 Base Query:

🔍 Claim user and total OP claimed:

🔍 Holders:

🔍 Delegate:

📅 All results obtained and calculations are from 2022-11-15 and earlier

1️⃣ → OP Token Daily Price from ==2022-05-31== Onwards

2️⃣ → Optimism Airdrop - Overview

3️⃣ → Optimism Airdrop - Total Airdrop Claim

4️⃣ → Optimism Airdrop - Daily airdrop claim

✅ Observations

5️⃣ → How many wallets are still holding tokens from airdrop?

5️⃣🔵1️⃣ → OP token transfer (transfer, swap, etc.)

✅ Observations

5️⃣🔵2️⃣ → OP token transfer (transfer, swap, etc.) on a daily basis

✅ Observations

5️⃣🔵3️⃣ → Holders (users who have not had any transfer)

✅ Observations

5️⃣🔵4️⃣ → Holders (Review of users who have not transferred + users who have transferred but not transferred all the claimed OPs)

✅ Observations

6️⃣ → How much of users delegated their OPs?

✅ Observations

✔️ Final Conclusion

🔗 Links