Skip to main content
Schema: movement.defi Table: fact_bridge_activity Type: View Bridge activity tracking across different bridge protocols. Contains information about cross-chain bridge transactions.

Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERThe block number.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe timestamp of the block.
VERSIONNUMBERThe transaction version number.
TX_HASHTEXTThe transaction hash.
PLATFORMTEXTThe bridge platform name.
BRIDGE_ADDRESSTEXTThe bridge contract address.
EVENT_NAMETEXTThe name of the bridge event.
DIRECTIONTEXTThe direction of the bridge (inbound/outbound).
TX_SENDERTEXTThe transaction sender address.
SENDERTEXTThe bridge sender address.
RECEIVERTEXTThe bridge receiver address.
SOURCE_CHAIN_IDNUMBERThe source chain ID.
SOURCE_CHAIN_NAMETEXTThe source chain name.
DESTINATION_CHAIN_IDNUMBERThe destination chain ID.
DESTINATION_CHAIN_NAMETEXTThe destination chain name.
TOKEN_ADDRESSTEXTThe token contract address.
AMOUNT_UNADJNUMBERThe unadjusted transfer amount.
EVENT_INDEXNUMBERThe index of the event within the transaction.
FACT_BRIDGE_ACTIVITY_IDTEXTUnique identifier for the row.
INSERTED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was inserted.
MODIFIED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was last modified.