A total of 200 million OP tokens were distributed in May 2022 by optimism's Airdrop #1 to over 250,000 early adopters and engaged users. A bicameral governance system provides the foundation for growing digital cities. Token House has become the first component of Optimism governance since then. Over 90 proposals have been voted on. More than 55 million OP tokens have been distributed so far (February 9th, 2023).

The first upgrade to Optimism's protocol will come to a vote in February. Optimism's governance system is strengthened by 293k addresses delegating their voting power - a positive-sum activity. A booming economy is the result of optimism at the same time.

Nearly $15 million of fees have been spent on the network since our first airdrop to more than 1.5 million addresses. Participation in governance and economic activities that contribute to the growth and success of Optimism Collective. To participate in the airdrop, users will need to have interacted with Optimism's Layer 2 solution before the snapshot date. This includes using any of the supported dApps or wallets, such as Uniswap, Curve, or MetaMask. Overall, the second airdrop is a great opportunity for users to earn some free OPM tokens while also contributing to the growth of the Optimism ecosystem.

Airdrop 2

I used the above link for this part, but the designs powered by me!

(1) OP Delegated x Days = Cumulative Sum of OP Delegated per Day (i.e., 20 OP delegated for 100 days: 20 * 100 = 2,000 OP Delegated x Days).

(2) Addresses who received OP from Token House Governance are not eligible for the reward.

(3) The average cost of one L1 transaction on Ethereum was measured during the period between the airdrop #1 snapshot and airdrop #2 snapshot.

(4) Gas Fees USD conversion was made during the transaction. OP rebated conversion was made using the trailing 7-day average market price at the time of the snapshot.

(5) 54,367 OP Delegated x Days is the equivalent of delegating the most minor reward from Airdrop #1 (271.83 OP) for 200 days (Since July 4, 2022).

(6) App transactions were counted as any except token approvals, token transfers, and ETH wrapping/unwrappping transactions. "Distinct months" measured as trailing 30 days from the snapshot date.

Airdrop #2 allocations

Bonus Attributes

Attribute Description

This central part, selects data from two tables in the Optimism database, namely optimism.core.fact_hourly_token_prices and optimism.core.fact_token_transfers, to calculate various metrics related to OP token transfers that occurred on February 9th, 2023.

The first subquery calculates the average price of the OP token on that day. The second subquery (tb1) groups OP transfers by the hour they occurred. It calculates various metrics such as the number of unique users, total amount of OP transferred, and the median OP transferred.

Finally, the main query joins the two subqueries and calculates the average and total value of OP transferred in USD by multiplying with the average OP price calculated earlier. The result is a table with hourly metrics for OP transfers and their estimated USD value.