Terra Old bounty: A3

    Layers of a Blockchain

    Layer 1 networks refer to blockchains while Layer 2 (L2) protocol refers to third party integration that can be used in conjunction with a Layer 1 blockchain.

    L2 solutions pass part of the transaction load to an adjacent system that handles most of the network processing and, upon completion, reports back to the main blockchain. In this way, the main blockchain is “decongested”.

    Overview

    This dashboard analyzes how is user behavior different on Optimism (L2) compared to Ethereum’s mainnet (L1). More precisely, for multiple metrics there is a comparison based on the daily tendency and the total amount comprised within the selected timeframe (by default it shows the last 6 months). To dive deep into the subject, this dashboard is divided into four sections:

    1. Transaction Level Data
    2. Swap Activity (Sushiswap)
    3. Miners and Blo

    Key Findings

    • Metric 1:
      • A
    • Metric 2:
      • B
    • Metric 3:
      • C
    • Metric 4:
      • D

    A

    Add Text Here

    B

    Add Text Here

    C

    Add Text Here

    Methodology

    NOT UPDATED

    The data used in this analysis was collected by combining the information on the fact_transactions, dim_labels and fact_hourly_token_prices tables of the Optimism database.

    • The first table was used to query the transactions information on Optimism.

      \

    • To filter the transactions, these were joined using the second table for the CEXs available (Binance, Coinbase and Kucoin).

      \

    • The third table provided the data regarding the price of ETH in USD. This was used to calculate the transaction fees paid per transaction in USD, as they are shown in ETH by default.

    Conclusions

    • Metric 1:
      • A
    • Metric 2:
      • B
    • Metric 3:
      • C
    • Metric 4:
      • D

    Introduction

    Analysis