Acknowledgment and supplementary Information

• I would like to show my sincere gratitude to the author of the following dashboard that helped me very much indeed to do my own analysis: *
• Author: NSA2000
• Twitter of the Author: @NSA2000C
• Discord of the Author: NSA2000#5651
• Data from FlipsideCrypto
• Link of this dashboard’s tweet:

Summary

• This dashboard aims to investigate the behavior of the Optimism users’ portfolio and the variation of their trends in order to find out the type of users’ activity such as staking, in liquidity pools or farms or in NFTs.
• The daily variation of the transactions number according to the protocol type shows a rather constant trend since 30 May 2022.
• As far as the normal and cumulative daily variation of the transactions number according to the protocol type is concerned, Dex, Layer2, and Opertor have the upper hand.
• As far as the distribution of the transactions number according to the protocol type is concerned, the following metrics can be observed for top 3 ones:
  • Dex: 1.54M, 57.5%
  • Layer2: 723.87K, 27%
  • Opertor: 150.48K, 5.61%
• The daily variation of the transactions number according to different protocols shows a rather fluctuating trend.
• As far as the normal and cumulative daily variation of the transactions number according to different protocols is concerned, Optimism, Velodrome Finance, and Uniswap have the upper hand.
• As far as the distribution of the transactions number according to different protocols is concerned, the following metrics can be observed for top 3 ones:
  • Optimism: 868.47K, 32.4%
  • Velodrome Finance: 801.68K, 29.9%
  • Uniswap: 505.49K, 18.8%
• The daily variation of the transactions number according to action type shows a rather fluctuating trend.
• As far as the normal and cumulative daily variation of the transactions number according to action type is concerned, General Contract, Token Contract, and Swap Contract have the upper hand.
• As far as the distribution of the transactions number according to action type is concerned, the following metrics can be observed for the top 3 ones:
  • General Contract: 1.252M, 49.7%
  • Token Contract: 763.7K, 28.5%
  • Swap Contract: 430.1K, 16%
• The daily variation of the users’ number according to protocol type shows a rather constant trend since 13 Jun 2022.
• As far as the daily variation of the users’ number according to protocol type is concerned, Layer2, Dex, and Operator have the upper hand.
• As far as the distribution of the users’ number according to protocol type is concerned, the following metrics can be observed for the top 3 ones:
  • Layer2: 413.28K, 37.9%
  • Dex: 397.57K, 36.5%
  • Operator: 150.29K, 13.8%
• The daily variation of the users’ number according to different protocols shows a rather constant trend since 13 Jun 2022.
• As far as the daily variation of the users’ number according to different protocols is concerned, Optimism, Uniswap, and Velodrome Finance have the upper hand.
• As far as the distribution of the users’ number according to different protocols is concerned, the following metrics can be observed for the top 3 ones:
  • Optimism: 558.23K, 51.2%
  • Uniswap: 195.18K, 17.9%
  • Velodrome Finance: 62.41K, 5.73%
• The daily variation of the users’ number according to action type shows a rather constant trend since 13 Jun 2022.
• As far as the daily variation of the users’ number according to action type is concerned, Token Contract, General Contract, and Swap Contract have the upper hand.
• As far as the distribution of the users’ number according to action type is concerned, the following metrics can be observed for the top 3 ones:
  • Token Contract: 446.29K, 41%
  • General Contract: 290.01K, 26.6%
  • Swap Contract: 167.79, 15.4%

These charts show the daily variation and the distribution of the users’ numbers according to the action type.

• The daily variation of the users’ number according to action type shows a rather constant trend since 13 Jun 2022.
• As far as the daily variation of the users’ number according to action type is concerned, Token Contract, General Contract, and Swap Contract have the upper hand.
• As far as the distribution of the users’ number according to action type is concerned, the following metrics can be observed for the top 3 ones:
  • Token Contract: 446.29K, 41%
  • General Contract: 290.01K, 26.6%
  • Swap Contract: 167.79, 15.4%

These charts show the daily variation and the distribution of the users’ numbers according to the different protocols.

