Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.dune.com/llms.txt

Use this file to discover all available pages before exploring further.

The labels.owner_addresses table on Dune 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.

​
Table Schema

ColumnTypeDescription
addressVARBINARYBlockchain address
blockchainVARCHARBlockchain the address belongs to
owner_keyVARCHARUnique key linking to owner_details
custody_ownerVARCHAREntity that has custody of the address
account_ownerVARCHAREntity that owns the account
contract_nameVARCHARName of the deployed contract
contract_versionVARCHARVersion of the deployed contract
eoaVARCHARWhether the address is an EOA
factory_contractVARCHARFactory contract used to deploy
sourceVARCHARSource of the label data
identifying_transactionVARCHARTransaction used to identify the address
algorithm_nameVARCHARAlgorithm used for identification
source_websiteVARCHARWebsite source for the label
source_evidenceVARCHAREvidence supporting the label
created_atTIMESTAMPWhen the record was created
created_byVARCHARWho created the record
updated_atTIMESTAMPWhen the record was last updated
updated_byVARCHARWho last updated the record

​
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