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).
Table Details
| Property | Value |
|---|---|
| Table Name | hyperliquid.stablecoins.supply_non_circulating_eod |
| Table Status | Production-Ready |
| Unique Key | block_date, address, token_address, coin |
| Clustering Key(s) | block_date, _short_address, _short_token_address, coin |
| Search Optimization | address, token_address, coin |
Table Columns
Identifiers
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR(16777216) | The blockchain the stablecoin resides on |
| address | VARCHAR(42) | The non-circulating address holding the balance |
| token_address | VARCHAR(16777216) | Contract address of the stablecoin token |
| token_name | VARCHAR(16777216) | Name of the stablecoin |
| token_symbol | VARCHAR(16777216) | Symbol of the stablecoin |
| token_decimals | NUMBER(38,0) | Decimal precision of the stablecoin |
| product_id | VARCHAR(16777216) | Allium stablecoin product identifier (e.g. usdc, usdt) |
| ncs_address_type | VARCHAR(16777216) | NCS category (e.g. ‘premint’, ‘issuer’). |
| ncs_address_label | VARCHAR(16777216) | Human-readable label for the NCS address. |
| ncs_supply_layer | VARCHAR(16777216) | Supply layer (‘issuer_basis’ or ‘all_layers’). |
| raw_balance_str | VARCHAR(16777216) | NCS raw balance as VARCHAR. |
| raw_balance | FLOAT | NCS raw balance (equals balance for Hyperliquid). |
| balance_str | VARCHAR(16777216) | NCS balance as VARCHAR (full precision). |
| balance | FLOAT | NCS balance in decimal units. |
| hold_balance_str | VARCHAR(16777216) | Held balance as VARCHAR. |
| hold_balance | FLOAT | Held balance in decimal units. |
| entry_ntl_str | VARCHAR(16777216) | Entry notional value as VARCHAR. |
| entry_ntl | FLOAT | Entry notional value. |
| coin | VARCHAR(16777216) | Hyperliquid coin symbol. |
| block_date | TIMESTAMP_NTZ(9) | Calendar date of the snapshot. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the underlying EOD snapshot. |
| block_number | NUMBER(38,0) | Block number of the snapshot. |
| block_hash | VARCHAR(16777216) | Block hash of the snapshot. |
| _has_error | NUMBER(38,0) | Internal flag indicating whether balance retrieval encountered an error |
| _short_address | VARCHAR(4) | Short (4-char) prefix of address, used for clustering |
| _short_token_address | VARCHAR(4) | Short (4-char) prefix of token_address, used for clustering |
| _ncs_seed_updated_at | TIMESTAMP_NTZ(9) | When the non-circulating-address seed list was last updated |
| _balances_created_at | TIMESTAMP_NTZ(9) | When the underlying balances entry was created |
| _created_at | TIMESTAMP_NTZ(9) | Row creation timestamp. |
| _updated_at | TIMESTAMP_NTZ(9) | Row last update timestamp. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |
NCS Classification
| Column Name | Description | |
|---|---|---|
| ncs_address_type | NCS category (e.g. ‘premint’, ‘issuer’). | Classification of an address in the NCS (Net Currency Supply) framework. Indicates whether the address is an issuer, smart contract, exchange, or user wallet. |
| ncs_address_label | Human-readable label for the NCS address. | Human-readable label for the address in the NCS framework (e.g. the name of an exchange, protocol, or issuer). |
| ncs_supply_layer | Supply layer (‘issuer_basis’ or ‘all_layers’). | Supply layer classification in the NCS framework. Indicates whether this balance is part of the circulating supply, non-circulating supply, or a specific custodial layer. |
Balances
| Column Name | Description | |
|---|---|---|
| balance | NCS balance in decimal units. | Token balance normalized by the token’s decimal precision (raw_balance / 10^decimals). Human-readable value (e.g. 1.5 USDC rather than 1500000). |
| balance_str | NCS balance as VARCHAR (full precision). | Normalized token balance stored as a string for full precision. Equivalent to balance but avoids floating-point truncation. |
| raw_balance | NCS raw balance (equals balance for Hyperliquid). | Token balance in the token’s smallest unit (not decimal-adjusted). Use balance for the human-readable normalized value. |
| raw_balance_str | NCS raw balance as VARCHAR. | Token balance in the smallest unit, stored as a string for full precision. Avoids floating-point truncation for tokens with very large integer balances. |
| hold_balance | Held balance in decimal units. | Held (locked) stablecoin balance — funds reserved for open orders or other protocol holds and not freely withdrawable. |
| hold_balance_str | Held balance as VARCHAR. | Held (locked) balance as string. |
| entry_ntl | Entry notional value. | The entry notional value. Set to ‘0’ when the row is a tombstone. |
| entry_ntl_str | Entry notional value as VARCHAR. | Entry notional value as string. |
Block & Lineage
| Column Name | Description | |
|---|---|---|
| block_date | Calendar date of the snapshot. | Calendar date (UTC) derived from block_timestamp. Used as a partition key in incremental models. |
| block_timestamp | Timestamp of the underlying EOD snapshot. | Timestamp (UTC) of the block that contains this record. |
| block_number | Block number of the snapshot. | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block. |
| block_hash | Block hash of the snapshot. | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| _created_at | Row creation timestamp. | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed. |
| _updated_at | Row last update timestamp. | Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration). |
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