Registry

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

Tables

Projects
Apps
Perp markets
Order book markets

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 perpetual futures market. Each market credits two apps, the venue that settles its trades and the interface it is listed under.

Column	Type	Description
`perp_market_id`	`STRING`	Identifier of the market: the registered market key joined with the chain on HyperCore; `{pool_address}:{asset_index}-{chain_id}` on MUX.
`project_id`	`STRING`	Project the exchange app belongs to.
`interface_app_id`	`STRING`	The builder credited for the market. Every fill in the market has this one value, and a market’s whole volume lands under one interface app.
`chain_id`	`STRING`	Chain the market settles on.
`exchange_app_id`	`STRING`	The venue that settles the trades. It matches `interface_app_id` on a venue’s own markets and differs on a builder-deployed HIP-3 market, where the engine is `hyperliquid-perps` and the interface is the listing builder.
`quote_asset_id`	`STRING`	The token positions settle in, keyed like `dimensions.assets`. Null on MUX markets, which accept several collateral tokens and price in USD.
`base_reference_asset_id`	`STRING`	The reference asset whose price the market follows, keyed like `dimensions.reference_assets`. Null where the market’s asset has no reference-asset mapping.
`name`	`STRING`	Readable market name, for example `BTC Perpetual`.
`status`	`STRING`	Listing status from the market registry, such as `active`. Null for markets identified from executions.

One row per order-book market that has traded, covering spot books and outcome markets. An order-book market runs under a single app, and has one credit column where a perpetual market has a pair.

Column	Type	Description
`order_book_market_id`	`STRING`	Identifier of the market: the venue’s book identifier joined with the chain.
`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`. Every accepted quote token is a dollar stablecoin (`usdc`, `usdh`, `usdt0`, `usde`), so a trade’s size times its price is already its dollar value.
`base_symbol`	`STRING`	Symbol of the traded token, as the venue lists it. Several contracts can share one symbol.
`name`	`STRING`	Readable pair name, for example `HYPE/USDC`.
`created_at`	`TIMESTAMP`	Time of the first trade seen in the market, which is what puts the row in this table.

Sample queries

Markets per interface app
Builder-deployed markets
Order books per app and quote asset
Pool markets by chain

interface_app_id is the builder a market is listed under, and on a venue’s own markets it holds the same value as exchange_app_id.

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

A HIP-3 market is one where the matching engine and the listing builder are different apps. Compare exchange_app_id against interface_app_id.

select
    perp_market_id,
    name,
    exchange_app_id,
    interface_app_id,
    base_reference_asset_id
from `dimensions.perp_markets`
where exchange_app_id != interface_app_id
order by interface_app_id, perp_market_id

quote_asset_id is the token the book prices in, and every accepted one is a dollar stablecoin, so grouping by it splits the books by settlement currency.

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

MUX market identifiers combine the pool address, asset index and settlement chain. A market can accept several collateral tokens, and its reference asset identifies what its price follows.

select
    perp_market_id,
    chain_id,
    name,
    base_reference_asset_id,
    quote_asset_id
from `dimensions.perp_markets`
where exchange_app_id = 'mux-perps'
order by chain_id, perp_market_id

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries