Owner-to-address mapping data — associates blockchain addresses with known entities for tracking ownership, contract deployments, and operational scope
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.