Skip to main content
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 NameData TypeDescription
chainVARCHARThe blockchain where this transfer was recorded (e.g., ethereum, arbitrum).
projectVARCHARThe project or product name (e.g., across, stargate).
protocolVARCHARThe specific protocol version identifier (e.g., across_v3, stargate_v2).
messaging_protocolVARCHARThe underlying messaging protocol used by this bridge, if applicable (e.g., layerzero for Stargate). NULL if the bridge uses its own messaging layer.
contract_addressVARCHARThe bridge contract address on this chain.
event_nameVARCHARThe on-chain event name that generated this record.
directionVARCHARTransfer direction relative to this chain: inbound or outbound.
source_chainVARCHARThe chain where the transfer originates.
destination_chainVARCHARThe chain where the transfer is destined.
sender_addressVARCHARThe address that initiated the bridge transfer.
recipient_addressVARCHARThe address that receives funds on the destination chain.
token_typeVARCHARThe token standard (e.g., ERC20, SPL, native).
token_addressVARCHARThe contract address of the token being transferred.
token_nameVARCHARHuman-readable token name.
token_symbolVARCHARToken ticker symbol (e.g., USDC, ETH).
amount_rawVARCHARRaw token amount, not adjusted for decimals.
amountVARCHARDecimal-adjusted token amount.
usd_amountFLOATUSD value of the transfer at the time of the transaction.
fee_token_addressVARCHARContract address of the token used to pay fees. NULL if not applicable.
fee_token_nameVARCHARHuman-readable name of the fee token.
fee_token_symbolVARCHARFee token ticker symbol.
fee_amount_rawVARCHARRaw fee amount, not adjusted for decimals.
fee_amountVARCHARDecimal-adjusted fee amount.
fee_usd_amountFLOATUSD value of the fee at the time of the transaction.
fee_detailsVARIANTProtocol-specific fee breakdown (gas costs, bridge fees, etc.).
extra_fieldsVARIANTProtocol-specific additional fields not captured in standard columns.
transaction_from_addressVARCHARThe EOA or contract that submitted the transaction.
transaction_to_addressVARCHARThe contract address called in the transaction.
transaction_hashVARCHARThe on-chain transaction hash.
transaction_indexBIGINTThe transaction’s position within the block.
log_indexBIGINTThe log’s position within the transaction.
block_numberBIGINTThe block height at which this transfer was recorded.
block_timestampTIMESTAMP_NTZ(9)The timestamp of the block.
block_hashVARCHARThe hash of the block.
unique_idVARCHARA unique identifier for this transfer record.
_created_atTIMESTAMP_NTZ(9)Timestamp when this record was created in Allium.
_updated_atTIMESTAMP_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