Ton Transfers

(Beta) The ton.assets.ton_transfers table includes transfers of TON from messages (and internal transfers) as well as TON consumed from transaction fees.

This table is in Beta

  • There may be unaccounted edge cases involving Ton transfers

All address fields used in this table will be in Hex format and upper casing

  • There are up to 5 equivalent addresses for a given address on Ton.

  • Example of Hex address: 0:B113A994B5024A16719F69139328EB759596C38A25F59028B146FECDC3621DFE

Table Columns

Unique Key: unique_id

Column Name
Description

from_address

The address of the sender of the TON transfer

to_address

The address of the recipient of the TON transfer

token_address

The address of the token contract (always '0' for native TON)

token_name

The name of the token (always 'Toncoin' for native TON)

token_symbol

The symbol of the token (always 'TON' for native TON)

raw_amount_str

The raw transfer amount as a string to retain precision

raw_amount

The raw transfer amount as a float

amount_str

The normalized transfer amount as a string (9 decimal places), in string format to retain precision

amount

The normalized transfer amount as a float

usd_amount

The USD value of the transfer at the hour of the transaction

usd_exchange_rate

The USD/TON exchange rate at the time of the transaction

transfer_type

The type of transfer, can be fees or value_transfer

opcode

The operation code associated with the transfer

utime

The timestamp of the transfer

transaction_hash

The hash of the transaction containing this transfer

message_hash

The hash of the message associated with this transfer

transaction_index

The index of the transaction within the block

message_index

The index of the message within the transaction

seqno

The sequence number of the transaction

shard

The shard identifier for this transaction

workchain

The workchain identifier for this transaction

unique_id

A unique identifier for this transfer

block_timestamp

The timestamp of the block containing this transfer

created_at

Timestamp when this record was created

updated_at

Timestamp when this record was last updated

Last updated