Registry

Market identity lives in two registry tables.

dimensions.perp_markets: one row per perpetual futures market.
dimensions.order_book_markets: one row per order-book market that has traded, covering spot books and outcome markets.

Tables

Perpetual futures
Order-book markets

A perpetual future is a contract that tracks the price of something without ever expiring: nobody holds the thing itself, and traders settle up in a token instead. dimensions.perp_markets says who runs each market and what it tracks. base_reference_asset_id names the thing whose price the market follows. quote_asset_id names the token positions settle in.Each market credits two apps. exchange_app_id is the venue that matches buyers with sellers and settles the trades. interface_app_id is whoever built the front end the trades came through; on the venue’s own markets the two read the same. Notional volume, the total value of the contracts traded rather than cash changing hands, is published under both, in two separate columns. Each column is a complete account of the same trades, so adding them counts every trade twice.

Column	Type	Description
`perp_market_id`	`STRING`	Identifier of the market.
`project_id`	`STRING`	Project the exchange app belongs to.
`interface_app_id`	`STRING`	The app whose front end the trades came through.
`chain_id`	`STRING`	Chain the market settles on.
`exchange_app_id`	`STRING`	The venue that matches buyers with sellers.
`quote_asset_id`	`STRING`	The token positions settle in, keyed like `dimensions.assets`.
`base_reference_asset_id`	`STRING`	The thing whose price the market follows, keyed like `dimensions.reference_assets`.
`name`	`STRING`	Readable market name, for example `BTC Perpetual`.
`status`	`STRING`	Whether the market is still listed: `active` for every current row.

An order-book market is an ordinary market where the token itself changes hands, matched through a book of buy and sell orders. dimensions.order_book_markets is built from the markets that have traded rather than written out market by market, so nothing that traded is missing. app_id names the single app running the book.quote_asset_id is what lets us report volume in dollars without looking a price up. Every quote token we accept is a stablecoin worth about a dollar, so the size of a trade times its price is already its dollar value. The accepted list is short by design: usdc, usdh, usdt0 and usde. A market quoted in anything else is held back rather than reported in dollars.

Column	Type	Description
`order_book_market_id`	`STRING`	Identifier of the market.
`project_id`	`STRING`	Project the operating app belongs to.
`app_id`	`STRING`	The app running the book.
`chain_id`	`STRING`	Chain the book settles on.
`quote_asset_id`	`STRING`	The token volume is measured in, keyed like `dimensions.assets`.
`base_symbol`	`STRING`	Symbol of the traded token.
`name`	`STRING`	Readable pair name, for example `HYPE/USDC`.
`created_at`	`TIMESTAMP`	When we first saw the market trade.

Sample queries

Markets per interface app
Markets per app and quote asset

Count markets per interface app.

select
    interface_app_id,
    count(*) as markets
from `dimensions.perp_markets`
group by interface_app_id
order by markets desc

Count markets per app and quote asset.

select
    app_id,
    quote_asset_id,
    count(*) as markets
from `dimensions.order_book_markets`
group by app_id, quote_asset_id
order by markets desc

Notes

A perpetual market points at a reference asset, because it only follows a price and never holds a token. An order-book market names its traded token by symbol alone. Symbols are not unique, several contracts can share one, so the table states base_symbol and stops there rather than guessing which contract is meant.

Overview

Core entities

Market verticals

Chain verticals

Tables

Sample queries

Notes

​Tables

​Sample queries

​Notes

Tables

Sample queries

Notes