| ID | NUMBER | Unique identifier for the operation. |
| CLOSED_AT | TIMESTAMP_NTZ | Timestamp when the ledger was closed and committed to the network. Ledgers are expected to close ~every 5 seconds. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | A clone of closed_at for join convenience. |
| ACCOUNT | TEXT | The account involved in the operation. |
| AMOUNT | FLOAT | Float representation of the amount of an asset sent/offered/etc. |
| ASSET | TEXT | |
| ASSET_CODE | TEXT | The 4 or 12 character code representation of the asset on the network. |
| ASSET_ISSUER | TEXT | The account address of the original asset issuer that created the asset. |
| ASSET_TYPE | TEXT | The identifier for type of asset code, can be an alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM. |
| ASSET_ID | TEXT | The Farm Hash encoding of Asset Code + Asset Issuer + Asset Type. This field is optimized for cross table joins since integer joins are less expensive than the original asset id components. |
| AUTHORIZE | BOOLEAN | Indicates whether the trustline is authorized. |
| BALANCE_ID | TEXT | The balance id of the claimable balance. |
| BUYING_ASSET_CODE | TEXT | The 4 or 12 character code representation of the asset being bought. |
| BUYING_ASSET_ISSUER | TEXT | The account address of the original asset issuer for the buying asset. |
| BUYING_ASSET_TYPE | TEXT | The identifier for type of buying asset code. |
| BUYING_ASSET_ID | TEXT | The identifier of the asset being bought. |
| FROM_ACCOUNT | TEXT | The account address from which the payment/contract originates. |
| FUNDER | TEXT | The account address that funds a new account. |
| HIGH_THRESHOLD | NUMBER | The 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. |
| HOME_DOMAIN | TEXT | The domain that hosts this accountâs stellar.toml file. |
| INFLATION_DEST | TEXT | Deprecated: The account address to receive an inflation payment when they are disbursed on the network. |
| INTO_ACCOUNT | TEXT | The account address receiving the deleted accountâs lumens. |
| LIMIT_AMOUNT | FLOAT | The upper bound amount of an asset that an account can hold. |
| LOW_THRESHOLD | NUMBER | The 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. |
| MASTER_KEY_WEIGHT | NUMBER | The weight of the master key, which is the private key for this account. If a master key is â0â, the account is locked and cannot be used. |
| MED_THRESHOLD | NUMBER | The 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. |
| NAME | TEXT | The key for a data entry in manage data operations. |
| OFFER_ID | NUMBER | The unique id for the offer. |
| PATH | VARIANT | Path for path payment operations. |
| PRICE | ARRAY | The ratio of selling asset to buying asset. |
| PRICE_R | VARIANT | Precise representation of the buy and sell price of the assets on an offer. The n is the numerator, the d is the denominator. By calculating the ratio of n/d you can calculate the price of the bid or ask. |
| SELLING_ASSET_CODE | TEXT | The 4 or 12 character code representation of the asset being sold. |
| SELLING_ASSET_ISSUER | TEXT | The account address of the original asset issuer for the selling asset. |
| SELLING_ASSET_TYPE | TEXT | The identifier for type of selling asset code. |
| SELLING_ASSET_ID | TEXT | The identifier of the asset being sold. |
| SET_FLAGS | ARRAY | Array of numeric values of flags set for a trustline. |
| SET_FLAGS_S | ARRAY | Array of string values of flags set for a trustline. |
| SIGNER_ACCOUNT_ID | TEXT | The address of the account of the signer no longer sponsored |
| SIGNER_KEY | TEXT | The address of the signer. |
| SIGNER_WEIGHT | NUMBER | The weight of the new signer. |
| SOURCE_AMOUNT | FLOAT | The originating amount sent designated in the source asset. |
| SOURCE_ASSET_CODE | TEXT | The 4 or 12 character code representation of the source asset. |
| SOURCE_ASSET_ISSUER | TEXT | The account address of the original source asset issuer. |
| SOURCE_ASSET_TYPE | TEXT | The identifier for type of source asset code. |
| SOURCE_ASSET_ID | TEXT | The identifier of the source asset. |
| SOURCE_MAX | FLOAT | The maximum amount to be sent in source asset. |
| STARTING_BALANCE | FLOAT | The amount of XLM sent to newly created account. |
| TO_ACCOUNT | TEXT | The address of the account receiving payment funds. |
| TRUSTEE | TEXT | The issuing account address. |
| TRUSTOR | TEXT | The trusting account address. |
| TRUSTLINE_ASSET | TEXT | The asset of the trustline. |
| VALUE | TEXT | The value for a data entry in manage data operations. |
| CLEAR_FLAGS | ARRAY | Array of numeric values of flags cleared for a trustline. |
| CLEAR_FLAGS_S | ARRAY | Array of string values of flags cleared for a trustline. |
| DESTINATION_MIN | TEXT | The minimum amount to be received in destination asset. |
| BUMP_TO | TEXT | The new desired value of the source accountâs sequence number. |
| SPONSOR | TEXT | The account address of the sponsor who is paying the reserves for this ledger entry. |
| SPONSORED_ID | TEXT | The account address of the account being sponsored. |
| BEGIN_SPONSOR | TEXT | The account address that initiated the sponsorship. |
| AUTHORIZE_TO_MAINTAIN_LIABILITIES | BOOLEAN | Indicates whether the trustline is authorized for maintaining liabilities. |
| CLAWBACK_ENABLED | BOOLEAN | Indicates whether the asset can be clawed back by the issuer. |
| LIQUIDITY_POOL_ID | TEXT | Unique identifier for a liquidity pool. There cannot be duplicate pools for the same asset pair. Once a pool has been created for the asset pair, another cannot be created. |
| RESERVE_A_ASSET_TYPE | TEXT | The type of the first reserve asset. |
| RESERVE_A_ASSET_ID | TEXT | The identifier of the first reserve asset. |
| RESERVE_A_ASSET_CODE | TEXT | The code of the first reserve asset. |
| RESERVE_A_ASSET_ISSUER | TEXT | The issuer of the first reserve asset. |
| RESERVE_A_MAX_AMOUNT | FLOAT | Maximum amount for first reserve asset deposit. |
| RESERVE_A_DEPOSIT_AMOUNT | FLOAT | Actual amount deposited for first reserve asset. |
| RESERVE_B_ASSET_TYPE | TEXT | The type of the second reserve asset. |
| RESERVE_B_ASSET_ID | TEXT | The identifier of the second reserve asset. |
| RESERVE_B_ASSET_CODE | TEXT | The code of the second reserve asset. |
| RESERVE_B_ASSET_ISSUER | TEXT | The issuer of the second reserve asset. |
| RESERVE_B_MAX_AMOUNT | FLOAT | Maximum amount for second reserve asset deposit. |
| RESERVE_B_DEPOSIT_AMOUNT | FLOAT | Actual amount deposited for second reserve asset. |
| MIN_PRICE | FLOAT | Minimum exchange rate for deposit operation. |
| MIN_PRICE_R | VARIANT | A 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). |
| MAX_PRICE | FLOAT | Maximum exchange rate for deposit operation. |
| MAX_PRICE_R | VARIANT | A 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). |
| SHARES_RECEIVED | FLOAT | |
| RESERVE_A_MIN_AMOUNT | FLOAT | |
| RESERVE_B_MIN_AMOUNT | FLOAT | |
| SHARES | FLOAT | Number of shares withdrawn from pool. |
| RESERVE_A_WITHDRAW_AMOUNT | FLOAT | Actual withdrawal amount for first reserve asset. |
| RESERVE_B_WITHDRAW_AMOUNT | FLOAT | Actual withdrawal amount for second reserve asset. |
| SOURCE_ACCOUNT | TEXT | The account that originated the transaction. |
| OP_SOURCE_ACCOUNT_MUXED | TEXT | Muxed source account for the operation. |
| TRANSACTION_ID | NUMBER | The transaction identifier containing this operation. |
| TYPE | NUMBER | The mechanism that calculates pricing and division of shares for the pool. With the initial AMM rollout, the only type of liquidity pool allowed to be created is a constant product pool. |
| TYPE_STRING | TEXT | The verbose type of operation. |
| LEDGER_SEQUENCE | NUMBER | The sequence number of the ledger. |
| OP_ACCOUNT_MUXED | TEXT | Muxed account identifier. |
| OP_ACCOUNT_MUXED_ID | NUMBER | Record that contains details based on the type of operation executed. Each operation will return its own relevant details, with the rest of the details as null |
| LEDGER_KEY_HASH | TEXT | Hash of the ledgerKey which is a subset of the ledgerEntry. The subset of ledgerEntry fields depends on ledgerEntryType. |
| BATCH_ID | TEXT | String representation of the run id for a given DAG in Airflow. Takes the form of âscheduled__<batch_end_date>-<dag_alias>â. Batch ids are unique to the batch and help with monitoring and rerun capabilities. |
| BATCH_RUN_DATE | TIMESTAMP_NTZ | The start date for the batch interval. When taken with the date in the batch_id, the date represents the interval of ledgers processed. The batch run date can be seen as a proxy of closed_at for a ledger. |
| BATCH_INSERT_TS | TIMESTAMP_NTZ | The timestamp in UTC when a batch of records was inserted into the database. This field can help identify if a batch executed in real time or as part of a backfill. The timestamp should not be used during ad hoc analysis and is useful for data engineering purposes. |
| ASSET_BALANCE_CHANGES | VARIANT | Changes in asset balances. |
| PARAMETERS | VARIANT | Parameters for contract function calls. |
| PARAMETERS_DECODED | VARIANT | Decoded contract parameters. |
| FUNCTION | TEXT | Function type for invoke_host_function. |
| ADDRESS | TEXT | Address for Soroban contract creation. |
| SOROBAN_OPERATION_TYPE | TEXT | Type of Soroban operation. |
| EXTEND_TO | NUMBER | Ledger extension target. |
| CONTRACT_ID | TEXT | Soroban contract identifier. |
| CONTRACT_CODE_HASH | TEXT | Hash of Soroban contract code. |
| OPERATION_RESULT_CODE | TEXT | Result code of the operation. |
| OPERATION_TRACE_CODE | TEXT | Trace code of the operation. |
| BEGIN_SPONSOR_MUXED | TEXT | If the initiating sponsorship account is multiplexed, the virtual address. |
| BEGIN_SPONSOR_MUXED_ID | NUMBER | If the initiating sponsorship account is multiplexed, the integer representation of the virtual address. |
| CLAIMABLE_BALANCE_ID | TEXT | The balance id of the claimable balance which is no longer sponsored |
| CLAIMANT | TEXT | The account address of the account which claimed the claimable balance |
| CLAIMANTS | VARIANT | An unstructured field that lists account addresses eligible to claim a balance and the conditions which must be satisfied to claim the balance (typically time bound conditions) |
| CLAIMANT_MUXED | TEXT | If the account is multiplexed, the virtual address of the account which claimed the claimable balance |
| CLAIMANT_MUXED_ID | NUMBER | If the account is multiplexed, an integer representation of the muxed account which claimed the balance |
| DATA_ACCOUNT_ID | TEXT | The account address of the account whose data entry is no longer sponsored |
| DATA_NAME | TEXT | The name of the data entry which is no longer sponsored |
| DETAILS_JSON | VARIANT | JSON record containing operation-specific details. |
| FROM_MUXED | TEXT | If the account is multiplexed, the virtual address of the sender account |
| FROM_MUXED_ID | NUMBER | If the account is multiplexed, the integer representation of the virtual address of the sender account |
| FUNDER_MUXED | TEXT | If the account is multiplexed, the virtual address of the account funding the new account |
| FUNDER_MUXED_ID | NUMBER | If the account is multiplexed, the integer representation of the account funding the new account |
| INTO_MUXED | TEXT | If the account is multiplexed, the virtual address of the account receive the deleted accountâs lumens |
| INTO_MUXED_ID | NUMBER | If the account is multiplexed, the integer representation of the account receiving the deleted accountâs lumens |
| LEDGERS_TO_EXPIRE | NUMBER | The number of ledgers after which the operation will expire if its not executed. |
| OP_ACCOUNT_ID | TEXT | The address of the account. The address is the accountâs public key encoded in base32. All account addresses start with a âGâ. |
| TO_MUXED | TEXT | If the account is multiplexed, the virtual address of the account receiving the payment |
| TO_MUXED_ID | NUMBER | If the account is multiplexed, the integer representation of the virtual address of the recipient account |
| TRUSTEE_MUXED | TEXT | If the issuing account address is multiplexed, the virtual address of the trustee |
| TRUSTEE_MUXED_ID | NUMBER | If the issuing account address is multiplexed, the integer representation of the virtual address of the trustee |
| TRUSTLINE_ACCOUNT_ID | TEXT | The address of the account whose trustline is no longer sponsored |
| TRUSTOR_MUXED | TEXT | If the trusting account is multiplexed, the virtual address of the account |
| TRUSTOR_MUXED_ID | NUMBER | If the trusting account is multiplexed, the integer representation of the virtual address of the account |
| FACT_OPERATIONS_ID | TEXT | Unique primary key for the dimension table, used as the main identifier for each record. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was last modified. |
