Distinct Wallets (Optimism Bridge)
Q1. Many blockchain bridges exist allowing users to move assets between different blockchains. One of the blockchains currently receiving a lot of bridge volume is Optimism. There are several bridges you can use to move tokens to Optimism, but for this bounty we are particularly interested in Optimism’s bridge.
> Optimism is a layer 2 chain, meaning it functions on top of Ethereum mainnet (layer 1). Transactions take place on Optimism, but the data about transactions get posted to mainnet where they are validated. It’s like driving in a less crowded side street while benefiting from the security of a highway. > > credits: coindesk
This dashboard tries to answer these following questions:
- How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days?
- Visualize your findings.
- There are about 29k and 0.5k in number of unique deposit and withdraw respectively.
- Number of unique deposit wallet is 98.4% of total number of unique wallet.
- The deposit information for last 60 days can be extracted from
ethereum.core.fact_transactions
table whereto_address
is0x99c9fc46f92e8a1c0dec1b1747d010903e884be1
- On the other hand, the withdraw information can be queried from
ethereum.core.fact_traces
wherefrom_address
is0x99c9fc46f92e8a1c0dec1b1747d010903e884be1
- This graph show the ETH deposit (blue) and withdraw (orange) amount in last 60 days.
- The peak for both type appear in the same period.
- This plot show the difference between deposit and withdraw amount in ETH.
- Positive means deposit amount > withdraw amount and vice versa.
- The positive peak is on Jun,1 which is the same day with unique deposit wallet, and deposit amount peaks.
- The difference between deposit and withdraw amount in ETH in last 60 days is around 50k ETH.
To crossing process between layer 1 and layer 2 called bridging. The typical bridge functionality allows an ERC20 token to be deposited and locked on L1 in exchange for an equivalent token on L2 in the same quantity.
For more information, go to https://www.optimism.io/
- Daily unique deposit wallet is on the 1e3 scale, and there is a peak (4.8k) on Jun, 1.
- While unique deposit wallet is on 1e3 scale, the unique withdraw wallet is two smaller magnitude than the deposit.
- The highest number of unique withdraw wallet is on Jun, 8 (one week after deposit peak), and 0 withdraw on May, 11.
- The proportion of withdraw has obviously increased since Jun, 8.
- There are about 29k and 0.5k in number of unique deposit and withdraw respectively for last 60 days.
- The difference between deposit and withdraw amount in ETH in last 60 days is around 50k ETH.
- The deposit peak is on Jun,1 in both number of unique deposit wallet, and deposit amount that makes highest total revenue while Jun, 8 is the peak for the withdraw type in the same manner.