Skip to main content

Enriched History Operations

Table Metadata

PropertyConfiguration
Natural Key(s)op_id
Partition Field(s)closed_at (MONTH partition)
Clustered Field(s)ledger_sequence, transaction_id, op_account_id, type
Documentationdbt_docs

Column Details

NameDescriptionData TypeDomain ValuesRequired?Source TableNotes
accountThe new resulting account address that is created and funded (create operation) The account address that is being removed and merged into another account (merge operation)stringhistory_operationsPart of the original details object in the history_operations table
amountFloat representation of the amount of an asset sent/offered/etcfloathistory_operations
asset_codeThe 4 or 12 character code representation of the asset on the networkstringhistory_operations
asset_issuerThe account address of the original asset issuer that created the assetstringhistory_operations
asset_typeThe identifier for type of asset code, can be a alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM.string
  • credit_alphanum4
  • credit_alphanum12
  • native
history_operations
authorizeIndicates whether the trustline is authorized. 0 is the account is not authorized to transact with the asset in any way. 1 if the account is authorized to transact with the asset. 2 if the account is authorized to maintain orders, but not to perform other transactions.booleanhistory_operations
balance_idThe unique identifier of the claimable balance. The id is comprised of 8 character type code + SHA-256 hash of the history operation id that created the balance. The balance id can be joined back to the claimable_balances table to gather more details about the balancestringhistory_operations
buying_asset_codeThe 4 or 12 character code representation of the asset that is either bought or offered to buy in a tradestringhistory_operations
buying_asset_issuerThe account address of the original asset issuer that created the asset bought or offered to buystringhistory_operations
buying_asset_typeThe identifier for type of asset code, can be a alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM.string
  • credit_alphanum4
  • credit_alphanum12
  • native
history_operations
fromThe account address from which the payment originates (the sender account)stringhistory_operations
funderWhen a new account is created, an account address "funds" the new accountstringhistory_operations
high_thresholdThe sum of the weight of all signatures that sign a transaction for the high threshold operation. The weight must exceed the set threshold for the operation to succeed.integerhistory_operationsEach operation falls under a specific threshold category: low, medium or high. Thresholds define the level of privilege an operation needs in order to succeed (this is a security measure) Low Security: Allow Trust, Set Trust Line Flags, Bump Sequence and Claim Claimable Balance Medium Security: Everything Else High Security: Account Merge, Set Options
home_domainThe home domain used for the stellar.toml file discoverystringhistory_operations
inflation_destThe account address specifying where to send inflation funds. The concept of inflation on the network has been discontinuedstringhistory_operationsInflation was retired from the network in 2019.
intoThe account address receiving the deleted account's lumens. This is the account in which the intended deleted account will be mergedstringhistory_operations
limitThe upper bound amount of an asset that an account can holdfloathistory_operations
low_thresholdThe sum of the weight of all signatures that sign a transaction for the low threshold operation. The weight must exceed the set threshold for the operation to succeed.integerhistory_operationsEach operation falls under a specific threshold category: low, medium or high. Thresholds define the level of privilege an operation needs in order to succeed (this is a security measure) Low Security: Allow Trust, Set Trust Line Flags, Bump Sequence and Claim Claimable Balance Medium Security: Everything Else High Security: Account Merge, Set Options
master_key_weightAn accounts private key is called the master key. For signing transactions, the account holder can specify a weight for the master key, which contributes to thresholds validation when processing a transactionintegerIntegers from 1 to 255history_operations
med_thresholdThe sum of the weight of all signatures that sign a transaction for the medium threshold operation. The weight must exceed the set threshold for the operation to succeed.integerhistory_operationsEach operation falls under a specific threshold category: low, medium or high. Thresholds define the level of privilege an operation needs in order to succeed (this is a security measure) Low Security: Allow Trust, Set Trust Line Flags, Bump Sequence and Claim Claimable Balance Medium Security: Everything Else High Security: Account Merge, Set Options
nameThe manage data operation allows an account to write and store data directly on the ledger in a key value pair format. The name is the key for a data entry.stringhistory_operations
offer_idThe unique id for the offer. This id can be joined with the offers tableintegerhistory_operations
pathPath payments maximize the best exchange rate path when sending money from one asset to another asset. The intermediary assets that this path hops through will be reported in the record. This feature is especially useful when the market between the original asset pair is illiquidarray[record]history_operationsUp to 6 paths are permitted for a single payment. Example: sending EUR -> MXN could look like EUR -> BTC -> CNY -> XLM -> MXN to maximize the best exchange rate Payments are atomic, so if an exchange in the middle of a path payment fails, the entire payment will fail which means the user will keep their original funds. They will not be stuck with an intermediary asset in the event of payment failure.
priceThe ratio of selling asset to buying asset. This is a number representing how many units of a selling asset it takes to get 1 unit of a buying assetfloathistory_operations
dPrecise representation of the buy and sell price of a trade. The d is the denominator. When taken with n/d you will get the priceintegerhistory_operations
nPrecise representation of the buy and sell prices of a trade. The n is the numerator. When taken with n/d you will get the price.integerhistory_operations
selling_asset_codeThe 4 or 12 character code representation of the asset that is either sold or offered to sell in a tradestringhistory_operations
selling_asset_issuerThe account address of the original asset issuer that created the asset sold or offered to sellstringhistory_operations
selling_asset_typeThe identifier for type of asset code, can be a alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM.string
  • credit_alphanum4
  • credit_alphanum12
  • native
