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.
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
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.
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.
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.
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