The bridges.transfers aggregates transaction-level bridge transfers across multiple blockchains indexed by Allium.
We are actively improving bridge protocol & blockchain coverage and data completeness for the bridges vertical.

​
Blockchain Coverage

The bridges.transfers includes bridge transfers indexed from the following blockchains.
BlockchainsTotal Blockchains Supported
arbitrum, avalanche, base, blast, bsc, ethereum, fantom, linea, mode, optimism, polygon, scroll, worldchain13

​
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.
Distinct Source BlockchainsDistinct Destination Blockchains
61139

​
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.
Bridge TypeDirectionProtocolsCount
applicationoutbound onlycircle_cctp, hop, across, synapse, celer, axelar, zkbridge, stargate, symbiosis, debridge, ybridge, eywa11
canonicalinbound and outboundop, arbitrum, polygon, polygon_zkevm, near, sui, zk_shared_bridge, zksync, immutable_x, starknet, ronin11

​
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
Column NameData TypeDescription
bridgeVARCHARThe slug or name of the bridge. For canonical bridges, the bridge name corresponds to the destination chain name.
protocolVARCHARThe protocol associated with the bridge transfer. Optimism stack bridge events will share the same bridge protocol, op.
contract_addressVARCHARThe contract address of the bridge.
event_nameVARCHARThe name of the event that triggered the transfer.
sender_addressVARCHARThe address that initiated the transfer.
recipient_addressVARCHARThe address that received the transfer on the destination chain, if applicable.
directionVARCHARThe direction of the transfer (e.g., inbound or outbound), based on the chain.
source_chain_idVARCHARThe ID of the source chain. Note that for non-EVM chains, there is typically no chainID.
source_chainVARCHARThe name of the source chain, i.e. the chain on which a token was originally deployed and minted.
destination_chain_idVARCHARThe ID of the destination chain. Note that for non-EVM chains, there is typically no chainID.
destination_chainVARCHARThe name of the destination chain, i.e. the chain on which a bridge user wants to have their tokens.
token_in_addressVARCHARThe address of the token being transferred.
token_in_nameVARCHARThe name of the token being transferred.
token_in_symbolVARCHARThe symbol of the token being transferred.
token_in_amount_rawVARCHARThe raw amount of the token being transferred.
token_in_amountFLOATThe normalized amount of the token being transferred.
usd_in_amountFLOATThe USD equivalent of the token being transferred.
token_out_addressVARCHAR(Nullable) The address of the token being transferred out.
token_out_nameVARCHAR(Nullable) The name of the token being transferred out.
token_out_symbolVARCHAR(Nullable) The symbol of the token being transferred out.
token_out_amount_rawVARCHAR(Nullable) The raw amount of the token being transferred out.
token_out_amountFLOAT(Nullable) The normalized amount of the token being transferred out.
usd_out_amountFLOAT(Nullable) The USD equivalent of the token being transferred out.
usd_amountFLOATThe USD equivalent of the transfer, capped at a maximum value.
extra_fieldsVARIANTAdditional fields related to the transfer.
transaction_from_addressVARCHARThe address from which the transaction was sent.
transaction_to_addressVARCHARThe address to which the transaction was sent.
transaction_hashVARCHARThe hash of the transaction.
transaction_indexBIGINTThe index of the transaction within the block.
log_indexBIGINTThe index of the log within the transaction.
block_numberBIGINTThe number of the block containing the transaction.
block_timestampTIMESTAMP_NTZ(9)The timestamp of the block containing the transaction.
block_hashVARCHARThe hash of the block containing the transaction.
unique_idVARCHARA unique identifier for the transfer.
created_atTIMESTAMP_NTZ(9)The timestamp when the record was created.
updated_atTIMESTAMP_NTZ(9)The timestamp when the record was last updated.