Registry - Token Terminal Docs

The identity table behind every project figure. Every fact and metric joins to it, and Coverage introduces the grain.

Columns

Column	Type	Description
`project_id`	`STRING`	Identifier of the project. Every table that mentions a project joins on this.
`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 one exists.
`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.
`archived_at`	`TIMESTAMP`	When Token Terminal stopped updating the project’s metrics. Null while they are live.
`archived_reason`	`STRING`	The notice shown with `archived_at`. Null while the project’s metrics are live.
`coingecko_id`	`STRING`	The project token’s CoinGecko id.
`coinmarketcap_id`	`STRING`	The project token’s CoinMarketCap id.

Sample queries

Project identity
Projects by sector
Projects in a sector
Projects with several apps

project_id is the key every project table joins on, and primary_market_sector is the sector the project is listed under.

select
    project_id,
    name,
    symbol,
    url,
    logo,
    primary_market_sector,
    listing_date
from `dimensions.projects`
where project_id = 'uniswap'

primary_market_sector holds one value per project, and every project appears in exactly one group.

select
    primary_market_sector,
    count(*) as projects
from `dimensions.projects`
group by primary_market_sector
order by projects desc

market_sectors answers membership, including projects listed under another sector. Aave is listed under lending and appears here as a stablecoin issuer.

select
    project_id,
    name,
    primary_market_sector,
    market_sectors
from `dimensions.projects`
where 'stablecoin-issuers' in unnest(market_sectors)
order by project_id

A project with several apps has one row here and several in dimensions.apps, so the count comes from a join.

select
    projects.project_id,
    projects.name,
    count(*) as apps
from `dimensions.projects` as projects
join `dimensions.apps` as apps
    using (project_id)
group by projects.project_id, projects.name
having count(*) > 1
order by apps desc, projects.project_id