Skip to main content
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 NameData TypeDescription
chainVARCHARBlockchain where the supply change occurred
event_nameVARCHARName of the underlying event (e.g. Mint, Burn, Transfer)
is_mintBOOLEANTrue if the event increased total supply
is_burnBOOLEANTrue if the event decreased total supply
token_addressVARCHARContract address of the stablecoin token
token_nameVARCHARName of the stablecoin
token_symbolVARCHARSymbol of the stablecoin
raw_amount_strVARCHARMint/burn amount, unnormalized, as string for precision
raw_amountFLOATMint/burn amount, unnormalized
amount_strVARCHARMint/burn amount, normalized, as string for precision
amountFLOATMint/burn amount, normalized by token decimals
usd_amountFLOATMint/burn amount valued in USD at the time of the event
usd_exchange_rateFLOATExchange rate used for USD conversion
from_addressVARCHARfrom address of the event (zero address for mints)
to_addressVARCHARto address of the event (zero address for burns)
transaction_hashVARCHARHash of the transaction containing the supply change
block_timestampTIMESTAMP_NTZ(9)Block timestamp of the supply change
unique_idVARCHARUnique identifier for the supply change event
_created_atTIMESTAMP_NTZ(9)Timestamp when the row was first created
_updated_atTIMESTAMP_NTZ(9)Timestamp when the row was last updated