Bridges Outbound Transfers

Protocols covered: NEAR Intents

Table Details

Property	Value
Table Name	`near.bridges.bridges_outbound_transfers`
Table Status	Production-Ready
Unique Key	`block_timestamp::date`, `unique_id`
Clustering Key(s)	`block_timestamp::date`

fee_details contains the on-chain protocol fee for the transfer, broken out by token as a fees_collected array, plus a referral tag when the transfer was attributed to a distribution partner. It does not include distribution-partner fee revenue, which is not recorded on-chain per transfer. fee_token_address and fee_amount_raw are populated only when a transfer’s fee was collected in a single token; both are NULL when a transfer’s fee spans multiple tokens.

Table Columns

Column Name	Data Type	Description
project	VARCHAR(16777216)	Business name of the protocol being used. Always `near_intents` for NEAR bridge coverage today.
protocol	VARCHAR(16777216)	Specific version or variant of the protocol. Always `near_intents` today — internally tracks 3 underlying contract stacks (Omni Bridge, PoA Bridge, HOT Bridge) via `extra_fields.bridge_stack`, never exposed as a top-level dimension.
messaging_protocol	VARCHAR(16777216)	Name of the cross-chain messaging layer used for this transfer. NULL for NEAR Intents, which settles via its own intent-solver mechanism rather than a dedicated messaging protocol.
contract_address	VARCHAR(16777216)	Address of the NEAR contract that emitted this event or was called in this transaction (e.g. `intents.near`).
event_name	VARCHAR(16777216)	Name of the on-chain event or method call that generated this record (e.g. `ft_withdraw`, `mt_withdraw`).
direction	VARCHAR(16777216)	Direction of this transfer relative to NEAR. Always `outbound` on this table — tokens leaving NEAR for another chain.
source_chain	VARCHAR(16777216)	Slug of the chain where the tokens originated. Always `near` on this table.
destination_chain	VARCHAR(16777216)	Slug of the chain where the tokens are being sent.
sender_address	VARCHAR(16777216)	Address that initiated the bridge transfer on NEAR. For many relayed transfers this is a shared relayer/pool account (e.g. `omni.bridge.near`), not the real end user.
recipient_address	VARCHAR(16777216)	Address that will receive the tokens on the destination chain, where resolvable. NULL for Solana, Aptos, and Starknet destinations, which route through an intermediate relay with no final address visible on-chain.
token_type	VARCHAR(16777216)	The token standard for this leg: `fungible_token` or `multi_token` (NEP-245, used by HOT Bridge’s multi-asset contract).
token_address	VARCHAR(16777216)	Contract address of the token, resolved to its real address on the token’s own chain — see `source_chain`/`destination_chain`.
token_name	VARCHAR(16777216)	Full name of the token (e.g. “USD Coin”, “Wrapped Ether”).
token_symbol	VARCHAR(16777216)	Ticker symbol of the token (e.g. “USDC”, “WETH”).
token_id	VARCHAR(16777216)	Identifier for a specific asset within a NEP-245 multi-token contract (HOT Bridge). NULL for single-asset (`fungible_token`) legs.
amount_raw	VARCHAR(16777216)	Token amount expressed in the token’s smallest indivisible unit (i.e. not divided by decimals). Use `amount` for the human-readable normalized value.
amount	VARCHAR(16777216)	Token amount normalized by the token’s decimal precision (amount_raw / 10^decimals). This is the human-readable value (e.g. 1.5 USDC rather than 1500000).
usd_amount	FLOAT	USD value of the token amount at the time of the event, computed using the hourly USD exchange rate.
fee_token_address	VARCHAR(16777216)	Contract address of the token used to pay the bridge protocol fee. NULL if the fee spans multiple tokens (see `fee_details`) or wasn’t collected.
fee_token_name	VARCHAR(16777216)	Full name of the token used to pay the bridge fee.
fee_token_symbol	VARCHAR(16777216)	Ticker symbol of the token used to pay the bridge fee.
fee_amount_raw	VARCHAR(16777216)	Raw amount of the bridge fee in the fee token’s smallest unit (not decimal-adjusted). NULL under the same conditions as `fee_token_address`.
fee_amount	VARCHAR(16777216)	Decimal-adjusted amount of the bridge fee.
fee_usd_amount	FLOAT	USD value of the bridge fee at the time of the transfer.
fee_details	VARIANT	Full per-token fee breakdown and referral tag. See the note above.
extra_fields	VARIANT	Protocol-specific fields as a JSON object. Keys: `bridge_stack` (`omni`, `poa`, or `hot` — which underlying NEAR Intents contract track produced this leg), `intent_hash`, `bridge_receiver_id`.
signer_id	VARCHAR(16777216)	The NEAR account ID that signed the transaction.
receiver_id	VARCHAR(16777216)	The NEAR account ID the transaction was sent to (the contract account, e.g. `intents.near`).
transaction_hash	VARCHAR(16777216)	Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.
transaction_index	NUMBER(38,0)	Zero-based position of the transaction within its block.
receipt_id	VARCHAR(16777216)	Unique identifier of the NEAR receipt that produced this record.
log_index	NUMBER(38,0)	Zero-based position of this event log within its transaction.
block_height	NUMBER(38,0)	Number of confirmed blocks between this block and the genesis block (inclusive). NEAR’s native block-height term — analogous to `block_number` on EVM chains and `block_slot` on Solana.
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp (UTC) of the block that contains this record.
block_hash	VARCHAR(16777216)	Cryptographic hash of the block header that contains this record. Uniquely identifies a block.
unique_id	VARCHAR(16777216)	Allium’s deterministic unique identifier for this row. For HOT Bridge legs carrying multiple token entries in a single event, includes a token-leg index to disambiguate each leg. Stable across full refreshes.
_created_at	TIMESTAMP_NTZ(9)	Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration).

Sample Query

Outbound transfer volume by destination chain over the last 7 days.

SELECT
    destination_chain,
    COUNT(1) AS transfers,
    SUM(usd_amount) AS usd_volume
FROM near.bridges.bridges_outbound_transfers
WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '7 days'
GROUP BY ALL
ORDER BY usd_volume DESC

Crosschain Bridge Transfers

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Table Columns

Sample Query

​Table Details

​Table Columns

​Sample Query

​Related Docs

Table Details

Table Columns

Sample Query

Related Docs