Bridge Transactions (Across)

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

    Introduction

    Across is a protocol for optimistic cross-chain bridges that allows users to complete transactions on different chains at a timescale that is very near to instantaneous. This is made possible by the fact that Across is a cross-chain bridge. This objective is attainable with the implementation of an optimistic oracle, bonded relayers, and single-sided liquidity pools, as these are the mechanisms by which this goal can be accomplished.

    Method

    Analysis

    I used ethereum.core.fact_event_logs and ethereum.core.ez_token_transfers tables to Analyze bridge transactions via the Across bridge over the last two weeks, and also to find What assets are users bridging from Ethereum, and to what chains?

    For this purpose I decoded DATA column by

    regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data, ethereum.public.udf_hex_to_int(segmented_data[0])::number/1e18 as amount, ethereum.public.udf_hex_to_int(segmented_data[2]) as Chain_Id

    • So let's look the findings as below.

    Observation

    Overview

    Discord:0xHaM☰d#8391

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    Paragraph

    Paragraph

    Paragraph

    db_img