Open Analytics Bounty: Optimism (August 14)

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    In the last 7 days, the number of transactions has decreased first and then increased, and on the 6th day of August 17th, the highest number of transactions was done during this period. On that day, the number of transactions reached nearly 239K.

    The trend of the number of users has been similar, with the difference that the highest number of users was on the 5th day, i.e. 16th of August. On that day, the number of users was about 49.6K.

    The amount of fee taken was very low compared to the number of transactions. In the highest amount of fee taken, which was on August 17, about 13.7K USD was paid, which was for 239K transactions. This amount is 7.3 ETH.

    The lowest number of transactions in the last week was on August 15, which was around 127.2K. ***The lowest number of users was on the same day, which was 25.8K.

    The lowest amount of fee paid was on August 16, which was about 3.9 ETH, which was equivalent to 7,422 USD.

    On August 18, the largest amount of transfer was done.

    On that day, about 1.01B was transferred, which was in 81.53K transactions and by 8,377 users.

    The highest number of transfers was related to USDC and WETH, and the highest number of USDC and WETH transactions was on August 17. On that day, *42.04K transfers related to USDC and 29.64K transfers were related to WETH.

    DAI, sUSD were also the third and fourth most popular tokens in the last seven days.

    The trend of the number of transfers has been decreasing until the third day in the past week, but it has increased since the fourth day, i.e., from August 16, and by August 18, the number of transfers has reached the highest number in this period.

    In terms of the amount of transfer, it can be said that it was completely upward until August 18, and it reached the highest value during this period on August 18. On that day, 714.2M USD USDC tokens were transferred.

    263.37M USD was related to DAI, which is the highest amount transferred from this token during this period.

    WETH has been bearish from the beginning to the third day of this analysis, but from the fourth day, the trend has been upward.*

    In the last seven days

    , 0.754M transactions have been made on Optimism by 57.7K users and 1.53ETH has been paid as Fee.

    Accordingly, the fee paid for each transaction was about 0.000002 ETH

    Each user has made about 13.7 transactions this week (on average for each user).

    Number of new users in the last seven days is 58.1K

    In the Past week

    , 0.530M transactions have been made on Optimism by 54.4K users and 1.15ETH has been paid as Fee.

    Accordingly, the fee paid for each transaction was about 0.000002 ETH

    Each user has made about 9.73 transactions this week (on average for each user).

    Number of new users in the last seven days is 54K

    Approaches

    • Transactions Volume

    • 1. Daily Transactions

      1. Daily Users
      2. Daily Fee’s ( ETH & USD )
    • Totals

      1. Weekly

      a. Transaction

      b. Users

      c. Fee’s ( ETH & USD )

      d. Fee’s Per Transaction

      e. Transaction Per User

    • Since Now

      a. Transaction

      b. Users c. Fee’s ( ETH & USD )

      d. Fee’s Per Transaction

      e. Transaction Per User

    • Transfers Volume

    1. Number Transfers

    2 .Users

    1. Amount
    • NFT Volume

    1. Number Sell

    2. Buyers

    3. Sellers

    4. Amount Of Sells

    Top Projects Per Sells Amount & Number

    • Success Rate
    • Top Events

    Methodology

    In this dashboard, we are going to analyze the Optimism Chain and see how it has been during this period.

    For this, we use FlipsideCrypto data.

    We use Fact_Transactios to find volume and speed To get the amount of Fee, we also use Ethereum tables and multiply the daily price of ETH by the amount of Fee to show the amount of Fee based on USD.

    We also use the Fact_Transfers table to find the transfers and show it again in USD so that the values ​​can be compared well.

    To find the Stake volume, we use the

    fact_msg_attributes

    table to show all transfers. Only ETH Stakes can be found in the Fact_Stakes table.

    We also use Fact_Nft_Sales table to find volume and NFT projects .

    db_img

    The most famous event in Optimism has always been Transfer, which is the same in most networks now. Transfer includes bridge, transfer, etc., and bridge tokens are the most famous and most used type of transaction in Optimism, because it is a layer 2 solution of Ethereum. During this period, Transfer has had the largest growth and volume.

    In the last 7 days, 359.65K transactions have been made on this event by 56.84K users. This number of users have paid 21.29 ETH as Fee for this number of transactions, which is 40.70K USD.

    The second famous event is Swap. In the last 7 days there have been 246.89K swaps by 25.3K Swappers and around 8.1 ETH have been paid for this number of swaps in the last week, which is equal to 15.54K USD.

    The third most popular event was Approval, which is related to Stake, 1bridge, etc. In the last week, 176.53K transactions have been made on this event by 36.56K users, and for this number of transactions, they have paid about 1.07 ETH as a fee, which is equal to 2,041 USD.

    db_img

    USDC has been the most used token on Optimism in the past seven days in terms of number of transfers, number of users, amount and amount based on USD.

    During this period, 239,113 transactions were made on this token, which was 39.7% of the volume of transfers. 26,206 users have made these transfers, which is 45.6% of the volume of users this week. 1.89B is the amount transferred, which is almost the same amount based on USD, and 67.2% of the amount and 55.2% of the amount was based on USD.

    The second token with the highest number of transactions is WETH, which was 168,679 transactions and had 28% of the volume of transfers.

    **The second most used token was sUSD, which was *7K and had 12.2% of the volume of users this week. ***

    The second largest token was DAI, which was around 484.94M and included 17.2% of the amount transferred this week.

    The second token that had the highest amount of transfer based on USD was WETH, which was about *541.13M and 15.7% of the amount was based on USD.*

    In the last seven days, the speed of Optimism has been decreasing and from the fourth day onwards it has become completely upward, compared to the previous week, the trend has been upward until the fifth day and then downward.

    In the highest speed based on TPH, TPM and TPS in the last seven days, which was on August 17, the number of transactions based on TPS was about 3 transactions in every two seconds, compared to the previous week, which was the fastest on August 10. The number of transactions per second was 1.7, which means more than 3 transactions in every two seconds, which shows that it has decreased compared to the previous week.

    According to TPM, there were 88.7 transactions on August 17, and compared to last week, August 10, which was 105.2 transactions per minute, it shows that it has decreased.

    On August 17, according to TPH, the number of transactions was about 5,327 and on August 10, 6,313 transactions.

    It seems that the number of failed transactions has increased on the last day of this week. In the 6 days before that and last week, the number of wrong transactions increased and decreased compared to the number of transactions, but in the last analysis, it was almost more than other days. In the last seven days, the highest number of transactions was on August 17, when the number of successful transactions was 117.08K and the number of unsuccessful transactions was 10.77K, which is a high success rate compared to most of the network. But on August 19, 13.76K transactions failed out of 107.24K transactions. In the last week, the highest number of transactions was on August 10, where the number of successful transactions was 135.64K and the number of unsuccessful transactions was 15.88K. Last week, the lowest success rate was 89.5%, which was on August 10, and the fail rate was 10.5%. In the last seven days, the lowest success rate was on August 19, which was 88.62%, which shows that it decreased on that day, and the highest success rate in the last seven days was 94.875, and in the last week, it was 92.83%, which shows the trend It has been upward.

    Analyze By

    Siavashj

    Discord Handle

    Siavashj#1512