​

Transfers

The bridges.transfers aggregates transaction-level bridge transfers across multiple blockchains indexed by Allium.

​

Blockchain Coverage

The bridges.transfers includes bridge transfers indexed from the following blockchains.

​

Source and Destination Blockchain Coverage

A bridge event connects a source blockchain (origin of the asset) to a destination blockchain (target for the bridged asset).

The total number of source and destination blockchains covered can be greater than the number of blockchains covered.

An example would be indexing the canonical bridge event of L2 Worldchain will allow us to cover bridge events between Ethereum<>Worldchain without indexing Worldchain events.

​

Bridge Types

We broadly classify bridges into the following types:

• Applications bridges: bridges that have their underlying liquidity/mechanism to transfer assets across to typically more than one blockchain.
• Canonical bridges are bridges from Ethereum to a Rollup and serve as the “official” bridge for the roll-up/blockchain and service 1 destination blockchain.
  • For Canonical Bridges protocols, OP (Optimism Stack) bridges and Arbitrum Bridges will include blockchains under the same ecosystem:
    • Optimism Stack Bridges: includes Optimism, Base, Worldchain, Mode, Mint, Redstone, RSS3, Mantle, Manta, Blast, Fraxtal, Zora bridge and more
    • Arbitrum Orbit Bridges: Arbitrum, Arbitrum Nova, Alienx

​

Protocol Coverage

The bridge transfer schema supports both protocols across canonical and application bridge types.

​

Directional Coverage

Bridge transfer events include both inbound and outbound transfers. We include inbound and outbound bridge transfers for canonical bridges only.

• Canonical Bridges on Etheruem Mainnet
  • Bridging direction
    • Inbound: bridging from the Ethereum to the destination chain
    • Outbound: briding back to Ethereum. E.g. for Base Bridge, this will be from Base -> Ethereum
• Application and Asset Bridges on EVM-Blockchains (including Ethereum)
  • Bridging direction
    • Outbound only: bridging from the source chain (if the transaction originated from Ethereum, this will be the source chain) to the destination

​

Sample Query

Finding the most popular bridge flows in the last month.

select 

    concat(source_chain, ' > ', destination_chain) as flow, 

    count(distinct transaction_from_address) as unique_users,

    count(1) as transfers,

    round(median(usd_amount)) as median_volume_usd,

    sum(nvl(usd_amount,0)) as usd_volume,

    round(usd_volume/pow(10,6),2) as usd_mil

from crosschain.bridges.transfers

where block_timestamp >= current_timestamp - interval '1 months'

group by all 

order by usd_volume desc

​

Columns

Unique key: unique_id