Try Quests to earn cryptoAverage Optimism Portfolio (redux)
Introduction
Optimism Optimism is designed to be as simple as possible for the featureset it provides. Ideally, Optimism should be composed of the minimum number of moving parts required for a secure, scalable, and flexible L2 system. This simplicity gives Optimism's design a number of significant advantages over other more complex L2 constructions.
On May 31, 2022, Optimism's native token OP was released, and as part of their first airdrop, 214,000,000 OP tokens were sent to 231,000 addresses. Tokenomics-wise, this was a watershed moment in Optimism's history, as the 214 million OP tokens involved represented 5.0% of the total 4.29 billion supply. The majority of the tokens, around 95%, have not yet been released.
Method
The purpose of this dashboard's average portfolio metric is to examine the volume and distribution of various operations, such as trading, farming, staking and unstaking, bridging, NFT, and others, performed by Optimism network users using the OP token across various sectors and platforms.
To achieve this purpose, I’m trying to take a look at on Optimism Users’ portfolio over time and in total. for this I had to check users interaction with different DApps, programs, contracts and etc.
So, I used the optimism.core.fact_event_logs table to track transactions by its action types and optimism.core.dim_labels and flipside_prod_db.crosschain.address_labels tables to extract the destination of that transactions tend to go by label type and project name.
✍🏻 Conclusion
As of Current Dashboard Findings:
- Excluding of first week of Jun, DEXs protocols were more welcome by Optimism users over past 6 months.
- Also, adoption of Defi & NFTs have had smooth growth.
- Excluding of Other activities**, Deligation**, NFTs, Liquidity Providing in Velodrome finance, add and removing liquidity was the most popular actions type over past 6 month, respectively.
- Staking and UnStaking was the most unpopular activities amongst Optimism users.
About:
-
Author: HaM☰d
\
-
Discord: 0xHaM☰d#8391
\
-
Twitter: @arjmandi_hamed
\
-
Email: h_arjmandi2012@yahoo.com
Average Optimism Portfolio
The questions tried to be answered are as below:
- What does the average Optimism user's portfolio look like and how has that changed over time?
- What % of a user's activity (in OP terms) is staked, unstaked, in liquidity pools/farms, in NFTs? How has this trend changed over time?
Hey there 👋!
Firstly, I appreciate you sticking with it until the conclusion.
I'm Hamed, a civil engineering Ph.D.
student interested in data analysis.
I've made many similar dashboards and visualizations since I started at Flipside in January.
Please take a look at my various contact details and let me know what you think.
:telescope: Findings:
As of current sections’ graphs, its obviously after some of transactions that was unknown and has classified as Other transactions, swaps action type had been the most popular amongst Optimism users.
Deligation, NFTs, Liquidity Providing in Velodrome finance, add and removing liquidity was the most popular actions type over past 6 month, respectively.
Staking and UnStaking was the most unpopular activities amongst Optimism users.
The animated chart below right present an over view of growth of transactions count based on actions type over time.
:telescope: Findings:
As of charts above can be observed weekly transactions count peaked at over 500K in the first week of Jun with the most number of transactions for Layer 2 and lowest number for defi protocols.
Weekly transactions count dropped to below 50K in first week of Jul then increased smoothly to over 100K.
Interactions with Dex was the most tend by users over time. as can be seen in the chart below, in terms of distribution of protocol over time, after dropping of Layer 2 (bridge to optimism) in late week of May, the share transactions count of Dex protocols has the most increasing, defi & NFTs have smoothly increased in following.
