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'
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
