| 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 column |
| 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 | SHARES_RECEIVED column |
| RESERVE_A_MIN_AMOUNT | FLOAT | RESERVE_A_MIN_AMOUNT column |
| RESERVE_B_MIN_AMOUNT | FLOAT | RESERVE_B_MIN_AMOUNT column |
| 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_<batchenddate>-<dagalias>”. 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 batchid, the date represents the interval of ledgers processed. The batch run date can be seen as a proxy of closedat 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 invokehostfunction. |
| 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. |
