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
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