Registry

The identity tables behind every DEX figure. Every fact and metric joins to one of them, and Coverage introduces each grain.

Tables

Projects
Apps
Pools

One row per project in the catalog.

Column	Type	Description
`project_id`	STRING	The project, such as `aave`.
`name`	STRING	Display name.
`symbol`	STRING	Ticker of the project’s token, where it has one.
`status_label`	STRING	Whether the project is active or archived.
`market_sectors`	ARRAY<STRING>	Every sector the project is tagged with.
`primary_market_sector`	STRING	The first of those, for grouping.

One row per app in the catalog.

Column	Type	Description
`app_id`	STRING	The app, such as `aave-v3`.
`project_id`	STRING	The project operating it.
`name`	STRING	Display name.
`market_sectors`	ARRAY<STRING>	Every sector the app is tagged with.
`primary_market_sector`	STRING	The first of those, for grouping.
`created_at`	TIMESTAMP	When the app was added.

One row per pool on one chain, listing every pool ever created, including ones that never traded.

Column	Type	Description
`dex_pool_id`	`STRING`	Identifier of the pool: the pool address joined with the chain.
`protocol_id`	`STRING`	The app operating the pool. Older name for `app_id`, and the same values.
`chain_id`	`STRING`	Chain the pool lives on.
`project_id`	`STRING`	Project the operating app belongs to.
`pool_address`	`STRING`	Onchain address of the pool. Where one contract holds every pool, this is the pool’s id inside that contract.
`pool_name`	`STRING`	The pool’s tokens as a name, for example `USDC-WETH`.
`pool_display_name`	`STRING`	Pool name with the fee added on, where the pool charges a fixed one.
`fee_tier`	`BIGNUMERIC`	The fee the pool charges on every swap, as a decimal fraction, so `0.0005` reads 0.05%. Empty where the venue sets the fee swap by swap.
`created_at`	`TIMESTAMP`	Time of the block the pool was created in.
`hooks_address`	`STRING`	Address of the pool’s hooks contract, on venues that attach one. A hooks contract is extra code the venue runs around each swap.
`token_ids`	`ARRAY<STRING>`	The tokens the pool holds, in pool order, as keys of `dimensions.tokens`.

Sample queries

Pools per chain
A pool's tokens
Pools for one pair
Registry against traded pools

The pool registry names the app under the older protocol_id. Alias it to app_id so the result reads like the rest of the catalog.

select
    protocol_id as app_id,
    chain_id,
    count(*) as pools
from `dimensions.dex_pools`
group by app_id, chain_id
order by pools desc
limit 20

token_ids lists the pool’s tokens, in the order the pool holds them, as keys of dimensions.tokens. Join that table on one element of the list for symbol, name and decimals; a leg’s curated asset, where it has one, is on dimensions.asset_tokens under the same key.

select
    pools.dex_pool_id,
    pools.pool_display_name,
    position,
    tokens.symbol,
    tokens.decimals,
    tokens.token_address
from `dimensions.dex_pools` as pools,
    unnest(pools.token_ids) as token_id with offset as position
join `dimensions.tokens` as tokens
    using (token_id)
where pools.dex_pool_id = '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640-ethereum'
order by position

token_ids holds the pool’s tokens as a list, so a pair is two in unnest(token_ids) clauses rather than one equality.

select
    dex_pool_id,
    protocol_id as app_id,
    pool_display_name,
    fee_tier
from `dimensions.dex_pools`
where chain_id = 'ethereum'
  and '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48-ethereum' in unnest(token_ids)
  and '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2-ethereum' in unnest(token_ids)
order by created_at
limit 50

A pool enters this table when its factory emits the creation event, so the registry side counts every pool an app has ever created and the traded side counts the ones that saw a swap. protocol_id is the older name for app_id, so alias it to join the two.

with registry as (
    select
        protocol_id as app_id,
        count(*) as pools_in_registry
    from `dimensions.dex_pools`
    where chain_id = 'ethereum'
    group by app_id
),

traded as (
    select
        app_id,
        count(distinct dex_pool_id) as pools_traded
    from `metrics_dex_pools.trading_volume_daily`
    where chain_id = 'ethereum'
      and timestamp >= timestamp('2026-08-01')
      and timestamp < timestamp('2026-08-08')
    group by app_id
)

select
    app_id,
    registry.pools_in_registry,
    traded.pools_traded
from registry
left join traded
    using (app_id)
order by registry.pools_in_registry desc

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries