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