> ## 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.

# Bridge Aggregator Transfers

> Inbound and outbound transfers routed through bridge aggregators, unified across all supported chains.

The `crosschain.bridges.bridge_aggregators_inbound_transfers` and `crosschain.bridges.bridge_aggregators_outbound_transfers` tables provide transfer activity for bridge aggregators across all supported chains. Both tables share an identical schema — the `direction` column distinguishes inbound from outbound records.

Bridge aggregators route transactions through underlying application bridges. Aggregator and underlying bridge events are tracked in separate tables to prevent double-counting transfer volumes.

**Protocols covered:** Bungee, Jumper, LiFi

**Chains:** Abstract, Arbitrum, Avalanche, Base, BSC, Ethereum, HyperEVM, Ink, Katana, Mantle, Optimism, Plasma, Polygon, Scroll, SEI, Unichain, WorldChain, Solana

## Table Columns

Unique key: `unique_id`

| Column Name                | Data Type         | Description                                                                 |
| -------------------------- | ----------------- | --------------------------------------------------------------------------- |
| chain                      | VARCHAR           | The blockchain where this transfer was recorded (e.g., `ethereum`, `base`). |
| project                    | VARCHAR           | The aggregator project name (e.g., `bungee`, `jumper`, `lifi`).             |
| protocol                   | VARCHAR           | The specific protocol version identifier.                                   |
| contract\_address          | VARCHAR           | The aggregator 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           | Aggregator-specific fee breakdown.                                          |
| 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

Bridge aggregator outbound volume by protocol and destination in the last 7 days.

```sql theme={null}
SELECT
    project,
    destination_chain,
    token_symbol,
    COUNT(1) AS transfers,
    SUM(usd_amount) AS usd_volume
FROM crosschain.bridges.bridge_aggregators_outbound_transfers
WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '7 days'
GROUP BY ALL
ORDER BY usd_volume DESC
LIMIT 50
```