history_operations
set_flagsArray of numeric values of the flags set for a given trustline in the operationarray[integer]
  • 1 - Auth Required
  • 2 - Auth Revocable
  • 4 - Auth Immutable
history_operations
set_flags_sArray of string values of the flags set for a given trustline in the operationarray[string]
  • Auth Required
  • Auth Revocable
  • Auth Immutable
history_operations
signer_keyThe address of the signer which is no longer sponsoredstringhistory_operations
signer_weightThe weight of the new signer. For transactions, multiple accounts can sign a transaction from a source account. This weight contributes towards calculating whether the transaction exceeds the specified threshold weight to complete the transactionintegerhistory_operations
source_amountThe originating amount sent designated in the source assetfloathistory_operations
source_asset_codeThe 4 or 12 character code representation of the asset that is originally sentstringhistory_operations
source_asset_issuerThe account address of the original asset issuer that created the asset sentstringhistory_operations
source_asset_typeThe identifier for type of asset code, can be a alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM.string
  • credit_alphanum4
  • credit_alphanum12
  • native
history_operations
source_maxThe maxium amount to be sent, designated in the source assetfloathistory_operations
starting_balanceThe amount of XLM to send to the newly created account. The account starting balance will need to exceed the minimum balance necessary to hold an account on the Stellar Networkfloathistory_operations
toThe address of the account receiving the payment fundsstringhistory_operations
trusteeThe issuing account address (only present for credit asset types)stringhistory_operations
trustorThe trusting account address, or the account being authorized or unauthorizedstringhistory_operations
trustline_assetThe asset of the trustline which is no longer sponsoredstringhistory_operations
valueThe manage data operation allows an account to write and store data directly on the ledger in a key value pair format. The value is the value of a key for a data entry.stringhistory_operations
clear_flagsArray of numeric values of the flags cleared for a given trustline in the operation. If the flag was originally set, this will delete the flagarray[integer]
  • 1 - Auth Required
  • 2 - Auth Revocable
  • 4 - Auth Immutable
history_operations
clear_flags_sArray of string values of the flags cleared for a given trustline in the operation. If the flag was originally set, this will delete the flagarray[string]
  • Auth Required
  • Auth Revocable
  • Auth Immutable
