> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Messaging Protocol Messages

> Inbound and outbound cross-chain messages from general-purpose messaging protocols, unified across all supported chains.

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.

```sql theme={null}
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
```