Skip to main content

Table Details

PropertyValue
Table Namestellar.rwa.transfers
Table StatusProduction-Ready
Unique Keyledger_date, unique_id
Clustering Key(s)ledger_close_time::date, asset_id

Table Columns

Column NameData TypeDescription
chainVARCHAR(16777216)Blockchain this record belongs to; always stellar.
token_typeVARCHAR(16777216)Token standard of the asset (Stellar classic asset or Soroban contract token).
asset_idVARCHAR(16777216)Canonical asset identifier in CODE:ISSUER form.
asset_codeVARCHAR(16777216)Asset code of the classic Stellar asset.
asset_issuerVARCHAR(16777216)Issuer G-address of the classic Stellar asset.
token_nameVARCHAR(16777216)Full name of the RWA token.
token_symbolVARCHAR(16777216)Ticker symbol of the RWA token.
decimalsNUMBER(38,0)Number of decimal places used to normalize the token’s raw amounts.
raw_amount_strVARCHAR(16777216)Transfer amount in the smallest unit, stored as a string for full precision.
raw_amountFLOATTransfer amount in the token’s smallest unit (not decimal-adjusted).
amount_strVARCHAR(16777216)Normalized transfer amount stored as a string for full precision.
amountFLOATTransfer amount normalized by the token’s decimal precision (raw_amount / 10^decimals).
usd_amountFLOATUSD value of the transferred amount at the time of the transfer.
usd_exchange_rateFLOATUSD price per unit of the token used to compute usd_amount.
from_addressVARCHAR(16777216)Stellar address that sent the tokens (balance decreased).
from_muxed_idVARCHAR(16777216)64-bit muxed sub-account id of the sender, when the source is a muxed account.
to_addressVARCHAR(16777216)Stellar address that received the tokens (balance increased).
to_muxed_idVARCHAR(16777216)64-bit muxed sub-account id of the recipient, when the destination is a muxed account.
contract_idVARCHAR(16777216)Soroban token contract id, for contract-based token transfers.
event_typeVARCHAR(16777216)Type of transfer event that produced this record.
event_stageVARCHAR(16777216)Stage of the transfer event within transaction processing.
event_indexNUMBER(38,0)Index of this event within its transaction.
is_mintBOOLEANWhether this transfer is a token issuance (mint).
is_burnBOOLEANWhether this transfer is a token redemption (burn).
transaction_hashVARCHAR(16777216)Hash of the transaction that produced this transfer.
transaction_indexVARCHAR(16777216)Position of the transaction within its 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.
ledger_close_timeTIMESTAMP_NTZ(9)Close time of the ledger containing this transfer.
ledger_dateDATECalendar date of the ledger containing this transfer.
ledger_sequenceNUMBER(38,0)Sequence number of the ledger containing this transfer.
ledger_hashVARCHAR(16777216)Hash of the ledger containing this transfer.
unique_idVARCHAR(16777216)Deterministic unique identifier for this row.
_rwa_token_created_atTIMESTAMP_NTZ(9)Internal pipeline timestamp: when this token was added to the RWA registry.
_transfers_created_atTIMESTAMP_NTZ(9)Internal pipeline timestamp: when the underlying transfer record was created.
_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.