Try Quests to earn cryptoUser Behavior (redux)
sample query of data
In this analysis, I have advanced my analysis with the help of various tables from both Ethereum and Optimism networks The tables that have helped me the most are:
sushi.ez_swaps
core.fact_event_logs
core.fact_transactions
I should also mention that for a better comparison of the data, all of them are limited to August 1st onwards In addition to this limitation, it does not create an obstacle for comparison, but it also makes the differences better visible
Basic definitions
Optimism is a layer 2 chain, meaning it functions on top of Ethereum mainnet (layer 1). Transactions take place on Optimism, but the data about transactions get posted to mainnet where they are validated. It’s like driving in a less crowded side street while benefiting from the security of a highway.
Optimism is the second-largest Ethereum layer 2 with a total of $313 million locked into its smart contracts, as of this writing, according to Defi Llama. Arbitrum comes first with $1.32 billion.
Synthetix, a derivatives liquidity protocol, is the largest protocol on Optimism, with a total value locked (TVL) of $125 million. Uniswap, a decentralized exchange (DEX), is the second most popular protocol on the chain. As of this writing, there are 35 protocols on Optimism with at least $1,000 locked into their smart contracts.
Layer 2 (L2) is a collective term to describe a specific set of Ethereum scaling solutions. A layer 2 is a separate blockchain that extends Ethereum and inherits the security guarantees of Ethereum.
The above table shows that
-
First, the Ethereum chart is more stable than the Optimism chart, that is, the range of changes in the Ethereum chart (variance) is less than that of the Optimism chart.
\
-
In the last few days, the swap has decreased in the Ethereum network, but it has increased in the Optimism network In the middle of October, we see a decrease in both tables
\
-
But regarding the maximum chart, each of them shows different points. In the Ethereum table, around the middle of September and the optimism of October 20th are shown as the maximum.
\
-
Also, some obvious points can be mentioned, including the overall lower number of swaps and optimized users compared to Ethereum.
In the pie charts, the most important user activities are divided into two groups
First Division: Based on the number of transactions of that type
The second category: Based on the number of users who have created that type of transaction
The graphs drawn for the two networks of Ethereum and Optimism show that transfer is one of the most important types of transactions that take place in any network.
The failure percentage of each network is compared in these two graphs and it can be seen that the optimized network has more failure
The diagrams contained many obvious points like that The Ethereum network has more users and more transactions Regarding transactions, it can be said that Ethereum has about 11 times more transactions than Optimism and also About 7 times more active users
Important
You may wonder why the average number of users is less than the daily amount of active users (we know that the average data cannot be less than all the data), this being less in the two graphs above and below is because of the way the average is calculated.
In calculating the average number of distinct users of the total calculated, but in the daily charts, the number of distinct users each day
Twitter link to this dashboard