Skip to main content

Table Details

PropertyValue
Table Namestellar.raw.token_transfers
Table StatusProduction-Ready
Unique Keyledger_close_time, unique_id
Clustering Key(s)to_date("ledger_close_time")
Search Optimizationfrom_address, to_address, transaction_hash, contract_id, asset_id

Table Columns

Column NameData TypeDescription
event_typeVARCHAR(16777216)Type of token-transfer event (e.g. transfer, mint, burn, clawback).
event_stageVARCHAR(16777216)Stage at which the event was emitted (e.g. during_tx, after_tx).
event_indexNUMBER(38,0)Index of this event within its transaction.
from_addressVARCHAR(16777216)Address whose balance decreased in this transfer.
from_muxed_idVARCHAR(16777216)64-bit sub-account id of the sender’s multiplexed account, if used.
to_addressVARCHAR(16777216)Address whose balance increased in this transfer.
to_muxed_idVARCHAR(16777216)64-bit sub-account id of the recipient’s multiplexed account, if used.
contract_idVARCHAR(16777216)Soroban contract address of the token, for contract-based assets.
asset_idVARCHAR(16777216)Composite code:issuer identifier of the asset for non-native assets.
asset_codeVARCHAR(16777216)Asset code for a classic asset.
asset_issuerVARCHAR(16777216)Issuer G-address for a classic asset.
token_idNUMBER(38,0)Identifier of the Soroban token for contract-based assets.
amount_strVARCHAR(16777216)Transfer amount in the token’s smallest unit, stored as a string for full precision.
amountNUMBER(38,0)Transfer amount in the token’s smallest unit (stroops for classic assets).
ledger_sequenceNUMBER(38,0)Sequence number of the ledger containing this transfer.
ledger_close_timeTIMESTAMP_NTZ(9)Time when the ledger containing this transfer closed and was finalized.
ledger_hashVARCHAR(16777216)Hash of the ledger containing this transfer.
transaction_hashVARCHAR(16777216)Hash of the transaction that produced this transfer.
transaction_indexNUMBER(38,0)Position of the transaction within its ledger.
transaction_resultVARCHAR(16777216)Result code of the transaction that produced this transfer.
transaction_successfulBOOLEANTrue if the transaction that produced this transfer executed successfully.
operation_indexNUMBER(38,0)Index of the operation within the transaction that produced this transfer.
unique_idVARCHAR(16777216)Deterministic unique identifier for this row.
_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.