labels
Address labels is a feature on Dune where you as a user can add, update and query labels for any address.
Because of all the open data on blockchain, we can enhance our understanding of any given address by tagging it with different labels. This immediately give any analysis enhanced context.
labels.addresses is a spell in Dune that allows you to add static or query labels to enhance your analysis.
What is a label?
A label is a piece of metadata about an address, a tag or metadata if you will. It comes in the form of a key-value pair. The key is the label type, and the value the label name.
Browse addresses and and labels at the labels page or contribute to the spell starting with the readme.
Here’s a list of label types:
- Identifiers: Most static labels should be this label type, as well as common usernames such as Farcaster, ENS, and Lens names. As a rule of thumb, identifiers should usually specify a unique entity name.
- Usage: These are the existing top volume and frequency (or some other percentile-able metric) within a domain and the usage of specific protocols. There must be some sort of ranking/percentile involved!
- Personas: These are for on-chain curated behaviors (like common CT memes) or protocol user tagging. They should be easily understood to non-analysts, though the underlying calculation methods may be more subjective.
To give a sense of examples, for the “social” category you would expect these labels:
- Identifier: Lens username (.lens) ENS reverse resolver (.eth), farcaster (_farcaster)
- Usage: top holders from ENS
- Usage: top posters from lens
- Persona: Lens User, ENS User
- Persona: Squatter (sitting on dozens of ENS names)
What labels look like
Check out this dashboard for examples on what can be created with labels.
The address 0xD551234Ae421e3BCBA99A0Da6d736074f22192FF can be labeled like this:
| Type | Name |
|---|---|
cex | binance |
The address is controlled by the exchange Binance.
The address 0xe65040f61701940b62e18da7a53126a58525588b can be labeled like this:
| label_type | Name |
|---|---|
persona | uniswap user |
persona | dex trader |
The address in the past interacted with Uniswap.
You are free to come up with both new types and label names, as labels on Dune are open ended and crowd sourced.
Adding labels
Use Dune queries to label addresses. A very powerful and scalable way to add labels like “all these addresses used Uniswap”, and much much more.
Please see our GitHub for examples of labels created with queries and PR in your own!
Examples of what you can do:
- Label all addresses that used a certain dapp
- Label all addresses that hold a certain amount of a token
- Label all addresses that use a dapp more than X times per month
- Label all addresses that sent money to Binance
You could also do more novel and involved things around user patterns like who did arbitrage trades or profited from flash loans and so much more.
Note that there might be a few minutes delay from adding the label on dune.com until you can query it in SQL.
The labels table
Labels are stored in the new labels.labels table which has the following schema:
| Column name | Data type | Description |
|---|---|---|
id | int | incrementing integer |
address | varbinary | The address of a contract or wallet this label describes |
name | varchar | label name |
blockchain | varchar | the blockchain the label is meant for |
author | varchar | The username of the user who created this label |
source | varchar | The source of this label, autopopulated by Dune |
updated_at | timestamptz | The last time this label was changed |
label_type | varchar | The type of label, defined in the readme |
model_name | varchar | The name of the label model (filename) |
Using labels
Was this page helpful?