Skip to main content
The hyperliquid.stablecoins.supply_non_circulating_eod table contains end-of-day non-circulating supply (NCS) balances for Hyperliquid stablecoins. One row per (block_date, address, token_address, coin) for addresses that count as non-circulating (e.g. premint reserves and issuer addresses), sourced from marts_hyperliquid_stablecoins__spot_balances_eod.

​
Table Columns

​
Identifiers

Column NameDescription
chainAlways ‘hyperliquid’.
addressNCS holder wallet address.
token_addressHyperliquid numeric token index.
token_nameFull stablecoin name.
token_symbolStablecoin symbol.
token_decimalsToken decimal places.
product_idStablecoin product identifier (e.g. ‘usdc_hyperliquid’).
coinHyperliquid coin symbol.

​
NCS Classification

Column NameDescription
ncs_address_typeNCS category (e.g. ‘premint’, ‘issuer’).
ncs_address_labelHuman-readable label for the NCS address.
ncs_supply_layerSupply layer (‘issuer_basis’ or ‘all_layers’).

​
Balances

Column NameDescription
balanceNCS balance in decimal units.
balance_strNCS balance as VARCHAR (full precision).
raw_balanceNCS raw balance (equals balance for Hyperliquid).
raw_balance_strNCS raw balance as VARCHAR.
hold_balanceHeld balance in decimal units.
hold_balance_strHeld balance as VARCHAR.
entry_ntlEntry notional value.
entry_ntl_strEntry notional value as VARCHAR.

​
Block & Lineage

Column NameDescription
block_dateCalendar date of the snapshot.
block_timestampTimestamp of the underlying EOD snapshot.
block_numberBlock number of the snapshot.
block_hashBlock hash of the snapshot.
_created_atRow creation timestamp.
_updated_atRow last update timestamp.

​
Sample Query

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