Skip to main content

Table Details

PropertyValue
Table Namehyperevm.bridges.transfers
Table StatusProduction-Ready
Unique Keyblock_timestamp::date, unique_id
Clustering Key(s)block_timestamp::date

Table Columns

Column NameData TypeDescription
bridgeVARCHAR(16777216)The slug or name of the bridge. For canonical bridges, the bridge name corresponds to the destination chain name.
protocolVARCHAR(16777216)The protocol associated with the bridge transfer. Optimism stack bridge events will share the same bridge protocol, op.
contract_addressVARCHAR(16777216)The contract address of the bridge.
event_nameVARCHAR(16777216)The name of the event that triggered the transfer.
sender_addressVARCHAR(16777216)The address that initiated the transfer.
recipient_addressVARCHAR(16777216)The address that received the transfer on the destination chain, if applicable.
directionVARCHAR(16777216)The direction of the transfer (e.g., inbound or outbound), based on the chain.
source_chain_idVARCHAR(16777216)The ID of the source chain. Note that for non-EVM chains, there is typically no chainID.
source_chainVARCHAR(16777216)The name of the source chain, i.e. the chain on which a token was originally deployed and minted.
destination_chain_idVARCHAR(16777216)The ID of the destination chain. Note that for non-EVM chains, there is typically no chainID.
destination_chainVARCHAR(16777216)The name of the destination chain, i.e. the chain on which a bridge user wants to have their tokens.
token_in_addressVARCHAR(16777216)The address of the token being transferred.
token_in_nameVARCHAR(16777216)The name of the token being transferred.
token_in_symbolVARCHAR(16777216)The symbol of the token being transferred.
token_in_amount_rawVARCHAR(16777216)The raw amount of the token being transferred.
token_in_amount_strVARCHAR(16777216)The normalized amount of the token being transferred, in string format to retain precision.
token_in_amountFLOATThe normalized amount of the token being transferred.
usd_in_amountFLOATThe USD equivalent of the token being transferred.
token_out_addressVARCHAR(16777216)(Nullable) The address of the token being transferred out.
token_out_nameVARCHAR(16777216)(Nullable) The name of the token being transferred out.
token_out_symbolVARCHAR(16777216)(Nullable) The symbol of the token being transferred out.
token_out_amount_rawVARCHAR(16777216)(Nullable) The raw amount of the token being transferred out.
token_out_amount_strVARCHAR(16777216)(Nullable) The normalized amount of the token being transferred out, in string format to retain precision.
token_out_amountFLOAT(Nullable) The normalized amount of the token being transferred out.
usd_out_amountFLOAT(Nullable) The USD equivalent of the token being transferred out.
usd_amountFLOATThe USD equivalent of the transfer, capped at a maximum value.
extra_fieldsVARIANTAdditional fields related to the transfer.
transaction_from_addressVARCHAR(16777216)The address from which the transaction was sent.
transaction_to_addressVARCHAR(16777216)The address to which the transaction was sent.
transaction_hashVARCHAR(16777216)The hash of the transaction.
transaction_indexNUMBER(38,0)The index of the transaction within the block.
log_indexNUMBER(38,0)The index of the log within the transaction.
block_numberNUMBER(38,0)The number of the block containing the transaction.
block_timestampTIMESTAMP_NTZ(9)The timestamp of the block containing the transaction.
block_hashVARCHAR(16777216)The hash of the block containing the transaction.
unique_idVARCHAR(16777216)A unique identifier for the transfer.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.