The labels.owner_addresses table on Dune Analytics provides detailed data on blockchain addresses associated with various owners within the ecosystem, enhancing visibility into ownership distributions, contract deployments, and operational scopes. It’s a crucial tool for analysts to track ownership and custody of assets across blockchains.

You can find more details on the account owners and custody owners in the labels.owner_details table.

Column Descriptions

Column NameDescription
addressThe blockchain address associated with an entity.
blockchainThe blockchain network where the address is located (e.g., Ethereum, Binance Smart Chain).
owner_keyA unique identifier linked to the owner of the address.
custody_ownerThe name of the entity that has custody of the assets at the address.
account_ownerDetails about the account owner (this field is often not used and may be null).
contract_nameName of the smart contract deployed by this address, if applicable.
contract_versionVersion of the smart contract, if applicable.
eoaIndicates if the address is an Externally Owned Account (EOA) (this field is often not used).
factory_contractIndicates if the address belongs to a factory contract that deploys other contracts.
sourceReference to the data source providing the information (this field is often not used).
indentifying_transactionTransaction ID that can be used to identify the ownership (this field is often not used).
algorithm_nameAlgorithm associated with the address for cryptographic operations (this field is often not used).
source_websiteWebsite URL providing the data about the address (this field is often not used).
source_evidenceAny evidence supporting the data provided (this field is often not used).
created_atTimestamp of when the record was first created.
created_byIdentifier of the contributor who created the record.
updated_atTimestamp of the last update to the record (if updated).
updated_byIdentifier of the contributor who last updated the record (if updated).

Table Sample

Example Query

The following SQL query demonstrates how to retrieve details about addresses owned by ‘Coinbase’:

SELECT
  *
FROM
  labels.owner_addresses
 where custody_owner = 'Coinbase'

The other way around is also possible, to find the custody owner of specific addresses. Here we match entities that have deposited assets to the 0x00000000219ab540356cBB839Cbe05303d7705Fa address, which is the ETH 2.0 deposit contract.

Select
  "from",
  "to",
  value,
  block_date,
  hash,
  custody_owner
from
  ethereum.transactions
  inner join labels.owner_addresses on "from" = labels.owner_addresses.address
where
  "to" = 0x00000000219ab540356cBB839Cbe05303d7705Fa