Bridge Events
The avalanche.bridge_events table provides indexed views of all bridge transactions from or to a specified chain, and includes the other chain involved. All bridge events tables follow the same database schema presented below.
Columns
| Name | Type | Description |
|---|---|---|
| block_number | integer |
The block number at which the event occurred. |
| bridge_name | text |
The name of the bridge protocol that facilitated the event. |
| contract_address | text |
The contract address where tokens were deposited to. |
| contract_version | text |
The version of the bridge contract interacted with (e.g. v1 or v2). |
| direction | text |
The direction of the bridge events with respect to the chain being queried (e.g. 'IN' or 'OUT'). |
| from_address | text |
The address that sent tokens on the from_chain_id (null if not found). |
| from_chain_id | text |
The name of the from chain (e.g. 'ETHEREUM', 'SOLANA', 'AVALANCHE'). |
| from_quantity | numeric |
The quantity of the from_token_address. |
| from_token_address | text |
The token address deposited on the from_chain_id (null if not found). |
| from_transaction_hash | text |
The transaction hash on the from_chain_id in which tokens were bridged out of. |
| log_index | integer |
The log index at which the event occurred. |
| metadata | jsonb |
Protocol-specific metadata for the event (e.g. txn ID that links txns on each chain). |
| timestamp | timestamp without time zone |
The timestamp at which the event occurred. |
| to_address | text |
The address that received tokens on the to_chain_id (null if not found). |
| to_chain_id | text |
The name of the to chain (e.g. 'ETHEREUM', 'SOLANA', 'AVALANCHE'). |
| to_quantity | numeric |
The quantity of the to_token_address. |
| to_token_address | text |
The token address unlocked on the to_chain_id (null if not found). |
| to_transaction_hash | text |
The transaction hash on the to_chain_id in which tokens were bridged into. |
| transaction_hash | text |
The transaction hash at which the event occurred. |
| __block_number | integer |
The block number at which the event took place in. |
| __confirmed | boolean |
Flag indicating whether the transfer has been confirmed. |
| __last_modified | timestamp |
The date at which this row was last updated (in ISO-8601 format). |
Supported Protocols
| Protocol | |||
|---|---|---|---|
| allbridge-core | allbridge-v1 | allbridge-v2 | ankr-v1 |
| avalanche-erc20 | avalanche-v2 | avalanche-v3 | axelar-squid |
| axelar-v1 | bsc-v1 | celer-cbridge | celer-pegged-token-bridge |
| celer-token-vault | celer-v2 | chainbridge-v1-forks | chainlink-v1 |
| chainlink-v2 | chainport-v1 | chainsafe-v1 | circle-v1 |
| complus-v1 | connext-v1 | crosschainbridge-v1 | dctdao-v1 |
| debridge-dln | debridge-v1 | ethereum-v1 | evodefi-v1 |
| frax-ferry | fxcore-v1 | gnosis-v1 | heco-v1 |
| hyphen-v2 | iotex-v1 | layer0-aptos | merkly-v1 |
| meter-v1 | multibit-v1 | multichain-v7 | nomad-v1 |
| optics-v1 | polygon-v1 | polynetwork-v1 | relay-v1 |
| ren-v1 | rhino-v1 | router-v1 | socket-refuel |
| sphynx-v1 | stargate-v1 | swft-v1 | symbiosis-v1 |
| synapse-v1 | thorchain-v1 | ultron-v1 | wanchain-v1 |
| wormhole-core | wormhole-hashflow | wormhole-l2 |
Indexes
| Index |
|---|
| metadata |
| bridge_name, timestamp, log_index |
| to_chain_id, timestamp, log_index |
| from_chain_id, timestamp, log_index |
| to_address, timestamp, log_index |
| from_address, timestamp, log_index |
| to_token_address, timestamp, log_index |
| from_token_address, timestamp, log_index |
| timestamp, log_index |
| transaction_hash, log_index |
| __last_modified |
| __indexer_id WHERE __confirmed = false |
| __indexer_id, __block_number |
| block_number, log_index |
Got questions? Join our Discord
Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.