Optimistic Bears (EXTREMELY REPORT)
Analyze Optimism during the month of July as markets were get turbulent, showing whatever metrics you care to unearth. You can choose any topic you’d like: How did the network perform? What about market performance? Were there significant inflows or outflows on bridges? Were there any notable patterns in user behavior? 150, 225, USD, Ethereum.
A. Optimism Unique Addresses and Their Transactions
- Unique Addresses (UAs): Someone who is counted only once in the total data on optimism transactions table.
- Unique Addresses in July (UAJs): Someone who is counted only once per time-part (for example, every hour, every day, every week) and may have done a transaction before 2022-07-01 (Default is July).
- New Unique Addresses (NUAs): Someone who is counted only once per time-part and has not made any transactions in Optimism before 2022-07-01 (Their transactions have been started only in July).
C. Optimism Speed
We have measured blockchain performance in terms of transactions per hour. However, by changing and reducing the time period (start and end date) as well as changing the time part to minute, the performance of the Optimism blockchain can also be measured in minutes.
Note: Pay attention to the warning provided at the beginning of the report.
Refer to another report from us for more information about Speed Criteria in a blockchain.
- Selected parameters apply to all visualizations. Log in required.
- A Given Time Period is defined from the start date to the end date. Default is 2022-07-01 to 2022-07-31 (July).
- Time-part is a set from ‘minute’, ‘hour’, ‘day’ and ‘week’ items.
- The results presented in the text of the report may change due to updating queries. Please refer to the data presented in the Figures.
Setting the time part to minutes may cause timeout in queries. So, decrease the given time period.
D. Optimism Fees
We extracted the data required and specific to the Optimism network from the table optimism.core.fact_transactions
The data extracted from this table includes the date, number of transactions, number of unique addresses and the sum of fees.
The fee is paid in each transaction based on the native token of the same network (here is ETH). Therefore, it was necessary to convert the value of the fee to USD. For this purpose, to convert the fee to USD, we benefited from the ethereum.core.fact_hourly_token_prices
table to extract the WETH price in USD. We also used the optimism.core.fact_hourly_token_prices
table to get the OP token price.
E. Optimism Inflow & Outflow
Native-Bridge:
- Deposit Contract:
'0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
- Withdraw Contract:
'0x25ace71c97b33cc4729cf772ae268934f7ab5fa1' (Optimism: Proxy OVM L1 Cross Domain Messenger)
- We extracted token transfers other than ETH from the
ethereum.core.ez_token_transfers
and ETH coin transfers from theethereum.core.ez_eth_transfers
tables.
A. Observations
-
The total number of unique addresses that have had at least one transaction (from the beginning until now) is 348k. 5.97M is the total number of transactions in (from the beginning until now) and Figure 1 is also the total # of transactions and UAs in the specific date (start and end date have been set). The peak of # of transactions and unique addresses in each time period is known at the end of July.
-
The total # of addresses that did not have a transaction before the start date is 12.68k. The transactions of these users were about 687k. The trend of changes in the number of these types of wallets (NUAs) as well as their transactions are drawn in Figure 2. Late July had a peak.
-
11.5% of the total Optimism network transactions were registered by NUAs in the overtime period.
-
21% of the total Optimism network transactions were registered by NUAs in the given time period.
-
33.8% is NAUs to total unique addresses ratio in Optimism and 36.4% are NAUs to total unique addresses ratio that counted in given time period (Default is July) and once per time part.
-
Each address in Optimism has done an average of 17.16 transactions and each NUAJ has done 5.41 transactions on average.
B. Observations
-
Figure 3 shows the changing trend of NUAs with the price of OP token. The changing trend of these two lines is almost the same.
-
Figure 4 shows a comparison of # of Txs by NUAs with OP toke price. We see the trend of these two lines is similar and they are uptrend.
-
Figures 5 and 6 compare the previous two metrics with the price of Ethereum and Figures 7 and 8 with the price of Bitcoin. The similarity of the change trend of these four graphs is different from graphs 3 and 4. However, they are somewhat similar.
-
We see an increasing trend in all six charts and they have a peak at the end of July.
.
One of the best and most practical criteria for calculating the correlation between two parameters is to calculate the correlation coefficient between two dependent and independent variables. I recommend that you refer to our report to learn more about the concept of correlation coefficient. It is necessary to explain that the correlation coefficient will be between 1 and -1, and the closer it is to 1, it will indicate a direct relationship between the two variables, and if it is close to -1, it will mean that the two variables have an inverse relationship and in Finally, if it is close to zero, it will indicate that there is no definite relationship between two variables.
- The first three numbers, 0.866, 0.728, and 0.563, show that the number of transactions recorded in the Optimism network has a high correlation with the price of the OP token in the first place, then ETH, and finally BTC. It can be concluded that the conditions governing the transactions of this network are a function of the conditions that occur in the crypto market.
- The coefficient of 0.479 shows the correlation between the number of NUAs and the price of the OP token, and it can be concluded that the increase in the number of transactions of new unique addresses in the network is more influenced by the price of the OP token than the price of coins such as Ethereum and Bitcoin.
C. Observations
- Figures 9 and 10 show the trend of total, successful and failed transactions. Figure 9 depicts these three metrics in a normalized form and shows that a low percentage of transactions in this network have failed, although at the end of July, with the increase in the total number of transactions, the percentage of failed transactions also increased slightly. This point can be well seen in diagram 10.
- You can see the general statistics related to the types of transactions in about four numbers.
Note: These results are limited to the specified time period.
- Figure 11 shows a similar harmony between the total number of transactions and the number of successful transactions in the Optimism network. In a way, we have already proved this coordination in the report about the speed in the Flow network (Figure 13 and the Conclusion section in the Flow Speed report). Look at it from this point of view that the Optimism network is launched as layer 2 on top of the Ethereum network and definitely inherits many of the properties of the base network. We can see that the Optimism network has been able to maintain the stability of executing successful transactions with a high percentage in line with the base network.
- Figure 12 shows that as the number of total transactions increases, the percentage of successful transactions also decreases, but you can see that during the default time period (July), this drop was not more than 14% and more than 86% of all transactions. have appeared successful. Figure 13 is the same as Chart 12, with the difference that we have set its market size property to None so that the distribution of data can be seen well in the chart environment. You can see that the distribution of data points (successful transactions) id in the lower number of total transaction executions.
- Figure 14 shows the cumulative average of successful transactions in each part time. In the default time part, we see that the average number of successful transactions has increased in late July.
- Figure 15 is a confirmation of Figure 14. In this graph, we have depicted both the average number of successful transactions per time part along with the total number of transactions. Both coordination lines have moved together.
- Figure 16 is basically the same as Figure 15. You can see that with the increase in the total number of transactions, the cumulative average of the number of successful transactions has also formed larger circles, but their color tends towards dark blue and shows that the number of failed transactions is also increasing (confirmation on Figure 12).
D. Observations
- The total fee paid in the specified time period is equal to $13.78k, and $0.00422 per transaction has been charged (Compared to fi on the Ethereum network, it is very small).
- During the default time period, each address has paid an average of $0.0367 for their own transactions to the network.
- Obviously, with the increase in the number of transactions, the amount of fee paid to the network will also increase (Figure 17).
- When we compare the number of unique addresses in the specified time period with the amount of fee obtained (Figure 18), we see that there is a relative harmony between the two, and with the increase in user activity (increase in the addresses creating transactions), the amount of fee also increases. We see the peak at the end of the default time period (July).
- In Figures 19 and 20, we tried to compare the fee obtained in the network with the price of ETH and OP tokens. It can be seen that the increase of fee has been more coordinated with the price of OP token. Along with the increase in the price of ETH and OP, the amount of the fee has also increased.
- It was appropriate to calculate and evaluate the correlation of the value of fee obtained in the network with the above investigated metrics. As we have seen in graph 17, the highest value of the correlation coefficient can be seen between the two variables fee and the number of transactions (with a number of 0.889). In the second order of correlation coefficients, the price of OPs token is with a value of 0.797.
- Figure 21 shows that with the increase in the price of ETH, the income of the network (due to Fee) has increased due to the participation of more UAs (changing the color spectrum of small dark circles from dark blue to fiery color) and increasing in their number of transactions.
- Figure 22 is the same as Figure 21, with the difference that the price of OPs is mentioned instead of the ETH price. The result obtained in this graph is the same as the result of the previous paragraph.
- What can be deduced from Figure 23 is similar to chart 17, but with more details. In this graph, we can see that with the increase in the number of transactions (bigger circles) at the end of July (the default time period), which is caused by the increase in the number of UAs, the amount of obtained fee in the network also increases.
- Figure 24 also confirms that the increase in the number of transactions caused by the increase in the number of UAs has increased the amount of obtained fee in the network.
- Figure 25 shows that the trend of inflow to Optimism network has increased at the end of the default time period, and the most token that has entered this network is related to USDC (Figure 26). The trend of asset outflow (withdrawal) from the network during the default time period is also the same as Inflow (Figure 27), with the difference that the largest amount of outflow is related to the ETH token (Figure 28).
-
Figure 29 shows the amount of deposit and withdrawal with the total number of transactions related to these two actions. Despite the fact that the number of deposit transactions was more than withdrawals (Figure 31), but Figure 30 shows that the volume of withdrawals during the default time period was much higher than the volume of deposits.
-
In Figure 32, you can see the process of changing the amount of liquidity input and output to the Optimism network animatedly.
.
- In July, the total number of deposit transactions was 3,790 (89.5% of the total) and the number of withdrawal transactions was 445 (10.51% of total).
- Deposits in July were $141.9M (1.374% of the total), while withdrawals were $10.18B (98.6% of the total).