> ## 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" />


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