Accounts

dimensions.accounts holds one row per address on Arc that is labeled or that a facts_accounts table holds a row for, keyed on chain_id and address. An account is a wallet or a contract, such as an exchange wallet or a Uniswap pool, and where it is labeled its row names the project that runs it, so a labeled address in any Arc table resolves to the project behind it. An address nobody has labeled has a null label_source and null label columns beside its region and funding. A labeled address reaches the table in one of two ways, and label_source says which. curated is an attribution a person authored; factory_derived is an address a known factory emitted, and those rows name that factory in parent_address. Factory output is the bulk of the labeled rows, so filter to curated for the set somebody has already looked at. Every column is documented at Accounts.

Sample queries

The table is clustered on chain_id then address. Filter on chain_id to read one chain, and add address for a single account; a query filtered only on project_id or label_source reads every row of a table that spans every account the facts hold, so keep the select list to the columns you need.

Labeled projects
What one project runs
A factory's output

Rank the projects with the most labeled addresses on Arc. Joining dimensions.projects on project_id adds each project’s name and its market sector.

select
    projects.name,
    projects.primary_market_sector,
    count(*) as addresses
from `dimensions.accounts` as accounts
join `dimensions.projects` as projects
    using (project_id)
where accounts.chain_id = 'arc'
  and accounts.label_source = 'curated'
group by projects.name, projects.primary_market_sector
order by addresses desc
limit 50

List the addresses one project runs on Arc. contract_name is the label the attributing project gives an address, such as GatewayWallet or a token’s own contract.

select
    address,
    contract_name,
    account_type
from `dimensions.accounts`
where chain_id = 'arc'
  and project_id = 'circle'
  and label_source = 'curated'
order by contract_name
limit 100

Rank the factories by how many addresses they emitted on Arc. Every factory-derived row names its factory in parent_address, so grouping on that column returns one row per factory.

select
    parent_address,
    project_id,
    count(*) as emitted
from `dimensions.accounts`
where chain_id = 'arc'
  and label_source = 'factory_derived'
group by parent_address, project_id
order by emitted desc
limit 50

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Sample queries

​Sample queries

Sample queries