> ## 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).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.