Untitled BoardAverage Optimism Portfolio Copy
Average Optimism Portfolio (redux) What does the average Optimism user's portfolio look like and how has that changed over time?
What is the optimism network and what is its purpose?
The Optimism Network or Optimism is a second layer solution, which was created to solve the scalability problems of the Ethereum network. Optimism in the word means optimism and Optimizm network was created based on this approach. The Optimism network uses Optimisitic Rollup to increase scalability. In this solution, the Optimism network collects and executes transactions in its network and sends them in a compressed form to the Ethereum network, causing the scalability, speed of transactions and their fees to be significantly reduced.
Methodology
-
The following code was used to extract user activity→
case origin_to_address when '0xa132dab612db5cb9fc9ac426a0cc215a3423f9c9' or '0x9c12939390052919af3155f41bf4160fd3666a6f' then 'Velodrome Router' when '0xc30141b657f4216252dc59af2e7cdb9d8792e1b0' then 'Socket Registry' when '0x74a002d13f5f8af7f9a971f006b9a46c9b31dabd' then 'Rabbithole' when '0x2e42f214467f647fe687fd9a2bf3baddfa737465' then 'Galxe SpaceStation' when '0x1111111254760f7ab3f16433eea9304126dcd199' then '1Inch DEX Router' when '0xdef1abe32c034e558cdd535791643c58a13acc10' then '0x DEX Proxy' when '0x8add31bc901214a37f3bb676cb90ad62b24fd9a5' then 'Pika Protocol Position Manager' when '0x2f05e799c61b600c65238a9df060caba63db8e78' then 'Galxe Stargator NFTs' when '0x00000000000013adddc0919642d45f5d9df09502' then 'Optimism Bridge' when '0x8fd4af47e4e63d1d2d45582c3286b4bd9bb95dfe' then 'Collateral Protocol' else initcap(ifnull(t2.address_name,t3.address_name)) end as Destination_Label
-
Items to be analyzed →
1- User activity 2- CEX projects 3- Grouping of projects

- After other activities with around 28%, swap has been the most active with around 20%.
CEX projects
- The most activity of users was in June 2022, after other activities, Swap played the biggest role
User activity
- In terms of the growth of user activity, we see the growth of buying and selling of NFT in July 2022
In examining the use of CEX →
- In terms of the number of wallets, it belongs to binance with about 71%
- The largest OP volume used by users in CEX also belongs to binance
- The average OP volume of coinbase was the highest
- The most transactions were for binance
- Binance has the most active users
- The highest average volume in November 2022 belonged to coinbase
- In terms of transferred volume, Binance had the largest volume in June 2022
- The most active unique wallets in June 2022 belonged to binance, followed by kucoin
- The most transactions in June 2022 belonged to binance, followed by kucoin
Grouping of projects → defi & dapp & NFT & DEX & CEX & layer2
Checking the categories of projects->
- The most user activity belongs to DEXs with about 82% and then defi with about 11%
- In terms of growth, it seems that the largest growth in the number of users belongs to DEXs
- The highest participation of unique wallets was in August 2022, which belonged to dex and then defi
Findings and conclusion
User activity→
-
After other activities with around 28%, swap has been the most active with around 20%.
-
The most activity of users was in June 2022, after other activities, Swap played the biggest role
-
In terms of the growth of user activity, we see the growth of buying and selling of NFT in July 2022
CEX projects→
- In terms of the number of wallets, it belongs to binance with about 71%
- The largest OP volume used by users in CEX also belongs to binance
- The average OP volume of coinbase was the highest
- The most transactions were for binance
- Binance has the most active users
- The most transactions in June 2022 belonged to binance, followed by kucoin
- The most active unique wallets in June 2022 belonged to binance, followed by kucoin
- In terms of transferred volume, Binance had the largest volume in June 2022
- The highest average volume in November 2022 belonged to coinbase
Grouping of projects →
Included →defi & dapp & NFT & DEX & CEX & layer2
- The most user activity belongs to DEXs with about 82% and then defi with about 11%
- The highest participation of unique wallets was in August 2022, which belonged to dex and then defi
- In terms of growth, it seems that the largest growth in the number of users belongs to DEXs
The dashboard link has been tweeted