history_operations
destination_minThe minimum amount to be received, designated in the expected destination assetstringhistory_operations
bump_toThe new desired value of the source account's sequence numberstringhistory_operations
sponsorThe account address of another account that maintains the minimum balance in XLM for the source account to complete operationsstringhistory_operations
sponsored_idThe account address of the account which will be sponsoredstringhistory_operations
begin_sponsorThe account address of the account which initiated the sponsorshipstringhistory_operations
authorize_to_maintain_liabilitiesIndicates whether the trustline is authorized. 0 is the account is not authorized to transact with the asset in any way. 1 if the account is authorized to transact with the asset. 2 if the account is authorized to maintain orders, but not to perform other transactions.booleanhistory_operations
clawback_enabledIndicates whether the asset can be clawed back by the asset issuerbooleanhistory_operations
liquidity_pool_idUnique identifier for a liquidity poolstringhistory_operations
reserve_a_asset_typeThe identifier for type of asset code, can be a alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM.string
  • credit_alphanum4
  • credit_alphanum12
  • native
history_operations
reserve_a_asset_codeThe 4 or 12 character code representation of the asset of one of the two asset pairs in a liquidity poolstringhistory_operations
reserve_a_asset_issuerThe account address of the original asset issuer that created one of the two asset pairs in the liquidity poolstringhistory_operations
reserve_a_max_amountThe maximum amount of reserve a that can be deposited into the pool.floathistory_operations
reserve_a_deposit_amountThe amount of reserve a that ended up actually deposited into the poolfloathistory_operations
reserve_b_asset_typeThe identifier for type of asset code, can be a alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM.string
  • credit_alphanum4
  • credit_alphanum12
  • native
history_operations
reserve_b_asset_codeThe 4 or 12 character code representation of the asset of one of the two asset pairs in a liquidity poolstringhistory_operations
reserve_b_asset_issuerThe account address of the original asset issuer that created one of the two asset pairs in the liquidity poolstringhistory_operations
reserve_b_max_amountThe maximum amount of reserve b that can be deposited into the pool.floathistory_operations
reserve_b_deposit_amountThe amount of reserve b that ended up actually deposited into the pool.floathistory_operations
min_priceThe floating point value indicating the minimum exchange rate for this deposit operation. Reported as Reserve A / Reserve Bfloathistory_operations
min_price_rA fractional representation of the prices of the two assets in a pool. The n is the numerator (value of asset a) and the d is the denominator (value of asset b)array[record]history_operations
max_priceThe floating point value indicating the maximum exchange rate for this deposit operation. Reported as Reserve A / Reserve Bfloathistory_operations
max_price_rA fractional representation of the prices of the two assets in a pool. The n is the numerator (value of asset a) and the d is the denominator (value of asset b)array[record]history_operations
shares_receivedA floating point number representing the number of pool shares received for this deposit. A pool share is a compilation of both asset a and asset b reserves. It is not possible to own only asset a or asset b in a poolfloathistory_operations
reserve_a_min_amountThe minimum amount of reserve a that can be withdrawn from the pool.floathistory_operations
reserve_b_min_amountThe minimum amount of reserve b that can be withdrawn from the pool.floathistory_operations
sharesThe number of shares withdrawn from the pool. It is not possible to withdraw only asset a or asset b, equal value must be withdrawn from the poolfloathistory_operations
reserve_a_withdraw_amountThe amount of reserve a that ended up actually withdrawn from the pool.floathistory_operations
reserve_b_withdraw_amountThe amount of reserve b that ended up actually withdrawn from the pool.floathistory_operations
op_application_orderThe order number in the transaction set in which the operation is executed. The application order and transaction id is a natural key that comprises the (operation) idintegerhistory_operations
op_idUnique identifier for an operationintegerhistory_operations
op_source_accountThe account address that originates the operationstringhistory_operations
op_source_account_muxedIf an account is multiplexed (muxed), the virtual account address that originates the operationstringhistory_operations
transaction_idThe transaction identifier in which the operation executed. There can be up to 100 operations in a given transactionintegerhistory_operations
typeThe number indicating which type of operation this operation executesinteger