bridges_evms.flows table contains matched deposit-withdrawal pairs representing complete cross-chain bridge transfers across 41 EVM chains.
Table Schema
| Column | Type | Description |
|---|---|---|
deposit_chain | VARCHAR | Blockchain where tokens were sent from |
deposit_chain_id | DOUBLE | Chain ID where tokens were sent from |
withdrawal_chain | VARCHAR | Blockchain where tokens were received |
withdrawal_chain_id | DOUBLE | Chain ID where tokens were received |
bridge_name | VARCHAR | Bridge protocol name |
bridge_version | VARCHAR | Bridge version |
deposit_block_date | TIMESTAMP | Deposit block date |
deposit_block_time | TIMESTAMP | Deposit block timestamp |
deposit_block_number | BIGINT | Deposit block number |
withdrawal_block_date | DATE | Withdrawal block date |
withdrawal_block_time | TIMESTAMP | Withdrawal block timestamp |
withdrawal_block_number | BIGINT | Withdrawal block number |
deposit_amount_raw | DOUBLE | Raw amount deposited |
deposit_amount | DOUBLE | Amount deposited in display units |
withdrawal_amount_raw | DOUBLE | Raw amount withdrawn |
withdrawal_amount | DOUBLE | Amount withdrawn in display units |
amount_usd | DOUBLE | USD value of the bridge transfer |
sender | VARBINARY | Source address |
recipient | VARBINARY | Destination address |
deposit_token_standard | VARCHAR | Source token standard |
withdrawal_token_standard | VARCHAR | Destination token standard |
deposit_token_address | VARBINARY | Source token address |
withdrawal_token_address | VARBINARY | Destination token address |
deposit_tx_from | VARBINARY | Address that initiated the deposit |
deposit_tx_hash | VARBINARY | Deposit transaction hash |
withdrawal_tx_hash | VARBINARY | Withdrawal transaction hash |
bridge_transfer_id | VARCHAR | Bridge order identifier |
duplicate_index | BIGINT | Index for duplicate events |