Skip to main content

Table Details

PropertyValue
Table Namestellar.assets.stablecoin_transfers
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
event_typeVARCHAR(16777216)Type of the transfer event that produced this record.
event_stageVARCHAR(16777216)Stage at which the event was emitted (e.g. during_tx, after_tx).
event_indexNUMBER(38,0)Zero-based index of this event within its transaction.
from_addressVARCHAR(16777216)Stellar account (G-address) the transfer was sent from.
from_muxed_idVARCHAR(16777216)64-bit muxed sub-account id of the sender, when a muxed account is used.
to_addressVARCHAR(16777216)Stellar account (G-address) the transfer was sent to.
to_muxed_idVARCHAR(16777216)64-bit muxed sub-account id of the recipient, when a muxed account is used.
contract_idVARCHAR(16777216)Soroban contract identifier (C-address) for the asset, when applicable.
asset_idVARCHAR(16777216)Composite asset identifier in issuer:code form for Classic assets.
asset_codeVARCHAR(16777216)Asset code for the Classic asset.
asset_issuerVARCHAR(16777216)Issuer G-address of the Classic asset.
token_idVARCHAR(16777216)Soroban token identifier.
raw_amount_strVARCHAR(16777216)Amount in stroops (unnormalized integer), stored as a string for full precision.
raw_amountFLOATAmount in stroops (unnormalized), not decimal-adjusted.
amount_strVARCHAR(16777216)Normalized amount stored as a string for full precision.
amountFLOATAmount normalized by the asset’s decimal precision (raw_amount / 10^decimals).
usd_amountFLOATUSD value of the amount at the time of the event.
decimalsNUMBER(38,0)Number of decimal places for this stablecoin.
usd_exchange_rateVARCHAR(16777216)USD price per unit of the asset, used to compute usd_amount.
ledger_sequenceNUMBER(38,0)Stellar ledger sequence number (ledger height).
ledger_close_timeTIMESTAMP_NTZ(9)Timestamp (UTC) when the Stellar ledger closed and was validated by the network.
ledger_hashVARCHAR(16777216)Hash of the Stellar ledger.
transaction_hashVARCHAR(16777216)Hash of the transaction that produced this transfer.
transaction_indexVARCHAR(16777216)Zero-based position of the transaction within its ledger.
transaction_resultVARCHAR(16777216)Stellar transaction result code.
transaction_successfulVARCHAR(16777216)True if the transaction was included in a ledger and executed without errors.
operation_indexVARCHAR(16777216)Operation index within the transaction.
unique_idVARCHAR(16777216)Allium’s deterministic unique identifier for this row.
currencyVARCHAR(16777216)Stablecoin currency code the token is pegged to (e.g. USDC).
base_assetVARCHAR(16777216)Underlying asset the stablecoin represents.
is_bridgeBOOLEANTrue if this transfer is a bridge mint or burn.
_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_created_atTIMESTAMP_LTZ(9)Timestamp when the stablecoin metadata record was first created.
_metadata_updated_atTIMESTAMP_LTZ(9)Timestamp when the stablecoin metadata record was last updated.
_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.
_changed_since_full_refreshBOOLEANIndicates if the record has changed since the last full data refresh.