Skip to main content

Table Details

PropertyValue
Table Namestellar.stablecoins.supply_change
Table StatusProduction-Ready
Unique Keyledger_close_time::date, unique_id
Clustering Key(s)ledger_close_time::date, asset_id
Search Optimizationasset_id, asset_code

Table Columns

Column NameData TypeDescription
currencyVARCHAR(16777216)Stablecoin currency code the asset represents (e.g. USDC).
event_typeVARCHAR(16777216)Type or category of the onchain event that produced this record.
event_stageVARCHAR(16777216)Stage of the transaction at which the event fired (e.g. during_tx, after_tx).
event_indexNUMBER(38,0)Zero-based index of this event within its transaction.
from_addressVARCHAR(16777216)Address the supply change moved from; a G… or C… address.
from_muxed_idVARCHAR(16777216)64-bit muxed sub-account id of the sender, if applicable.
to_addressVARCHAR(16777216)Address the supply change moved to; a G… or C… address.
to_muxed_idVARCHAR(16777216)64-bit muxed sub-account id of the recipient, if applicable.
contract_idVARCHAR(16777216)Soroban contract (C…) address for Soroban-token supply changes.
asset_idVARCHAR(16777216)Canonical CODE:ISSUER identifier of the classic asset.
asset_codeVARCHAR(16777216)Asset code of the classic asset.
asset_issuerVARCHAR(16777216)Issuer G-address of the classic asset.
token_idVARCHAR(16777216)Soroban token id, for tokens represented as Soroban contracts.
raw_amount_strVARCHAR(16777216)Supply-change amount in the token’s smallest unit, as a string.
raw_amountFLOATSupply-change amount in the token’s smallest unit, not decimal-adjusted.
usd_amountFLOATUSD value of the supply change at the time of the event.
decimalsNUMBER(38,0)Number of decimal places for this token.
usd_exchange_rateFLOATUSD price per unit of the token used to compute usd_amount.
ledger_sequenceNUMBER(38,0)Stellar ledger sequence number.
ledger_close_timeTIMESTAMP_NTZ(9)Timestamp (UTC) when the Stellar ledger closed.
ledger_hashVARCHAR(16777216)Hash of the Stellar ledger containing this record.
transaction_hashVARCHAR(16777216)Hash of the transaction that produced this record.
transaction_indexVARCHAR(16777216)Index of the transaction within the ledger.
transaction_resultVARCHAR(16777216)Stellar transaction result code.
transaction_successfulVARCHAR(16777216)Whether the transaction executed successfully.
operation_indexVARCHAR(16777216)Index of the operation within the transaction.
unique_idVARCHAR(16777216)Allium’s deterministic unique identifier for this row.
_transfer_created_atTIMESTAMP_NTZ(9)Timestamp when the underlying transfer record was first ingested.
_transfer_updated_atTIMESTAMP_NTZ(9)Timestamp when the underlying transfer record was last updated.
_metadata_updated_atTIMESTAMP_NTZ(9)Timestamp when the stablecoin metadata was last updated.
_changed_since_full_refreshBOOLEANIndicates if the record has changed since the last full data refresh.
amount_strVARCHAR(16777216)Normalized supply-change amount as a string for full precision.
amountFLOATSupply-change amount normalized by the token’s decimal precision.
event_nameVARCHAR(16777216)Name of the onchain event that triggered this record.
is_mintBOOLEANTrue if this event is a mint (issuance).
is_burnBOOLEANTrue if this event is a burn (redemption).
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.
product_idVARCHAR(16777216)Internal Allium identifier for the stablecoin product.
is_nativeBOOLEANTrue if the stablecoin is issued natively on Stellar, not bridged.
stablecoin_typeVARCHAR(16777216)Classification of the stablecoin mechanism.