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.

  • Use this website to convert the desired address https://ton.org/address/

• 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