cex.deposit_addresses table contains programmatically detected user deposit addresses — identified through on-chain consolidation patterns where tokens flow from external wallets through deposit addresses to known CEX hot wallets.
Table Schema
| Column | Type | Description |
|---|---|---|
blockchain | VARCHAR | Blockchain |
address | VARBINARY | Deposit address |
cex_name | VARCHAR | CEX name |
first_deposit_token_standard | VARCHAR | Token standard of first deposit |
first_deposit_token_address | VARBINARY | Token address of first deposit |
deposit_first_block_time | TIMESTAMP | Time of first deposit |
consolidation_first_block_time | TIMESTAMP | Time of first consolidation by CEX |
deposit_count | BIGINT | Number of deposits |
consolidation_count | BIGINT | Number of consolidations |
amount_deposited | DOUBLE | Total amount deposited |
consolidation_unique_key | VARCHAR | Unique key for consolidation |
deposit_unique_key | VARCHAR | Unique key for deposit |