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`.
`slug`	STRING	The project’s key in Token Terminal page URLs. It differs from `project_id` where the page URL is hyphenated (`redstone-chain` for `redstonechain`).
`url`	STRING	The project’s page on the Token Terminal Explorer.
`name`	STRING	Display name.
`symbol`	STRING	Ticker of the project’s token, where it has one.
`logo`	STRING	Public URL of the project logo, a PNG. Its `?logo_hash=` suffix changes whenever the image does. Null for a project whose image was never uploaded.
`description`	STRUCT	The project copy: `what` the project is, `who` it serves and `how` it works.
`links`	ARRAY<STRUCT>	The project’s links as `type` and `url` pairs (website, x, docs, github). `type` is the label as written, so `twitter` and `x` both occur.
`market_sectors`	ARRAY<STRING>	Every market sector the project belongs to, as tag ids, primary first. Unnesting it yields one row per sector.
`primary_market_sector`	STRING	The market sector the project is listed under: the first element of `market_sectors`. One value per row.
`listing_date`	TIMESTAMP	When the project was listed on Token Terminal.
`coingecko_id`	STRING	The project token’s CoinGecko id.
`coinmarketcap_id`	STRING	The project token’s CoinMarketCap id.

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.
`app_id`	`STRING`	The app operating the pool.
`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

Count the pools each app has created on each chain.

select
    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,
    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.

with registry as (
    select
        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