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

# stellar.accounts

> Stellar account data — public keys, sequence numbers, balances, and thresholds.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

## Table description

The `stellar.accounts` table tracks the native token (Lumens) balances held by accounts.

Accounts are the central data structure in Stellar- they hold balances, sign transactions, and issue assets. Accounts can only exist with a valid keypair and the required minimum balance of XLM.

## Column Descriptions

| **Column**                                    | **Description**                                                                              | **Type**                    |
| --------------------------------------------- | -------------------------------------------------------------------------------------------- | --------------------------- |
| **closed\_at\_date**                          | The date when the account's ledger entry was closed.                                         | date                        |
| **account\_id**                               | The unique identifier for the Stellar account.                                               | varchar                     |
| **balance**                                   | The current balance of lumens (XLM) in the account.                                          | double                      |
| **buying\_liabilities**                       | The total liabilities for buying offers on the account.                                      | double                      |
| **selling\_liabilities**                      | The total liabilities for selling offers on the account.                                     | double                      |
| **sequence\_number**                          | The current sequence number of the account, incremented with each transaction.               | bigint                      |
| **num\_subentries**                           | The number of subentries, such as trustlines or offers, associated with the account.         | bigint                      |
| **inflation\_destination**                    | The destination account for inflation pools (deprecated feature).                            | varchar                     |
| **flags**                                     | A set of flags representing various account properties like authorization.                   | bigint                      |
| **home\_domain**                              | The home domain associated with the account, used for federation or verifying asset issuers. | varchar                     |
| **master\_weight**                            | The weight of the account's master key used for signing transactions.                        | bigint                      |
| **threshold\_low**                            | The threshold level required for low-priority operations (e.g., payments).                   | bigint                      |
| **threshold\_medium**                         | The threshold level required for medium-priority operations (e.g., trustlines).              | bigint                      |
| **threshold\_high**                           | The threshold level required for high-priority operations (e.g., multisig transactions).     | bigint                      |
| **last\_modified\_ledger**                    | The ledger sequence number where the account was last modified.                              | bigint                      |
| **ledger\_entry\_change**                     | Indicates the type of change made to the ledger entry (insert, update, delete).              | bigint                      |
| **deleted**                                   | A boolean indicating whether the account has been deleted from the ledger.                   | boolean                     |
| **sponsor**                                   | The account that is sponsoring this account’s resources.                                     | varchar                     |
| **num\_sponsored**                            | The number of subentries sponsored by this account.                                          | bigint                      |
| **num\_sponsoring**                           | The number of subentries this account is sponsoring.                                         | bigint                      |
| **sequence\_time**                            | The time when the sequence number was last updated.                                          | timestamp(3) with time zone |
| **closed\_at**                                | The timestamp when the account was last closed.                                              | timestamp(3) with time zone |
| **ledger\_sequence**                          | The sequence number of the ledger in which the account is included.                          | bigint                      |
| **account\_sequence\_last\_modified\_ledger** | The last ledger sequence where the account's sequence number was modified.                   | bigint                      |
| **updated\_at**                               | The time when the account record was last updated.                                           | timestamp(3) with time zone |
| **ingested\_at**                              | The time when the account data was ingested into the system.                                 | timestamp(3) with time zone |

## Table Sample

<TableSample tableSchema="stellar" tableName="accounts" />