> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ton.accounts

> TON account data — wallet addresses, contract types, balances, and status.

## Table Description

The `ton.accounts` table contains all updates of accounts. Including updates of balance and code\_hash.
This table is created using [this SQL](https://github.com/duneanalytics/spellbook/blob/main/dbt_subprojects/daily_spellbook/models/ton/ton_accounts.sql).

## Column Descriptions

| **Column**                     | **type**                    | **Description**                                                                                                                                                                                                  |
| ------------------------------ | --------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **address**                    | varchar                     | Account raw address                                                                                                                                                                                              |
| **status**                     | varchar                     | Status of account                                                                                                                                                                                                |
| **last\_tx\_hash**             | varchar                     | Hash of the latest transaction                                                                                                                                                                                   |
| **last\_tx\_at**               | timestamp(3) with time zone | timetsmap of the latest transaction                                                                                                                                                                              |
| **balance**                    | bigint                      | Raw ton balance                                                                                                                                                                                                  |
| **code\_hash**                 | varchar                     | Account code hash (on-chain value)                                                                                                                                                                               |
| **deployment\_tx\_hash**       | varchar                     | Hash of transaction when account was deployed                                                                                                                                                                    |
| **deployment\_at**             | timestamp(3) with time zone | Timestamp when account was deployed                                                                                                                                                                              |
| **deployment\_by\_external**   | boolean                     | Equals true when deployment of transactions was first transaction in trace, in other words when `(deployment tx_hash = deployment trace_id)`, false otherwise                                                    |
| **initial\_funding\_tx\_hash** | varchar                     | Transaction hash with the first occur of account in transactions                                                                                                                                                 |
| **initial\_funding\_at**       | timestamp(3) with time zone | Timestamp of the first occur of account in transactions                                                                                                                                                          |
| **first\_tx\_sender**          | varchar                     | Raw address of who intiated the first transaction with this account                                                                                                                                              |
| **interfaces**                 | array(varchar)              | The list of known available interfaces (for example `wallet_v4r2`, [full list available here](https://github.com/duneanalytics/spellbook/blob/main/dbt_subprojects/daily_spellbook/models/ton/ton_accounts.sql)) |

## Table Sample

Table sample can be found [here](https://dune.com/queries/3419983/5785629?table_name_t6f0df=accounts\&table_schema_t6f0df=ton).