Supply Non-Circulating Daily

The hyperliquid.stablecoins.supply_non_circulating_daily view contains daily non-circulating supply (NCS) balances for Hyperliquid stablecoins. One row per (block_date, address, token_address, coin), with a row for every NCS holder on every calendar day.

Table Columns

Identifiers

Column Name	Description
chain	The blockchain network (`hyperliquid`).
address	NCS holder wallet address.
token_address	Hyperliquid numeric token index.
token_name	Full stablecoin name.
token_symbol	Stablecoin symbol.
token_decimals	Token decimal places.
product_id	Stablecoin product identifier (e.g. ‘usdc_hyperliquid’).
coin	Hyperliquid coin symbol.

NCS Classification

Column Name	Description
ncs_address_type	NCS category (e.g. ‘premint’, ‘issuer’).
ncs_address_label	Human-readable label for the NCS address.
ncs_supply_layer	Supply layer (‘issuer_basis’ or ‘all_layers’).

Balances

Column Name	Description
balance	NCS balance in decimal units.
balance_str	NCS balance as VARCHAR (full precision).
raw_balance	NCS raw balance (equals `balance` for Hyperliquid).
raw_balance_str	NCS raw balance as VARCHAR.
hold_balance	Held balance in decimal units.
hold_balance_str	Held balance as VARCHAR.
entry_ntl	Entry notional value.
entry_ntl_str	Entry notional value as VARCHAR.

Block & Lineage

Column Name	Description
block_date	Calendar date.
block_timestamp	Timestamp of the underlying snapshot.
block_number	Block number of the snapshot.
block_hash	Block hash of the snapshot.
_created_at	Row creation timestamp.
_updated_at	Row last update timestamp.

Sample Query

SELECT
  block_date,
  address,
  coin,
  balance,
  ncs_address_type,
  ncs_supply_layer
FROM hyperliquid.stablecoins.supply_non_circulating_daily
WHERE block_date >= CURRENT_DATE - 7
ORDER BY block_date DESC, balance DESC
LIMIT 100

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Identifiers

NCS Classification

Balances

Block & Lineage

Sample Query

​Table Columns

​Identifiers

​NCS Classification

​Balances

​Block & Lineage

​Sample Query

Table Columns

Identifiers

NCS Classification

Balances

Block & Lineage

Sample Query