• The daily variation of the users’ number according to different protocols shows a rather constant trend since 13 Jun 2022.
• As far as the daily variation of the users’ number according to different protocols is concerned, Optimism, Uniswap, and Velodrome Finance have the upper hand.
• As far as the distribution of the users’ number according to different protocols is concerned, the following metrics can be observed for the top 3 ones:
  • Optimism: 558.23K, 51.2%
  • Uniswap: 195.18K, 17.9%
  • Velodrome Finance: 62.41K, 5.73%

These charts show the daily variation and the distribution of the users’ number according to the protocol type.

• The daily variation of the users’ number according to protocol type shows a rather constant trend since 13 Jun 2022.
• As far as the daily variation of the users’ number according to protocol type is concerned, Layer2, Dex, and Operator have the upper hand.
• As far as the distribution of the users’ number according to protocol type is concerned, the following metrics can be observed for the top 3 ones:
  • Layer2: 413.28K, 37.9%
  • Dex: 397.57K, 36.5%
  • Operator: 150.29K, 13.8%

These charts show the normal and cumulative daily variation as well as the distribution of the transactions number according to action type.

• The daily variation of the transactions number according to action type shows a rather fluctuating trend.
• As far as the normal and cumulative daily variation of the transactions number according to action type is concerned, General Contract, Token Contract, and Swap Contract have the upper hand.
• As far as the distribution of the transactions number according to action type is concerned, the following metrics can be observed for the top 3 ones:
  • General Contract: 1.252M, 49.7%
  • Token Contract: 763.7K, 28.5%
  • Swap Contract: 430.1K, 16%

These charts show the normal and cumulative daily variation as well as the distribution of the transactions number according to different protocols.

• The daily variation of the transactions number according to different protocols shows a rather fluctuating trend.
• As far as the normal and cumulative daily variation of the transactions number according to different protocols is concerned, Optimism, Velodrome Finance, and Uniswap have the upper hand.
• As far as the distribution of the transactions number according to different protocols is concerned, the following metrics can be observed for top 3 ones:
  • Optimism: 868.47K, 32.4%
  • Velodrome Finance: 801.68K, 29.9%
  • Uniswap: 505.49K, 18.8%

These charts show the normal and cumulative daily variation as well as the distribution of the transactions number according to the protocol type.

• The daily variation of the transactions number according to the protocol type shows a rather constant trend since 30 May 2022.
• As far as the normal and cumulative daily variation of the transactions number according to the protocol type is concerned, Dex, Layer2, and Opertor have the upper hand.
• As far as the distribution of the transactions number according to the protocol type is concerned, the following metrics can be observed for top 3 ones:
  • Dex: 1.54M, 57.5%
  • Layer2: 723.87K, 27%
  • Opertor: 150.48K, 5.61%

Introduction

Ethereum (ETH), the largest smart-contracts blockchain, has a scalability problem. As more and more users join Ethereum, the network becomes more expensive and slower to use. In response to Ethereum’s scalability problem, a bunch of Ethereum alternatives – popularly known as "Ethereum killers" – have emerged. So-called Ethereum killers, such as Avalanche or Fantom, are separate blockchains, or layer 1s like Ethereum. Meanwhile, the Ethereum ecosystem has come up with a scaling solution: layer 2s, chains that work on top of Ethereum mainnet.

Optimism is one of the layer 2 scaling solutions. It’s powered by a technology called Optimistic rollups, which bundle large amounts of transaction data into digestible batches. Optimism is much cheaper to use than Ethereum, and it’s increasingly becoming popular along with other layer 2s, such as Arbitrum. Optimism is governed by its eponymous token, or OP for short. A portion of the OP supply was airdropped to early Optimism users in late May 2022 in a turbulent launch. Developers behind Optimism said it would continue to airdrop more tokens. []

Methodology

The data in this dashboard is obtained from the following tables:

• optimism.core.fact_event_logs
• optimism.core.dim_labels l ON ADDRESS = ORIGIN_TO_ADDRESS

Aim of this analysis:

This dashboard aims to investigate the behavior of the Optimism users’ portfolio and the variation of their trends in order to find out the type of users’ activity such as staking, in liquidity pools or farms or in NFTs.

Results and Discussion