Supply Non Circulating EOD

The Stablecoins Supply Non Circulating EOD table holds the upstream end-of-day per-address balances for the addresses excluded from circulating supply (pre-minted/unissued, bridge-locked, stablecoin-backed, permanently inaccessible). It feeds the daily roll-up in supply_non_circulating_daily and shares the same shape. See Supply Distribution Methodology on the stablecoins overview for the methodology.

Table Columns

Column Name	Data Type	Description
chain	VARCHAR	The blockchain the stablecoin resides on
address	VARCHAR	The non-circulating address holding the balance
token_address	VARCHAR	Contract address of the stablecoin token
token_name	VARCHAR	Name of the stablecoin
token_symbol	VARCHAR	Symbol of the stablecoin
token_decimals	INTEGER	Decimal precision of the stablecoin
product_id	VARCHAR	Allium stablecoin product identifier (e.g. usdc, usdt)
ncs_address_type	VARCHAR	Which methodology category the exclusion falls into: pre-minted/unissued, bridge-locked, stablecoin-backed, or permanently inaccessible
ncs_address_label	VARCHAR	Human-readable label for the address (e.g. issuer or bridge name)
ncs_supply_layer	VARCHAR	Which supply view this exclusion feeds into (`non_circulating_supply` vs. `adjusted_non_circulating_supply`)
raw_balance_str	VARCHAR	Balance, unnormalized, as string for precision
raw_balance	FLOAT	Balance, unnormalized
balance_str	VARCHAR	Balance, normalized, as string for precision
balance	FLOAT	Balance, normalized by token decimals
block_date	TIMESTAMP_NTZ(9)	The UTC date this end-of-day balance covers
block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp at which the balance was captured
block_number	INTEGER	Block number at which the balance was captured
block_hash	VARCHAR	Block hash at which the balance was captured
_has_error	INTEGER	Internal flag indicating whether balance retrieval encountered an error
_short_address	VARCHAR	Short (4-char) prefix of `address`, used for clustering
_short_token_address	VARCHAR	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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns