labels.owner_addresses

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

Column	Type	Description
`address`	`VARBINARY`	Blockchain address
`blockchain`	`VARCHAR`	Blockchain the address belongs to
`owner_key`	`VARCHAR`	Unique key linking to owner_details
`custody_owner`	`VARCHAR`	Entity that has custody of the address
`account_owner`	`VARCHAR`	Entity that owns the account
`contract_name`	`VARCHAR`	Name of the deployed contract
`contract_version`	`VARCHAR`	Version of the deployed contract
`eoa`	`VARCHAR`	Whether the address is an EOA
`factory_contract`	`VARCHAR`	Factory contract used to deploy
`source`	`VARCHAR`	Source of the label data
`identifying_transaction`	`VARCHAR`	Transaction used to identify the address
`algorithm_name`	`VARCHAR`	Algorithm used for identification
`source_website`	`VARCHAR`	Website source for the label
`source_evidence`	`VARCHAR`	Evidence supporting the label
`created_at`	`TIMESTAMP`	When the record was created
`created_by`	`VARCHAR`	Who created the record
`updated_at`	`TIMESTAMP`	When the record was last updated
`updated_by`	`VARCHAR`	Who 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

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

labels.owner_addresses

Table Schema

Table Sample

Example Query

​Table Schema

​Table Sample

​Example Query

Table Schema

Table Sample

Example Query