Messaging Protocol Messages

The crosschain.bridges.messaging_protocols_inbound_messages and crosschain.bridges.messaging_protocols_outbound_messages tables provide message activity from cross-chain communication layers across all supported chains. Both tables share an identical schema — the direction column distinguishes inbound from outbound records. Messaging protocols support both token transfers and arbitrary message passing. Token transfer fields are populated when the message includes a token payload; message_details captures protocol-specific non-token message data. Protocols covered: Axelar, Chainlink CCIP, Circle CCTP (v1, v2), Hyperlane, LayerZero (v2), Socket DL, Wormhole Chains: Abstract, Aptos, Arbitrum, Avalanche, Base, BSC, Ethereum, HyperEVM, Ink, Katana, Mantle, Optimism, Plasma, Polygon, Scroll, SEI, Solana, Sui, Tron, Unichain, WorldChain

Table Columns

Unique key: unique_id

Column Name	Data Type	Description
chain	VARCHAR	The blockchain where this message was recorded (e.g., `ethereum`, `solana`).
project	VARCHAR	The messaging protocol name (e.g., `layerzero`, `wormhole`, `circle_cctp`).
protocol	VARCHAR	The specific protocol version identifier (e.g., `layerzero_v2`, `cctp_v2`).
contract_address	VARCHAR	The messaging protocol contract address on this chain.
event_name	VARCHAR	The on-chain event name that generated this record.
direction	VARCHAR	Message direction relative to this chain: `inbound` or `outbound`.
source_chain	VARCHAR	The chain where the message originates.
destination_chain	VARCHAR	The chain where the message is destined.
sender_address	VARCHAR	The address that sent the message.
recipient_address	VARCHAR	The address that receives the message on the destination chain.
token_type	VARCHAR	The token standard, if this message includes a token transfer (e.g., `ERC20`, `SPL`). NULL for message-only transfers.
token_address	VARCHAR	The contract address of the token being transferred. NULL for message-only transfers.
token_name	VARCHAR	Human-readable token name. NULL for message-only transfers.
token_symbol	VARCHAR	Token ticker symbol. NULL for message-only transfers.
amount_raw	VARCHAR	Raw token amount, not adjusted for decimals. NULL for message-only transfers.
amount	VARCHAR	Decimal-adjusted token amount. NULL for message-only transfers.
usd_amount	FLOAT	USD value of the token transfer at time of transaction. NULL for message-only transfers.
fee_token_address	VARCHAR	Contract address of the token used to pay messaging 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.
message_details	VARIANT	Protocol-specific message payload fields (non-token data such as nonces, sequence numbers, and message hashes).
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 message 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 message 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

Outbound messaging protocol volume by protocol and destination chain in the last 7 days.

SELECT
    project,
    protocol,
    destination_chain,
    COUNT(1) AS messages,
    COUNT_IF(usd_amount IS NOT NULL) AS token_transfers,
    SUM(usd_amount) AS usd_volume
FROM crosschain.bridges.messaging_protocols_outbound_messages
WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '7 days'
GROUP BY ALL
ORDER BY messages 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