Accounts

dimensions.accounts holds one row per labeled address on Polygon, keyed on chain_id and address. An account is a wallet or a contract, such as an exchange wallet or a Uniswap pool, and its row names the project that runs it, so a raw address in any Polygon table resolves to a name. An 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 table, 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 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
A factory's output

Rank the projects with the most labeled addresses on Polygon. 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 = 'polygon'
  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 Polygon. contract_name is the label the attributing project gives an address, such as Factory or a pool’s pair.

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

Rank the factories by how many addresses they emitted on Polygon. 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 = 'polygon'
  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