# RPCX Examples by Table

> An example method for each of the nine RPCX live tables: transactions, instructions, logs, fees, SOL and token flows, blocks, balances, and token holdings of many wallets in one call.

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

This page has example methods for each of the nine live tables. Most examples read many wallets in one call, with a list param such as `wallets: pubkey[]`. Paste one into the **Code** tab of a new method, fill in **Params**, select **Validate**, **Save**, then **Run**.

For the columns of each table, see [Live tables](/docs/api-reference/rpcx/tables) or search them on [All tables](/docs/api-reference/rpcx/all-tables). For the method language itself, see [Writing methods](/docs/api-reference/rpcx/writing-methods) and the [language reference](/docs/api-reference/rpcx/language).

## Read this first

- **A key or a range right after `from`.** Use a key such as `(address | in wallets)`, `sig`, `program` on `live_instructions`, or `(owner | in owners)` on `live_token_accounts`. A chain table can also be read by a bounded `ts` or `slot` range alone, up to 3,000 slots. Without either, **Validate** refuses the method with `live_key_missing`.
- **Add a time range to reads by address.** `ts >= from && ts = from && ts  1, true => 0]}
  group {address} (
    aggregate {
      txs = count this,
      failures = sum failed,
      last_tx = max ts
    }
  )
  sort {-txs}
}
```

## `live_transactions`

One row per transaction that touches an address, or one transaction by signature.

Every transaction of a list of wallets, newest first:

```text RPCX method
method txsFor(wallets: pubkey[] "Accounts", from: time, to: time) {
  from live_transactions
  filter (address | in wallets) && ts >= from && ts = from && ts = from && ts = from && ts = from && ts = from && ts = from && ts = from && ts = start && slot  0
  select {owner, token_account, ui_amount}
  sort {-ui_amount}
}
```

Every non-empty holding of a list of wallets:

```text RPCX method
method holdings(owners: pubkey[] "Wallets") {
  from live_token_accounts
  filter (owner | in owners)
  filter amount > 0
  select {owner, mint, ui_amount, program}
  sort {owner, -ui_amount}
}
```
