Bridge Aggregator Transfers

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.

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

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