Supply Change

stablecoins.core.supply_change records every event that increases (mint) or decreases (burn) the on-chain total supply of a tracked stablecoin across all supported chains. Use it to track issuance and redemption flows, measure net supply expansion or contraction, and observe issuer behavior at the event level.

Sample Query

Net supply change for USDC by chain over the last 30 days

select
    chain,
    token_address,
    token_name,
    token_symbol,
    product_id,
    sum(case when is_mint then amount else -amount end) as net_supply_change
from stablecoins.core.supply_change
where block_timestamp >= current_date - 30 and product_id = 'usdc'
group by all
order by net_supply_change desc

Table Columns

Unique Key: block_timestamp, chain, unique_id

Column Name	Data Type	Description
chain	VARCHAR	Blockchain where the supply change occurred
event_name	VARCHAR	Name of the underlying event (e.g. Mint, Burn, Transfer)
is_mint	BOOLEAN	True if the event increased total supply
is_burn	BOOLEAN	True if the event decreased total supply
token_address	VARCHAR	Contract address of the stablecoin token
token_name	VARCHAR	Name of the stablecoin
token_symbol	VARCHAR	Symbol of the stablecoin
raw_amount_str	VARCHAR	Mint/burn amount, unnormalized, as string for precision
raw_amount	FLOAT	Mint/burn amount, unnormalized
amount_str	VARCHAR	Mint/burn amount, normalized, as string for precision
amount	FLOAT	Mint/burn amount, normalized by token decimals
usd_amount	FLOAT	Mint/burn amount valued in USD at the time of the event
usd_exchange_rate	FLOAT	Exchange rate used for USD conversion
from_address	VARCHAR	`from` address of the event (zero address for mints)
to_address	VARCHAR	`to` address of the event (zero address for burns)
transaction_hash	VARCHAR	Hash of the transaction containing the supply change
block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp of the supply change
unique_id	VARCHAR	Unique identifier for the supply change event
_created_at	TIMESTAMP_NTZ(9)	Timestamp when the row was first created
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when the row was last updated

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Sample Query

Table Columns

​Sample Query

​Table Columns

Sample Query

Table Columns