Transfers

The crosschain.bridges.bridges_inbound_transfers and crosschain.bridges.bridges_outbound_transfers tables provide bridge transfer activity for application bridges across all supported chains. Both tables share an identical schema — the direction column distinguishes inbound from outbound records. Protocols covered: Across (v2, v3), DeBridge (DLN + Gate), Gas Zip, Mayan (MCTP, Swift), Rhino, Stargate (v2), USDT0 Chains: Abstract, Arbitrum, Avalanche, Base, BSC, Ethereum, HyperEVM, Ink, Katana, Mantle, Optimism, Plasma, Polygon, Scroll, SEI, Unichain, WorldChain, Solana, Tron

Table Columns

Unique key: unique_id

Column Name	Data Type	Description
chain	VARCHAR	The blockchain where this transfer was recorded (e.g., `ethereum`, `arbitrum`).
project	VARCHAR	The project or product name (e.g., `across`, `stargate`).
protocol	VARCHAR	The specific protocol version identifier (e.g., `across_v3`, `stargate_v2`).
messaging_protocol	VARCHAR	The underlying messaging protocol used by this bridge, if applicable (e.g., `layerzero` for Stargate). NULL if the bridge uses its own messaging layer.
contract_address	VARCHAR	The bridge contract address on this chain.
event_name	VARCHAR	The on-chain event name that generated this record.
direction	VARCHAR	Transfer direction relative to this chain: `inbound` or `outbound`.
source_chain	VARCHAR	The chain where the transfer originates.
destination_chain	VARCHAR	The chain where the transfer is destined.
sender_address	VARCHAR	The address that initiated the bridge transfer.
recipient_address	VARCHAR	The address that receives funds on the destination chain.
token_type	VARCHAR	The token standard (e.g., `ERC20`, `SPL`, `native`).
token_address	VARCHAR	The contract address of the token being transferred.
token_name	VARCHAR	Human-readable token name.
token_symbol	VARCHAR	Token ticker symbol (e.g., `USDC`, `ETH`).
amount_raw	VARCHAR	Raw token amount, not adjusted for decimals.
amount	VARCHAR	Decimal-adjusted token amount.
usd_amount	FLOAT	USD value of the transfer at the time of the transaction.
fee_token_address	VARCHAR	Contract address of the token used to pay fees. NULL if not applicable.
fee_token_name	VARCHAR	Human-readable name of the fee token.
fee_token_symbol	VARCHAR	Fee token ticker symbol.
fee_amount_raw	VARCHAR	Raw fee amount, not adjusted for decimals.
fee_amount	VARCHAR	Decimal-adjusted fee amount.
fee_usd_amount	FLOAT	USD value of the fee at the time of the transaction.
fee_details	VARIANT	Protocol-specific fee breakdown (gas costs, bridge fees, etc.).
extra_fields	VARIANT	Protocol-specific additional fields not captured in standard columns.
transaction_from_address	VARCHAR	The EOA or contract that submitted the transaction.
transaction_to_address	VARCHAR	The contract address called in the transaction.
transaction_hash	VARCHAR	The on-chain transaction hash.
transaction_index	BIGINT	The transaction’s position within the block.
log_index	BIGINT	The log’s position within the transaction.
block_number	BIGINT	The block height at which this transfer was recorded.
block_timestamp	TIMESTAMP_NTZ(9)	The timestamp of the block.
block_hash	VARCHAR	The hash of the block.
unique_id	VARCHAR	A unique identifier for this transfer record.
_created_at	TIMESTAMP_NTZ(9)	Timestamp when this record was created in Allium.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when this record was last updated in Allium.

Sample Query

Top bridge protocols by volume in the last 7 days, split by direction.

SELECT
    protocol,
    direction,
    source_chain,
    destination_chain,
    COUNT(1) AS transfers,
    SUM(usd_amount) AS usd_volume
FROM crosschain.bridges.bridges_outbound_transfers
WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '7 days'
GROUP BY ALL
ORDER BY usd_volume DESC
LIMIT 50

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Sample Query

​Table Columns

​Sample Query

Table Columns

Sample Query