• A bear market develops when a market price decreases considerably over a sustained period. It is a period in which the value of shares falls by 20 percent or more from recent highs owing to widespread pessimism and poor market sentiment. Bear markets often coincide with big declines in a larger market or index. Since Bitcoin and Ethereum are the leaders of the crypto space, and after them, the whole market looks to those cryptocurrencies to set the tone for the markets. 

  Cryptocurrencies or commodities may also be classified as being in a bear market if they see a 20% decline over a lengthy period—typically two months or more. Bear markets may also occur in connection with more significant economic downturns, such as recessions, and can be contrasted with bull markets which occur when the markets are heading higher.

• Optimism is a fast, stable, and scalable L2 blockchain built by Ethereum developers, for Ethereum developers. Built as a minimal extension to existing Ethereum software, Optimism's EVM-equivalent architecture scales your Ethereum apps without surprises.

OP and Ethereum price

where hour::date >= CURRENT_DATE - 180
and symbol = 'WETH'
and symbol = 'OP'

from ethereum.core.fact_hourly_token_prices

Failed transactions

from arbitrum.core.fact_transactions

where status = 'FAIL' 

Success transactions

from arbitrum.core.fact_transactions
where status = 'SUCCESS' 

Inflow

from ethereum.core.fact_event_logs
and origin_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'

Outflow

from optimism.core.fact_event_logs
and origin_to_address = '0xc30141b657f4216252dc59af2e7cdb9d8792e1b0'

CEX

from flipside_prod_db.crosschain.address_labels
from optimism.core.ez_eth_transfers

where label_type = 'cex' and
label_subtype = 'hot_wallet'
and blockchain in ('optimism' )

OP and Ethereum price

Failed and success transactions

Number of transactions

Daily Overview

New and old users

\

• The highest number of new users on Ethereum was on July 26th. On this day, 955.7k users had their first transactions.

• The highest number of new users on Arbitrum was on October 26th with 76k.

• The highest number of new users on Optimism was on June 1st with 105.6k.

• The highest number of transactions that made by new users was on November 9th with 1.12 million on Ethereum. 756.7k on Arbitrum and 277k on Optimism

Inflow and outflow

Number of user

Number of transaction

• The highest number of users that had inflow transactions was on June 1st. On this day. 4853 users had inflow transactions.

• The highest number of users who had outflow transactions was on June 27th. On this day the total number of users was 13.5k.

• In total, the number of users who had outflow transactions was more than who had inflow transactions.

  \

• The highest number of outflow transactions was on June 27th. On this day, the total number of transactions was 14k.
• The highest number of inflow transactions was on June 1st. On this day, the total number of inflow transactions was June 1st.
• The total number of outflow transactions is more than the inflow transactions.

Number of swaps

• The highest USD volume of all swaps was on July 29th. On this day, the total USD volume of swaps was 115.6 million.
• The average USD volume of swaps was the most on May 31st with 2960.

Transfer from CEX and to CEX (ETH token)

Number of transactions

• The highest number of transactions in total was on July 15th. On this day, of all the transactions, 4309 transactions were from Optimism and 196 transactions were to Optimism.
• The highest number of transactions that transferred to Optimism was on November 3rd. On this day, the number of transactions was 1600.
• The highest number of transactions that transferred from Optimism was on July 15th. On this day, the number of transactions was 4309.
• The total number of transactions to Optimism is more than the number of transactions from Optimism.

Number of users

USD volume

• The highest number of users who had transactions was on July 15th. On this day, of all the users, 4302 users had transactions from Optimism and 182 users had transactions to Optimism.
• The highest number of users who had transactions to Optimism was on November 3rd with 1500.
• The highest number of users who had transactions from Optimism was on July 15th with 4302.
• The total number of users who had transactions to Optimism was more than those who had from transactions.

• The highest USD volume of all transactions was on September 19th.
• On this day, of all the transactions the USD volume of transaction that were to Optimism was 48.2 million.
• The USD volume of transactions that were from Optimism was 46.6 million.
• The total USD volume of all the transactions from Optimism was more than to Optimism.

USD volume

• The highest price of Ethereum was on May 13th, on this day the price of Ethereum was 2073.

• The highest price of OP was on August 4th. On this day, the price of OP was 1.98.

  \

• The highest number of failed transactions was on November 8th. On this day, of all the failed transactions,45.4k transactions on Arbitrum, 40.4k transactions on Ethereum, and 30.7k transactions on Optimism had failed.

• The highest number of successful transactions was on November 8th. On this day, of all the successful transactions, almost 1 million transactions on Ethereum, 732k transactions on Arbitrum, and 300k transitions on Optimism were successful.

• The highest number of transactions per hour was on November 8th. On this day, of all the transactions, 48.4k transactions happened on Ethereum, 30.5k transactions on Arbitrum and 12.5k transactions happened on Optimism.

• The highest number of transactions per minute was on November 8th. On this day, the number of transactions per minute on Ethereum was 758, on Arbitrum was 508.3 and on Optimism was 208.

• The highest number of swaps was on July 29th. On this day, the total number swaps on this day was 90k.
• The highest number of users who had swaps was on June 2nd. On this day, the total number of users who had swaps was 9125.

• The highest number of transactions per second was on November 8th. On this day, the number of transactions per minute on Ethereum was 12.6, on Arbitrum was 8.4 and on Optimism was 3.4.

• The highest number of transactions on Ethereum was on Fridays with 1.14 million.
• The highest number of transactions on Optimism was on Wednesdays with 136.6k.
• The highest number of transactions on Arbiturm was on Wednesdays with 90.4k.