$OP Airdrop (Redux)

Introduction
What is 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.
What Is a Crypto Airdrop?
Airdrops involve crypto projects sending free tokens en masse to their communities in a bid to encourage adoption.
What is an Optimism Airdrop?
The Optimism Foundation's Airdrop #1 rewards those who have been instrumental as early adopters and active users of projects in the Optimism ecosystem.
Method
I used the optimism.core.fact_event_logs
table and obtained the volume of airdrop transactions claimed by users with the following information:
- Airdrop Contract: 0xfedfaf1a10335448b7fa0268f56d2b44dbd357de
- The event name: Claimed
I used the optimism.core.fact_token_transfers
table and got the number of wallets that did or did not hold the airdrop.
- From May 31, airdrop claims have started for users. In the first week, a large volume of airdrops were claimed by users. June 1 was the highest volume of claims with about 69M $Op.After that, the volume and number of users who made claims has decreased.
Wallets that still hold their airdrops are 73k and wallets that haven't held their airdrops are 76k wallets.
Those who have transferred their airdrops are more than holders.
Conclusion
-
Total claimed volume: 158.6M $op
-
Total number of claims: 148.8 wallets
-
Total holders airdrops: 73k wallets
-
Total non holders airdrops: 76k wallets
-
From May 31, airdrop claims have started for users. In the first week, a large volume of airdrops were claimed by users. June 1 was the highest volume of claims with about 69M $Op.After that, the volume and number of users who made claims has decreased.
-
Those who have transferred their airdrops are more than holders.