Skip to main content
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 NameData TypeDescription
chainVARCHARThe blockchain where this transfer was recorded (e.g., ethereum, base).
projectVARCHARThe aggregator project name (e.g., bungee, jumper, lifi).
protocolVARCHARThe specific protocol version identifier.
contract_addressVARCHARThe aggregator 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_detailsVARIANTAggregator-specific fee breakdown.
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

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