bridges_evms.deposits table contains individual bridge deposit events on source chains, enriched with token metadata and USD pricing.
Table Schema
| Column | Type | Description |
|---|---|---|
deposit_chain | VARCHAR | Blockchain where tokens were sent from |
withdrawal_chain_id | DOUBLE | Chain ID where tokens were received |
withdrawal_chain | VARCHAR | Blockchain where tokens were received |
bridge_name | VARCHAR | Bridge protocol name |
bridge_version | VARCHAR | Bridge version |
block_date | TIMESTAMP | Block date |
block_time | TIMESTAMP | Block timestamp |
block_number | BIGINT | Block number |
deposit_amount_raw | DOUBLE | Raw amount of tokens bridged |
deposit_amount | DOUBLE | Amount of tokens bridged in display units |
deposit_amount_usd | DOUBLE | USD value of tokens bridged |
sender | VARBINARY | Source address |
recipient | VARBINARY | Destination address |
deposit_token_standard | VARCHAR | Source token standard |
deposit_token_address | VARBINARY | Source token contract address |
tx_from | VARBINARY | Address that initiated the deposit |
tx_hash | VARBINARY | Transaction hash |
evt_index | BIGINT | Event index |
contract_address | VARBINARY | Bridge contract address |
bridge_transfer_id | VARCHAR | Bridge order identifier |
duplicate_index | BIGINT | Index for duplicate deposit events |