Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.allium.so/llms.txt

Use this file to discover all available pages before exploring further.

The hyperliquid.stablecoins.ncs_eod table contains end-of-day Non-Circulating Supply (NCS) balances for Hyperliquid stablecoins. One row per (block_date, address, token_address, coin) for known NCS holders such as premint and issuer addresses.

​
Table Columns

Column NameDescription
block_dateCalendar date of the snapshot.
addressNCS holder wallet address.
token_addressHyperliquid numeric token index.
coinHyperliquid coin symbol for this balance row.
raw_balanceNCS balance (same as balance for Hyperliquid).
balanceNCS balance in human-readable decimal units.
ncs_address_typeNCS category (e.g. ‘premint’).
ncs_address_labelHuman-readable label for the NCS address.
ncs_supply_layerSupply layer (‘issuer_basis’ or ‘all_layers’).
block_timestampTimestamp of the underlying EOD 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.ncs_eod
WHERE block_date >= CURRENT_DATE - 7
ORDER BY block_date DESC, balance DESC
LIMIT 100