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_daily view contains daily Non-Circulating Supply balances for Hyperliquid stablecoins. One row per (block_date, address, token_address, coin).

Table Columns

Column NameDescription
block_dateCalendar date.
addressNCS holder wallet address.
token_addressHyperliquid numeric token index.
coinHyperliquid coin symbol.
balanceNCS balance for the day.
raw_balanceNCS raw balance (equals balance for Hyperliquid).
ncs_supply_layerSupply layer (‘issuer_basis’ or ‘all_layers’).
ncs_address_typeNCS category label.

Sample Query

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