cex.deposit_addresses

The 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

Table sample

Addresses Overview

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

cex.deposit_addresses

Table Schema

Table sample

​Table Schema

​Table sample

Table Schema

Table sample