cex.flows table contains all token flows to and from identified centralized exchange addresses across 21 EVM chains, classified as inflows or outflows with USD pricing.
Table Schema
| Column | Type | Description |
|---|---|---|
blockchain | VARCHAR | Blockchain |
block_month | DATE | Block month |
block_time | TIMESTAMP | Block timestamp |
block_number | BIGINT | Block number |
cex_name | VARCHAR | Centralized exchange name |
distinct_name | VARCHAR | Distinct name of the CEX address |
token_address | VARBINARY | Token contract address |
token_symbol | VARCHAR | Token symbol |
token_standard | VARCHAR | Token standard |
flow_type | VARCHAR | Flow type (deposit or withdrawal) |
amount | DOUBLE | Token amount |
amount_raw | UINT256 | Raw token amount |
amount_usd | DOUBLE | USD value |
from | VARBINARY | Sender address |
to | VARBINARY | Recipient address |
tx_from | VARBINARY | Address that executed the transaction |
tx_to | VARBINARY | Address the transaction points to |
tx_index | BIGINT | Transaction index |
tx_hash | VARBINARY | Transaction hash |
evt_index | BIGINT | Event index |
unique_key | VARCHAR | Unique transfer identifier |