Assets
Ton Transfers
Assets
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 |