Untitled BoardAverage Optimism Portfolio
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
-
Optimism.core.fact_event_logs table was used to find the top addresses
-
Optimism.core.dim_labels table was used to find the labels
-
The following code was used to define the labels→
case project_name when 'hop protocol' then 'Bridge' when 'hop protocol' then 'Bridge' when 'stargate finance' then 'Bridge' when 'across protocol' then 'Bridge' when 'synapse' then 'Bridge' when 'layer2dao' then 'DAO' when 'lyra' then 'DeFi' when 'uniswap' then 'DeFi' when 'synthetix' then 'DeFi' when 'slingshot' then 'DeFi' when 'velodrome finance' then 'DeFi' when 'perpetual protocol' then 'DeFi' when 'pika protocol' then 'DeFi' when 'aave' then 'DeFi' when 'clipper' then 'DeFi' when 'rubicon' then 'DeFi' when 'curve fi' then 'DeFi' when 'optimism' then 'Governance' when 'quix' then 'NFT' when 'project galaxy' then 'NFT' when 'optimistic explorer - get started nft' then 'NFT' end as detect
-
The flipside_prod_db.crosschain.address_labels table was used to find the address names And from the code below →
,case origin_to_address when '0xa132dab612db5cb9fc9ac426a0cc215a3423f9c9' then 'Velodrome Router' when '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 t2.address_name end as Destination_Label
Weekly destinations
- Transactions on a weekly basis
- The largest transaction was on May 30
- Weekly active users
- The highest participation of users was on May 30
- growth in the number of transactions on a weekly basis
- growth in the number of users on a weekly basis
Review activities
:triangular_flag_on_post: The activity of OP users is analyzed weekly and summarized below →
- The highest transaction for other activities is about 63%
- Swaps have the second rank in terms of the number of users with about 33 percent
- The largest volume is for other activities with about 66%
- The largest transaction, the largest volume, and the largest number of users was on May 30
- The highest average was on April 25
Conclusions and findings
:triangular_flag_on_post: In this dashboard, we reviewed the Average Optimism Portfolio and based on this →
Destinations→
-
The most transactions for DeFi about 74%
-
The second highest transaction rank for Bridge about 16%
-
Most users for Bridge about 31%
-
The second rank of the most users for Governance about 24%
Review activities→
-
The highest transaction for other activities is about 63%
-
Swaps have the second rank in terms of the number of users with about 33 percent
-
The largest volume is for other activities with about 66%
-
The largest transaction, the largest volume, and the largest number of users was on May 30
-
The highest average was on April 25
The dashboard link has been tweeted
written by
Discord ID: Sal☰h#1747
email : saleh.mz@gmail.com
**twitter : **


Destinations
:triangular_flag_on_post: Below are the summary statistics of the OP's intentions →
- The number of transactions by destination
- The number of users by destination
- The most transactions for DeFi about 74%
- The second highest transaction rank for Bridge about 16%
- Most users for Bridge about 31%
- The second rank of the most users for Governance about 24%