Saltar al contenido principal

Token Transfers

Table Metadata​

PropertyConfiguration
Natural Key(s)N/A
Partition Field(s)closed_at (DAY partition)
Clustered Field(s)contract_id, asset
Documentationdbt docs

Column Details​

NameDescriptionData TypeDomain ValuesRequired?Notes
transaction_hashA hex-encoded SHA-256 hash of this transaction's XDR-encoded form.STRINGYes
transaction_idA unique identifier for this transaction.INTEGERYes
operation_idA unique identifier for this transaction.INTEGERNo
event_topicThe action type applied to the token.STRINGYes
fromThe source address for the token transfer event amount.STRINGNo
toThe destination address for the token transfer event amount.STRINGNo
assetID field for the asset code/issuer pair. It is created by concatenating the asset code, ':' and asset_issuer fields.STRINGYes
asset_typeThe identifier for type of asset code, can be an alphanumeric with 4 characters, 12 characters or the native asset to the network (XLM).STRINGYes
asset_codeThe 4 or 12 character code representation of the asset on the network.STRINGNo
asset_issuerThe account address of the original asset issuer that created the asset.STRINGNo
amountThe normalized float amount of the asset.FLOATYes
amount_rawThe raw stroop amount of the asset.STRINGYes
contract_idSoroban contract id.STRINGYes
to_muxedThe multiplexed strkey representation of the to address.STRINGNo
to_muxed_idThe multiplexed ID used to generate the multiplexed strkey representation of the to address.STRINGNo
batch_idString representation of the run id for a given DAG in Airflow. Takes the form of "scheduled__<batch_end_date>-<dag_alias>". Batch ids are unique to the batch and help with monitoring and rerun capabilitiesstringYes
batch_run_dateThe start date for the batch interval. When taken with the date in the batch_id, the date represents the interval of ledgers processed. The batch run date can be seen as a proxy of closed_at for a ledger.datetimeYes
batch_insert_tsThe timestamp in UTC when a batch of records was inserted into the database. This field can help identify if a batch executed in real time or as part of a backfilltimestampYes
closed_atTimestamp in UTC when this ledger closed and committed to the network. Ledgers are expected to close ~every 5 secondstimestampYes
ledger_sequenceThe sequence number of this ledger. It represents the order of the ledger within the Stellar blockchain. Each ledger has a unique sequence number that increments with every new ledger, ensuring that ledgers are processed in the correct order.integerYes