Skip to main content
Schema: crosschain.defi Table: ez_bridge_activity Type: View

​
What

A comprehensive convenience table holding blockchain and platform specific bridge activity from event_logs, traces and transfers, including bridge deposits/withdrawals and transfers in/out on the following blockchains: Arbitrum, Avalanche, Base, Blast, BSC, Gnosis, Ethereum, Optimism, Polygon, Solana, Aptos, Near, Flow and more. This table also includes prices and token symbols, where available. Note: source_address and destination_address are intentionally case-sensitive where applicable, depending on the requirements of the network.

​
Columns

Column NameData TypeDescription
BLOCKCHAINTEXTBlockchain, Network, or Platform the token bridge activity is recorded on.
PLATFORMTEXTThe name of the bridge platform, typically a concatenation of the protocol and version.
PROTOCOLTEXTThe name of the protocol.
PROTOCOL_VERSIONTEXTThe version of the protocol.
BLOCK_NUMBERNUMBERAlso known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
TX_HASHTEXTTransaction hash is a unique identifier that is generated when a transaction is executed.
SOURCE_CHAINTEXTThe name of the blockchain network to which the assets are being bridged from.
DESTINATION_CHAINTEXTThe name of the blockchain network to which the assets are being bridged to.
BRIDGE_ADDRESSTEXTThe address of the contract responsible for handling the bridge deposit or transfer. This contract mediates the transfer and ensures that assets are sent and received appropriately.
SOURCE_ADDRESSTEXTThe address that initiated the bridge deposit or transfer. This address is the sender of the tokens/assets being bridged to the destination chain. This may be an EOA or contract address.
DESTINATION_ADDRESSTEXTThe designated address set to receive the bridged tokens on the target chain after the completion of the bridge transaction. For non-evm chains, the hex address is decoded/encoded to match the data format of the destination chain, where possible. This may be an EOA or contract address.
DIRECTIONTEXTIndicates the direction in which the assets are being bridged, out/outbound or in/inbound.
TOKEN_ADDRESSTEXTThe address associated with the token that is being bridged. It provides a unique identifier for the token within its origin blockchain.
TOKEN_SYMBOLTEXTThe symbol representing the token being bridged. This provides a shorthand representation of the token.
AMOUNT_RAWFLOATThe raw, non-decimal adjusted amount of tokens involved in the bridge transaction. For Solana, these are decimal adjusted amounts.
AMOUNTFLOATThe decimal adjusted amount of tokens involved in the bridge transaction, where available.
AMOUNT_USDFLOATThe value of the bridged tokens in USD at the time of the bridge transaction, where available.
TOKEN_IS_VERIFIEDBOOLEANA boolean flag indicating if the token is verified by either uniswap labs or passing a threshold of transfers metrics on the chain.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.
EZ_BRIDGE_ACTIVITY_IDTEXTThe unique identifier for each row in the table.