Untitled Board

    What does the average Optimism user's portfolio look like and how has that changed over time?

    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...

    ❓Average Optimism Portfolio

    What does the average Optimism user's portfolio look like and how has that changed over time?

    \n

    What % of a user's activity (in OP terms) is staked, unstaked, in liquidity pools/farms, in NFTs? How has this trend changed over time?

    \n

    ✍🏻 Methodology

    • In this dashboard, i use 3 table:
      • optimism.core.fact_event_logsused for checking transaction activity in optimism chain .
      • optimism.core.dim_labels , flipside_prod_db.crosschain.address_labelsused for action name and project type of transactions in optimism chain .

    📃 Purposes of dashboard

    In this dashboard, optimism chain is analyzed :

    • weekly / monthly count of action at each type of activity.
    • weekly / monthly count of action at each type of project.
    • count of action at each type of activity.
    • count of action at each type of project.
    • weekly / monthly volume (OP) of action at each type of activity.
    • weekly / monthly volume (OP) of action at each type of project.
    • volume (OP) of action at each type of activity.
    • volume (OP) of action at each type of project.
    • weekly / monthly count of OP transfers.
    • weekly / monthly count of OP users.
    • weekly / monthly volume of OP transfers.
    • User categorize by volume (OP) of transfers.
    • User categorize by count of transfers.
    • Top 10 wallet on optimism Chain in volume (OP) of transfers .
    • Top 10 wallet on optimism Chain in count of transfers .

    📝 Introduction

    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. If it works on Ethereum, it works on Optimism at a fraction of the cost.

    What does it mean to scale up Layer 1 networks? Optimism does this by rolling up transaction data from the main chain, bundling it into single batches, and then settling them. This data is sent back to Ethereum’s mainnet to be validated as another added data block.

    That last part is critical because it means Layer 2 solutions don’t erode a blockchain’s key feature — security through decentralization. 

    After all, Ethereum’s 5,000 nodes make a great redundancy layer against network shutdowns or attacks. The same cannot be said of centralized networks, where only a couple of servers need to go down for the entire network to collapse.

    When Optimism bundles hundreds of transactions into single batches, the fees required to settle them drastically fall compared to if they had been executed on Ethereum itself. Optimism bundles transaction data with Optimistic Rollups. This cryptographic technique uses smart contracts to serve as bridges between L1 and L2, using a process dubbed “fraud proof”.

    db_img

    💠 part 1.weekly / monthly count of action at each type of activity / project.

    💠 part 2.count of action at each type of activity / project.

    💠 part 3.weekly / monthly volume (OP) of action at each type of activity / project.

    💠 part 4.volume (OP) of action at each type of activity / project.

    💠 part 5.weekly / monthly count of OP transfers.

    💠 part 6.weekly / monthly count of OP users.

    💠 part 7.weekly / monthly volume of OP transfers.

    💠 part 8.User categorize by volume (OP) / count of transfers.

    💠 part 9.Top 10 wallet on optimism Chain in volume (OP) / count of transfers .

    👀 Observation ( part(1) , part(2) , part(3) , part(4))

    • The count of action in type of activity was in ==Sep==, ==Aug== and ==Jun== 2022 was more than other months.
    • The maximum count of action in type of activity was in one week is related to ==first week== of Jun 2022. (==696.69 K== in Jun and ==496.32 K== at first week of Jun).
    • Maximum count of action in type of activity was for other activity ==926.89 K (32.2%)== after that bridging activity are in second place ==796.37 K (26.1%)==.
    • The count of action in type of project was in ==Sep==, ==Aug== and ==Jun== 2022 was more than other months.
    • The maximum count of action in type of project was in one week is related to ==first week== of Jun 2022. (==696.69 K== in Jun and ==496.32 K== at first week of Jun).
    • Maximum count of action in type of project was for Layer 2 ==1.27 M (44.8%)== after that Dex are in second place ==520.64 K (18.2%)==.
    • The volume (OP) of action in type of activity was in ==Sep==, ==Aug== and ==Jun== 2022 was more than other months.
    • The maximum volume (OP) of action in type of activity was in one week is related to ==first week== of Jun 2022. (==1.51 B== in Jun and ==829.8 M== at first week of Jun).
    • Maximum volume (OP) of action in type of activity was for other activity ==2.08 B (51.2%)== after that bridging activity are in second place ==1.82 B (44.2%)==.
    • The volume (OP) of action in type of project was in ==Sep==, ==Aug== and ==Jun== 2022 was more than other months.
    • The maximum volume (OP) of action in type of project was in one week is related to ==first week== of Jun 2022. (==1.51 B== in Jun and ==829.8 M== at first week of Jun).
    • Maximum volume (OP) of action in type of project was for Dex ==1.58 B (39%)== after that Layer 2 are in second place ==1.52 1 (37.3%)==.

    👀 Observation ( part(5) , part(6) , part(7))

    • The count of transfer was in ==Sep==, ==Aug== and ==Jun== 2022 was more than other months.
    • The maximum count of transfer was in one week is related to ==first week== of Jun 2022. (==613.18 K== in Jun and ==386.18 K== at first week of Jun).
    • The count of users was in ==Sep==, ==Aug== and ==Jun== 2022 was more than other months.
    • The maximum count of users was in one week is related to ==first week== of Jun 2022. (==221.2 K== in Jun and ==183.3 K== at first week of Jun).
    • The volume (OP) of transfer was in ==Jul==, ==Aug== and ==Jun== 2022 was more than other months (except airdrop activity on Apr).
    • The maximum volume (OP) of transfer was in one week is related to ==third week== of Aug 2022. (==3.09 B== in Aug and ==2.3 B== at third week of Aug) (except airdrop activity on Apr).

    👀 Observation ( part(8))

    • Most of users ==transfer 2 - 5 time. 152.72 K== (==55.4%==)
    • Most of users ==transfer 1001 - 2500 OP. 87.28 K== (==31.7%==)

    👀 Observation ( part(9))

    🏆 0xab1ef74d2c461e95f4b658ca1f94ac519ad80ba2

    which have the most volume of transfers. (==8.58 M OP==)

    🏆 0x04234893acac5096f4a1ad8fd952cc98b8c8ff46

    which have the most count of transfers. (==287252 transfers==)

    📃Contact Data

    Discord : Abolfazl#2441

    Email : Abolfazl.yeganeh77@gmail.com

    **Twitter : **

    thanks for Flipsidecrypto team