# RPCX Live Tables

> The nine RPCX live tables: the latest Solana transactions, instructions, logs, balance changes, and blocks, and the current state of accounts and token holdings, read in bulk.

Canonical: https://nolimitnodes.com/docs/api-reference/rpcx/tables

A method reads nine live tables. RPCX reads their rows from NoLimitNodes' own nodes when the method runs. Seven chain tables hold the latest Solana data, up to the newest blocks. Two state tables hold the current state of accounts. Older history is not available.

| Table | One row is | Read by |
|---|---|---|
| [`live_signatures`](#live_signatures) | A transaction: signature, status, memo | `address`, `sig`, or a range |
| [`live_transactions`](#live_transactions) | A transaction, with fee, signer, accounts, programs, and logs | `address`, `sig`, or a range |
| [`live_instructions`](#live_instructions) | An instruction, inner instructions included | `address`, `program`, `sig`, or a range |
| [`live_logs`](#live_logs) | A program log line | `address`, `sig`, or a range |
| [`live_sol_balance_changes`](#live_sol_balance_changes) | An account whose SOL balance changed in a transaction | `address`, `sig`, or a range |
| [`live_token_balance_changes`](#live_token_balance_changes) | A token account whose balance changed in a transaction | `address`, `sig`, or a range |
| [`live_blocks`](#live_blocks) | A block | A range only |
| [`live_accounts`](#live_accounts) | An account as it is now | `address` |
| [`live_token_accounts`](#live_token_accounts) | A token account a wallet holds now | `owner` |

You read a live table like any other table. Every step works the same: `filter`, `derive`, `group`, `join` with other live tables, `sort`, and `take`.

## Keys and ranges

Every read of a live table needs a filter that tells RPCX what to read. Put it in the `filter` right after `from`. Other conditions can join it with `&&`. A key or range under `||` or `!`, or in a later step, does not count, and **Validate** refuses the method with `live_key_missing`.

The filter is one of these:

- **A key.** `address == ` finds the transactions that touch the address. `address` is any address: a wallet, a program, a pool, a mint, or a token account. `sig == ` finds one transaction. On `live_instructions`, `program == ` finds the instructions of that program. On `live_accounts` the key is `address`, and on `live_token_accounts` it is `owner`. A key can also be `in` a list param or a literal list: `(address | in wallets)`.
- **A bounded range**, on a chain table: a lower and an upper bound on `ts` or `slot`, such as `ts >= from && ts = start && slot = from && ts = from && ts ` to keep only that account.

| Column | Type | Description |
|---|---|---|
| `address` | `String` | The address the row was found by (the value of your address filter). Empty when read by sig, program or a time/slot range. |
| `sig` | `String` | Transaction signature (base58). |
| `slot` | `UInt64` | Slot of the transaction. |
| `ts` | `DateTime64(3, 'UTC')` | Block time of the transaction (UTC). |
| `success` | `Bool` | `true` when the transaction succeeded, `false` when it failed. |
| `account` | `String` | The account whose SOL balance changed. |
| `pre` | `UInt64` | Balance before the transaction, in lamports. |
| `post` | `UInt64` | Balance after the transaction, in lamports. |
| `change` | `Int64` | `post - pre`, in lamports. The fee is included for the fee payer. |

### `live_token_balance_changes`

One row per token account whose balance changed in a transaction. Read by `address`, `sig`, or a range. Add `owner == ` or `mint == ` to narrow.

| Column | Type | Description |
|---|---|---|
| `address` | `String` | The address the row was found by (the value of your address filter). Empty when read by sig, program or a time/slot range. |
| `sig` | `String` | Transaction signature (base58). |
| `slot` | `UInt64` | Slot of the transaction. |
| `ts` | `DateTime64(3, 'UTC')` | Block time of the transaction (UTC). |
| `success` | `Bool` | `true` when the transaction succeeded, `false` when it failed. |
| `token_account` | `String` | The token account whose balance changed. |
| `owner` | `String` | Owner of the token account. |
| `mint` | `String` | Token mint. |
| `decimals` | `UInt8` | Decimals of the mint. |
| `pre_amount` | `UInt64` | Balance before, in base units (0 when the account was created). |
| `post_amount` | `UInt64` | Balance after, in base units (0 when the account was closed). |
| `change` | `Int128` | `post_amount - pre_amount`, in base units. |

### `live_blocks`

One row per block. Read by a `ts` or `slot` range only. It has no key.

| Column | Type | Description |
|---|---|---|
| `slot` | `UInt64` | Slot of the block. |
| `ts` | `DateTime64(3, 'UTC')` | Block time (UTC). |
| `blockhash` | `String` | Block hash (base58). |
| `parent_slot` | `UInt64` | Slot of the parent block. |
| `block_height` | `UInt64` | Block height. |
| `tx_count` | `UInt64` | Number of transactions in the block. |

### `live_accounts`

The current state of each account. Read by `address`. One row per address that exists. Not a history.

| Column | Type | Description |
|---|---|---|
| `address` | `String` | The account address (the value of your address filter). |
| `lamports` | `UInt64` | SOL balance in lamports (1 SOL = 1,000,000,000 lamports). |
| `owner` | `String` | Program that owns the account. |
| `executable` | `Bool` | `true` for a program account. |
| `rent_epoch` | `UInt64` | Rent epoch of the account. |
| `data_len` | `UInt64` | Size of the account data in bytes. |
| `data` | `String` | Account data, base64. Empty for accounts without data. |
| `slot` | `UInt64` | Slot the state was read at. |

### `live_token_accounts`

The token accounts each wallet holds now, for SPL Token and Token-2022. Read by `owner`. One row per token account. Not a history.

| Column | Type | Description |
|---|---|---|
| `owner` | `String` | The wallet that owns the token accounts (the value of your owner filter). |
| `token_account` | `String` | Address of the token account. |
| `mint` | `String` | Token mint. |
| `amount` | `UInt64` | Balance in base units. |
| `decimals` | `UInt8` | Decimals of the mint. |
| `ui_amount` | `Float64` | Balance in whole tokens (`amount / 10^decimals`). |
| `program` | `String` | Token program: Token or Token-2022 program id. |
| `slot` | `UInt64` | Slot the state was read at. |

## Find a column

Ask your agent, or call the tools yourself:

```text
list_tables
describe_table   name: "live_token_balance_changes"
```

`list_tables` returns the nine tables, the key or range each one needs, and notes. `describe_table` returns the columns and types, and the rules that apply to that table.

In the dashboard, the **Code** tab completes table and column names as you type. Type `from ` to see the list of tables.
