👽Identity
The identity schema is nested under the common database.
The identity tables contain wallet labels and names which can be used to enhance the depth of your analysis.
Wallet addresses from some blockchains are case-sensitive. That is, you should not lowercase the wallet addresses when doing joins / analysis.
| Case-sensitive | Not case-sensitive | Depends |
|---|---|---|
Tron, Solana | EVM (0x-address): ethereum, polygon, etc. Cosmos | Bitcoin (base58 encoded addresses are case-sensitive, bech32 addresses are not) |
Entities
common.identity.entities provides a list of wallet addresses based on the entities.
Table Columns
| Column Name | Description | Notes | Example |
|---|---|---|---|
chain | Chain associated with the address. | One address can be shared across multiple chains. | ethereum |
category | Category associated with the entity - | Refer to table above for categories in this table. | cex |
project | Project associated with the entity. | In lower casing. | binance |
name | Name of the address. | - | Binance 9 |
address | Address. | Case-sensitivity of address. | 0x001866ae5b3de6caa5a51543fd9fb64f524f5478 |
Entities Categories
A short description of the categories present.
| Category | Description | Project Examples |
|---|---|---|
cex | Centralized exchange wallet addresses. Includes all types of wallets (cold/hot wallets) from CEX. Deposit wallets are currently not included. | binance, okx, kucoin |
fund | Address of major crypto funds - broadly encompass market makers, venture capitals, hedge funds. | alamedaresearch, a16z, wintermute |
ramp | Address related to entities involved in on and off-ramp solutions. | moonpay |
bridge | Address related to bridges, layer2 bridges etc. | optimism, arbitrum, arbitrumone, celernetwork |
nft | Address related to NFT entities, specifically marketplace protocols, platform fee collection. | opensea, blur.io |
mev | Address labeled as mev bot. | mev |
mixer | Address associated with money mixers that are used to obfuscate fund movement. | tornado.cash |
dex | Decentralize exchange protocol and router addresses, excludes liquidity pool address and tokens. | 0x, 1inch, paraswap, cowprotocol |
web3_wallet | Address primarily associated with web3 wallet entities. | rainbow, zerion, metamask |
stablecoin | List of stablecoin address by their chain of origin. | tether, frax, binance, circle |
Address Names and Labels
The address_name and address_labels table contains unique address name and labels associated with an address across various chain. Currently, this table includes lables from the following chains:
Ethereum, Polygon, Arbitrum, Optimism, Avalanche, Binance
Address Names
Address names are unique to each address.
| Table Name | Description |
|---|---|
chain | Blockchain of the address, in lower case. Includes: ethereum, polygon, arbitrum, avalanche, binance, optimism |
address | Account/wallet address. |
name | Name of the address. Each address only has one name e.g. Uniswap V2 Router in each chain. |
Address Labels
An address can have multiple labels associated with it.
| Table Name | Description |
|---|---|
chain | Blockchain of the address, in lower case. Includes: ethereum, polygon, arbitrum, avalanche, binance, optimism |
address | Account/wallet address. |
label | Labels associated with the address. Note: one address can have multiple labels e.g. bridge, polygon. |
Last updated