Accounts

dimensions.accounts holds one row per labeled address on Solana, keyed on chain_id and address. An account is a wallet or a program, such as an exchange wallet or an Orca pool, and its row names the project that runs it, so a raw address in any Solana table resolves to a name. label_source says how an address reached the table. The Solana rows are curated, an attribution a person authored; factory_derived marks an address a known factory emitted and names that factory in parent_address. Every column is documented at Accounts.

Sample queries

The table is clustered on account_id, and that key is the one filter that prunes a scan of it. A query filtered on chain_id or project_id instead reads every row, which stays inexpensive because the table is small, but keep the select list to the columns you need.

Labeled projects
What one project runs
Look up one address

Rank the projects with the most labeled addresses on Solana. 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 = 'solana'
  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 Solana. contract_name is the label the attributing project gives an address, and account_type reads smartcontract for a program.

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

Resolve one Solana address to the project that runs it. account_id is the address and the chain joined by a hyphen, and Solana spells an address in case-sensitive base58, so paste it exactly as it appears.

select
    address,
    project_id,
    contract_name,
    account_type
from `dimensions.accounts`
where account_id = 'JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4-solana'

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Sample queries

​Sample queries

Sample queries