Question:

Q1. Analyze bridge transactions via the Across bridge over the last two weeks. What assets are users bridging from Ethereum, and to what chains?

Across transaction event data is undecoded in the Ethereum core tables. Users can use these functions to parse and decode the data: regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data ethereum.public.udf_hex_to_int()

Hint: A user begins a bridge transaction by calling the deposit function on the SpokePool contract from the origin chain. Ethereum SpokePool contract : 0x4D9079Bb4165aeb4084c526a32695dCfd2F77381

Approach:

Across is an optimistic cross-chain bridge protocol that allows users to execute transactions between chains nearly instantaneously. This is accomplished by using an optimistic oracle, bonded relayers, and single-sided liquidity pools.

As mentioned in the question, a user begin to bridge transaction by calling the deposit function on the SpokePool. The aim of this bounty is to find the application of Across bridge in Ethereum by estimating the most popular assets and destinations.

The methodology of this essay contains:

• Daily analysis of users

    from ethereum.core.FACT_EVENT_LOGS
    CONTRACT_ADDRESS = lower('0x4D9079Bb4165aeb4084c526a32695dCfd2F77381')-- SpokePool
    ORIGIN_FUNCTION_SIGNATURE='0x49228978'
    TX_STATUS='SUCCESS'
  

• Bridge assets

    from ethereum.core.ez_token_transfers by joining ethereum.core.FACT_EVENT_LOGS with tx_hash
  

• Estimation of destinations

    select
    regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data,
    ethereum.public.udf_hex_to_int(segmented_data[2]) as id
    from ethereum.core.FACT_EVENT_LOGS
  

• Time period

    BLOCK_TIMESTAMP>=CURRENT_DATE-14 -- stands for the past two weeks
  

Results:

The most used assets bridges via Across shown in these graphs.

The first graph reveals that the USDC is the most used token with over 800k USD for the past two weeks.

The highest volume of transferred assets occurred on June 14th with more than 300k USD. The popularity of USDC is obvious from the area graph.

The daily number of unique users that bridges with Across from Ethereum to other chains demonstrated in this graph. According to this graph, the number of users kept their consistent trend until June 21th.

The maximum number of transactions related to Across occurred on June 22 with 2010 transactions by 2010 unique users.

The chains that bridged assets from Ethereum via Across displays in this pie graph.

According to this graph, about 90% of bridges have destination o Arbitrum. The next ranks belongs to Optimism and Polygon respectively. But the application of Arbitrum is far more then other ones.