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


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