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

> Stellar operations — payments, offers, account changes, and other operation types.

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.history_operations` table tracks operational details of transaction in ledgers/blocks.

Operations are objects that represent a desired change to the ledger: payments, offers to exchange currency, changes made to account options, etc. Operations are submitted to the Stellar network grouped in a Transaction. Each of Stellar’s operations have a unique operation object.

## Column Descriptions

| **Column**                               | **Description**                                                                  | **Type**                                                                                                                                   |
| ---------------------------------------- | -------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------ |
| **closed\_at\_date**                     | The date when the operation was closed.                                          | date                                                                                                                                       |
| **id**                                   | The unique identifier for the operation.                                         | bigint                                                                                                                                     |
| **source\_account**                      | The account that initiated the operation.                                        | varchar                                                                                                                                    |
| **source\_account\_muxed**               | The multiplexed source account address, if applicable.                           | varchar                                                                                                                                    |
| **transaction\_id**                      | The unique identifier for the transaction that includes the operation.           | bigint                                                                                                                                     |
| **type**                                 | The numeric representation of the operation type.                                | bigint                                                                                                                                     |
| **type\_string**                         | The string description of the operation type.                                    | varchar                                                                                                                                    |
| **closed\_at**                           | The timestamp when the operation was closed.                                     | timestamp(3) with time zone                                                                                                                |
| **operation\_result\_code**              | The result code indicating the outcome of the operation.                         | varchar                                                                                                                                    |
| **operation\_trace\_code**               | The trace code detailing the operation's execution.                              | varchar                                                                                                                                    |
| **ledger\_sequence**                     | The sequence number of the ledger in which the operation is included.            | bigint                                                                                                                                     |
| **account**                              | The account address associated with the operation.                               | varchar                                                                                                                                    |
| **account\_muxed**                       | The multiplexed account address, if applicable.                                  | varchar                                                                                                                                    |
| **account\_muxed\_id**                   | The ID of the multiplexed account, if applicable.                                | varchar                                                                                                                                    |
| **account\_id**                          | The unique identifier for the account involved in the operation.                 | varchar                                                                                                                                    |
| **amount**                               | The amount of the asset transferred or affected by the operation.                | double                                                                                                                                     |
| **asset**                                | The asset involved in the operation.                                             | varchar                                                                                                                                    |
| **asset\_code**                          | The code of the asset involved in the operation.                                 | varchar                                                                                                                                    |
| **asset\_issuer**                        | The issuer of the asset involved in the operation.                               | varchar                                                                                                                                    |
| **asset\_id**                            | The unique identifier for the asset.                                             | bigint                                                                                                                                     |
| **asset\_type**                          | The type of asset involved in the operation.                                     | varchar                                                                                                                                    |
| **authorize**                            | A boolean indicating whether authorization was given for the operation.          | boolean                                                                                                                                    |
| **balance\_id**                          | The ID of the balance affected by the operation.                                 | varchar                                                                                                                                    |
| **buying\_asset\_code**                  | The code of the asset being bought in the operation.                             | varchar                                                                                                                                    |
| **buying\_asset\_issuer**                | The issuer of the asset being bought in the operation.                           | varchar                                                                                                                                    |
| **buying\_asset\_id**                    | The unique identifier for the asset being bought.                                | bigint                                                                                                                                     |
| **buying\_asset\_type**                  | The type of asset being bought in the operation.                                 | varchar                                                                                                                                    |
| **claimable\_balance\_id**               | The ID of the claimable balance involved in the operation.                       | varchar                                                                                                                                    |
| **claimant**                             | The account address of the claimant.                                             | varchar                                                                                                                                    |
| **claimant\_muxed**                      | The multiplexed account of the claimant, if applicable.                          | varchar                                                                                                                                    |
| **claimant\_muxed\_id**                  | The ID of the multiplexed claimant account, if applicable.                       | varchar                                                                                                                                    |
| **data\_account\_id**                    | The account ID for the account where data is being modified.                     | varchar                                                                                                                                    |
| **data\_name**                           | The name of the data being modified in the operation.                            | varchar                                                                                                                                    |
| **from**                                 | The account address sending the asset in the operation.                          | varchar                                                                                                                                    |
| **from\_muxed**                          | The multiplexed sender account, if applicable.                                   | varchar                                                                                                                                    |
| **from\_muxed\_id**                      | The ID of the multiplexed sender account, if applicable.                         | varchar                                                                                                                                    |
| **funder**                               | The account funding the operation.                                               | varchar                                                                                                                                    |
| **funder\_muxed**                        | The multiplexed funder account, if applicable.                                   | varchar                                                                                                                                    |
| **funder\_muxed\_id**                    | The ID of the multiplexed funder account, if applicable.                         | varchar                                                                                                                                    |
| **high\_threshold**                      | The high threshold required for the operation.                                   | bigint                                                                                                                                     |
| **home\_domain**                         | The home domain associated with the account.                                     | varchar                                                                                                                                    |
| **inflation\_dest**                      | The destination account for inflation pools.                                     | varchar                                                                                                                                    |
| **into**                                 | The account receiving the asset in the operation.                                | varchar                                                                                                                                    |
| **into\_muxed**                          | The multiplexed account receiving the asset, if applicable.                      | varchar                                                                                                                                    |
| **into\_muxed\_id**                      | The ID of the multiplexed recipient account, if applicable.                      | varchar                                                                                                                                    |
| **limit**                                | The limit of the trustline or balance change.                                    | double                                                                                                                                     |
| **low\_threshold**                       | The low threshold required for the operation.                                    | bigint                                                                                                                                     |
| **master\_key\_weight**                  | The weight of the master key for signing transactions.                           | bigint                                                                                                                                     |
| **med\_threshold**                       | The medium threshold required for the operation.                                 | bigint                                                                                                                                     |
| **name**                                 | The name associated with the operation or account.                               | varchar                                                                                                                                    |
| **offer\_id**                            | The ID of the offer related to the operation.                                    | bigint                                                                                                                                     |
| **path**                                 | The payment path used in the operation.                                          | array(row("asset\_code" varchar,"asset\_issuer" varchar,"asset\_type" varchar))                                                            |
| **price**                                | The price of the asset involved in the operation.                                | double                                                                                                                                     |
| **price\_r**                             | The rational price of the asset (fraction of numerator and denominator).         | row("d" bigint,"n" bigint)                                                                                                                 |
| **selling\_asset\_code**                 | The code of the asset being sold in the operation.                               | varchar                                                                                                                                    |
| **selling\_asset\_issuer**               | The issuer of the asset being sold in the operation.                             | varchar                                                                                                                                    |
| **selling\_asset\_id**                   | The unique identifier for the asset being sold.                                  | bigint                                                                                                                                     |
| **selling\_asset\_type**                 | The type of asset being sold in the operation.                                   | varchar                                                                                                                                    |
| **set\_flags**                           | An array of flags being set by the operation.                                    | array(bigint)                                                                                                                              |
| **set\_flags\_s**                        | An array of string descriptions for the flags being set.                         | array(varchar)                                                                                                                             |
| **signer\_account\_id**                  | The account ID of the signer.                                                    | varchar                                                                                                                                    |
| **signer\_key**                          | The key of the signer being modified.                                            | varchar                                                                                                                                    |
| **signer\_weight**                       | The weight assigned to the signer.                                               | bigint                                                                                                                                     |
| **source\_amount**                       | The source amount for the operation.                                             | double                                                                                                                                     |
| **source\_asset\_code**                  | The code of the source asset in the operation.                                   | varchar                                                                                                                                    |
| **source\_asset\_issuer**                | The issuer of the source asset in the operation.                                 | varchar                                                                                                                                    |
| **source\_asset\_id**                    | The unique identifier for the source asset.                                      | bigint                                                                                                                                     |
| **source\_asset\_type**                  | The type of source asset in the operation.                                       | varchar                                                                                                                                    |
| **source\_max**                          | The maximum amount of the source asset allowed in the operation.                 | double                                                                                                                                     |
| **starting\_balance**                    | The starting balance for the account in the operation.                           | double                                                                                                                                     |
| **to**                                   | The account receiving the asset.                                                 | varchar                                                                                                                                    |
| **to\_muxed**                            | The multiplexed account receiving the asset, if applicable.                      | varchar                                                                                                                                    |
| **to\_muxed\_id**                        | The ID of the multiplexed recipient account, if applicable.                      | varchar                                                                                                                                    |
| **trustee**                              | The trustee account involved in the operation.                                   | varchar                                                                                                                                    |
| **trustee\_muxed**                       | The multiplexed trustee account, if applicable.                                  | varchar                                                                                                                                    |
| **trustee\_muxed\_id**                   | The ID of the multiplexed trustee account, if applicable.                        | varchar                                                                                                                                    |
| **trustline\_account\_id**               | The account ID associated with the trustline in the operation.                   | varchar                                                                                                                                    |
| **trustline\_asset**                     | The asset involved in the trustline operation.                                   | varchar                                                                                                                                    |
| **trustor**                              | The trustor account in the operation.                                            | varchar                                                                                                                                    |
| **trustor\_muxed**                       | The multiplexed trustor account, if applicable.                                  | varchar                                                                                                                                    |
| **trustor\_muxed\_id**                   | The ID of the multiplexed trustor account, if applicable.                        | varchar                                                                                                                                    |
| **value**                                | The value associated with the operation.                                         | varchar                                                                                                                                    |
| **clear\_flags**                         | An array of flags being cleared by the operation.                                | array(bigint)                                                                                                                              |
| **clear\_flags\_s**                      | An array of string descriptions for the flags being cleared.                     | array(varchar)                                                                                                                             |
| **destination\_min**                     | The minimum destination amount in the operation.                                 | varchar                                                                                                                                    |
| **bump\_to**                             | The sequence number to which the operation bumps.                                | varchar                                                                                                                                    |
| **authorize\_to\_maintain\_liabilities** | A boolean indicating whether authorization is granted to maintain liabilities.   | boolean                                                                                                                                    |
| **clawback\_enabled**                    | A boolean indicating whether clawback is enabled for the operation.              | boolean                                                                                                                                    |
| **sponsor**                              | The account sponsoring the operation.                                            | varchar                                                                                                                                    |
| **sponsored\_id**                        | The ID of the sponsored account.                                                 | varchar                                                                                                                                    |
| **begin\_sponsor**                       | The sponsor that initiated the operation.                                        | varchar                                                                                                                                    |
| **begin\_sponsor\_muxed**                | The multiplexed sponsor account, if applicable.                                  | varchar                                                                                                                                    |
| **begin\_sponsor\_muxed\_id**            | The ID of the multiplexed sponsor account, if applicable.                        | varchar                                                                                                                                    |
| **liquidity\_pool\_id**                  | The liquidity pool ID associated with the operation.                             | varchar                                                                                                                                    |
| **reserve\_a\_asset\_type**              | The type of the first reserve asset in the liquidity pool operation.             | varchar                                                                                                                                    |
| **reserve\_a\_asset\_code**              | The code of the first reserve asset in the liquidity pool operation.             | varchar                                                                                                                                    |
| **reserve\_a\_asset\_issuer**            | The issuer of the first reserve asset in the liquidity pool operation.           | varchar                                                                                                                                    |
| **reserve\_a\_asset\_id**                | The unique identifier for the first reserve asset.                               | bigint                                                                                                                                     |
| **reserve\_a\_max\_amount**              | The maximum amount of the first reserve asset in the operation.                  | double                                                                                                                                     |
| **reserve\_a\_deposit\_amount**          | The amount of the first reserve asset deposited in the operation.                | double                                                                                                                                     |
| **reserve\_b\_asset\_type**              | The type of the second reserve asset in the liquidity pool operation.            | varchar                                                                                                                                    |
| **reserve\_b\_asset\_code**              | The code of the second reserve asset in the liquidity pool operation.            | varchar                                                                                                                                    |
| **reserve\_b\_asset\_issuer**            | The issuer of the second reserve asset in the liquidity pool operation.          | varchar                                                                                                                                    |
| **reserve\_b\_asset\_id**                | The unique identifier for the second reserve asset.                              | bigint                                                                                                                                     |
| **reserve\_b\_max\_amount**              | The maximum amount of the second reserve asset in the operation.                 | double                                                                                                                                     |
| **reserve\_b\_deposit\_amount**          | The amount of the second reserve asset deposited in the operation.               | double                                                                                                                                     |
| **min\_price**                           | The minimum price of the asset in the operation.                                 | double                                                                                                                                     |
| **min\_price\_r**                        | The rational minimum price of the asset (fraction of numerator and denominator). | array(row("d" bigint,"n" bigint))                                                                                                          |
| **max\_price**                           | The maximum price of the asset in the operation.                                 | double                                                                                                                                     |
| **max\_price\_r**                        | The rational maximum price of the asset (fraction of numerator and denominator). | array(row("d" bigint,"n" bigint))                                                                                                          |
| **shares\_received**                     | The number of shares received in the liquidity pool operation.                   | double                                                                                                                                     |
| **reserve\_a\_min\_amount**              | The minimum amount of the first reserve asset in the operation.                  | double                                                                                                                                     |
| **reserve\_a\_withdraw\_amount**         | The amount of the first reserve asset withdrawn in the operation.                | double                                                                                                                                     |
| **reserve\_b\_min\_amount**              | The minimum amount of the second reserve asset in the operation.                 | double                                                                                                                                     |
| **reserve\_b\_withdraw\_amount**         | The amount of the second reserve asset withdrawn in the operation.               | double                                                                                                                                     |
| **shares**                               | The number of shares involved in the liquidity pool operation.                   | double                                                                                                                                     |
| **asset\_balance\_changes**              | An array of asset balance changes related to the operation.                      | array(row("amount" double,"asset\_code" varchar,"asset\_issuer" varchar,"asset\_type" varchar,"from" varchar,"to" varchar,"type" varchar)) |
| **parameters**                           | An array of parameters associated with the operation.                            | array(row("type" varchar,"value" varchar))                                                                                                 |
| **parameters\_decoded**                  | An array of decoded parameters associated with the operation.                    | array(row("type" varchar,"value" varchar))                                                                                                 |
| **function**                             | The function executed in the operation.                                          | varchar                                                                                                                                    |
| **address**                              | The address associated with the operation.                                       | varchar                                                                                                                                    |
| **extend\_to**                           | The sequence number to which the operation extends.                              | bigint                                                                                                                                     |
| **contract\_id**                         | The contract ID associated with the operation.                                   | varchar                                                                                                                                    |
| **contract\_code\_hash**                 | The hash of the contract code associated with the operation.                     | varchar                                                                                                                                    |
| **ledger\_key\_hash**                    | An array of hashes for the ledger keys associated with the operation.            | array(varchar)                                                                                                                             |
| **ledgers\_to\_expire**                  | The number of ledgers until the operation expires.                               | bigint                                                                                                                                     |
| **soroban\_operation\_type**             | The type of operation for Soroban smart contracts.                               | varchar                                                                                                                                    |
| **updated\_at**                          | The time when the operation record was last updated.                             | timestamp(3) with time zone                                                                                                                |
| **ingested\_at**                         | The time when the operation data was ingested into the system.                   | timestamp(3) with time zone                                                                                                                |

## Table Sample

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