> ## 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_effects

> Stellar operation effects — balance changes, trustline modifications, and other state changes.

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_effects` table records specific changes that occur in the ledger as a result of successful operations, but are not necessarily directly reflected in the ledger or history, as transactions and operations are.

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 effect was closed. | date |
| **address** | The account address associated with the effect. | varchar |
| **address\_muxed** | The multiplexed address, if applicable. | varchar |
| **operation\_id** | The unique identifier for the operation that produced the effect. | bigint |
| **type** | The numeric representation of the effect type. | bigint |
| **type\_string** | The string description of the effect type. | varchar |
| **closed\_at** | The timestamp when the effect was closed. | timestamp(3) with time zone |
| **ledger\_sequence** | The sequence number of the ledger in which the effect is included. | bigint |
| **index** | The index of the effect within the operation. | bigint |
| **id** | The unique identifier for the effect. | varchar |
| **liquidity\_pool** | Information about the liquidity pool related to the effect, including fee, ID, reserves, and type. | row("fee\_bp" bigint,"id" varchar,"total\_shares" decimal(38,9),"total\_trustlines" bigint,"type" varchar,"reserves" array(row("asset" varchar,"amount" decimal(38,9)))) |
| **reserves\_received** | An array of reserves received in the liquidity pool operation. | array(row("asset" varchar,"amount" decimal(38,9))) |
| **reserves\_deposited** | An array of reserves deposited in the liquidity pool operation. | array(row("asset" varchar,"amount" decimal(38,9))) |
| **reserves\_revoked** | An array of revoked reserves in the liquidity pool, including claimable balance IDs. | array(row("asset" varchar,"amount" decimal(38,9),"claimable\_balance\_id" varchar)) |
| **bought** | An array of assets bought during the operation. | array(row("asset" varchar,"amount" decimal(38,9))) |
| **sold** | An array of assets sold during the operation. | array(row("asset" varchar,"amount" decimal(38,9))) |
| **shares\_revoked** | The number of shares revoked in the liquidity pool. | decimal(38,9) |
| **shares\_received** | The number of shares received in the liquidity pool. | decimal(38,9) |
| **shares\_redeemed** | The number of shares redeemed in the liquidity pool. | decimal(38,9) |
| **liquidity\_pool\_id** | The ID of the liquidity pool related to the effect. | varchar |
| **balance\_id** | The ID of the balance affected by the effect. | varchar |
| **new\_seq** | The new sequence number for the account. | bigint |
| **name** | The name associated with the effect. | varchar |
| **value** | The value associated with the effect. | varchar |
| **trustor** | The account ID of the trustor involved in the effect. | varchar |
| **limit** | The limit associated with the trustline in the effect. | decimal(38,9) |
| **inflation\_destination** | The destination account for inflation in the effect. | varchar |
| **authorized\_flag** | A boolean indicating whether the asset was authorized. | boolean |
| **auth\_immutable\_flag** | A boolean indicating whether the asset is immutable. | boolean |
| **authorized\_to\_maintain\_liabilities** | A boolean indicating whether authorization to maintain liabilities was granted. | boolean |
| **auth\_revocable\_flag** | A boolean indicating whether the authorization is revocable. | boolean |
| **auth\_required\_flag** | A boolean indicating whether authorization is required. | boolean |
| **auth\_clawback\_enabled\_flag** | A boolean indicating whether clawback is enabled for the effect. | boolean |
| **claimable\_balance\_clawback\_enabled\_flag** | A boolean indicating whether clawback is enabled for claimable balances. | boolean |
| **clawback\_enabled\_flag** | A boolean indicating whether clawback is enabled for the asset. | boolean |
| **high\_threshold** | The high threshold for account signatures. | bigint |
| **med\_threshold** | The medium threshold for account signatures. | bigint |
| **low\_threshold** | The low threshold for account signatures. | bigint |
| **home\_domain** | The home domain associated with the account. | varchar |
| **asset\_issuer** | The issuer of the asset involved in the effect. | varchar |
| **asset** | The asset involved in the effect. | varchar |
| **asset\_code** | The code of the asset involved in the effect. | varchar |
| **signer** | The signer involved in the effect. | varchar |
| **sponsor** | The sponsor of the account or effect. | varchar |
| **new\_sponsor** | The new sponsor of the account or effect. | varchar |
| **former\_sponsor** | The former sponsor of the account or effect. | varchar |
| **weight** | The weight assigned to the signer. | bigint |
| **public\_key** | The public key associated with the effect. | varchar |
| **asset\_type** | The type of asset involved in the effect. | varchar |
| **amount** | The amount involved in the effect. | decimal(38,9) |
| **starting\_balance** | The starting balance of the account in the effect. | decimal(38,9) |
| **seller** | The account ID of the seller in the effect. | varchar |
| **seller\_muxed** | The multiplexed account ID of the seller, if applicable. | varchar |
| **seller\_muxed\_id** | The ID of the multiplexed seller account. | bigint |
| **offer\_id** | The ID of the offer involved in the effect. | bigint |
| **sold\_amount** | The amount of the asset sold in the effect. | decimal(38,9) |
| **sold\_asset\_type** | The type of asset sold in the effect. | varchar |
| **sold\_asset\_code** | The code of the asset sold in the effect. | varchar |
| **sold\_asset\_issuer** | The issuer of the asset sold in the effect. | varchar |
| **bought\_amount** | The amount of the asset bought in the effect. | decimal(38,9) |
| **bought\_asset\_type** | The type of asset bought in the effect. | varchar |
| **bought\_asset\_code** | The code of the asset bought in the effect. | varchar |
| **data\_name** | The name of the data involved in the effect. | varchar |
| **bought\_asset\_issuer** | The issuer of the asset bought in the effect. | varchar |
| **entries** | An array of entries involved in the effect. | array(varchar) |
| **extend\_to** | The ledger sequence number to which the effect extends. | bigint |
| **contract** | The contract associated with the effect. | varchar |
| **contract\_event\_type** | The type of contract event associated with the effect. | varchar |
| **ledgers\_to\_expire** | The number of ledgers until the effect expires. | bigint |
| **updated\_at** | The time when the effect record was last updated. | timestamp(3) with time zone |
| **ingested\_at** | The time when the effect data was ingested into the system. | timestamp(3) with time zone |

## Table Sample

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


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