Supply Non Circulating Daily

The Stablecoins Supply Non Circulating Daily table itemizes the addresses excluded from circulating supply, classified into one of four methodology categories: pre-minted/unissued (issuer-held but not yet backed), bridge-locked (locked in bridge contracts on the source chain), stablecoin-backed (collateral locked to mint another tracked stablecoin), and permanently inaccessible (burn addresses and other unrecoverable contracts). Each row is one (date, chain, stablecoin, address) tuple with its daily closing balance and category. See Supply Distribution Methodology on the stablecoins overview for the full 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 balance snapshot 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
_ncs_eod_created_at	TIMESTAMP_NTZ(9)	When the upstream end-of-day non-circulating row was created

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns