| OP_ID | NUMBER | Unique identifier for the operation. |
| OP_SOURCE_ACCOUNT | TEXT | Source account for the operation. |
| OP_SOURCE_ACCOUNT_MUXED | TEXT | Muxed source account for the operation. |
| 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’. |
| AMOUNT | FLOAT | Float representation of the amount of an asset sent/offered/etc. |
| ASSET | TEXT | The asset available to be claimed in the form of “asset_code:issuing_address”. If the claimable balance is in XLM, it is reported as “native” |
| 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. |
| AUTHORIZE | BOOLEAN | Indicates whether the trustline is authorized. |
| BALANCE_ID | TEXT | The balance id of the claimable balance. |
| CLAIMANT | TEXT | The account address of the account which claimed the claimable balance |
| 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 |
| 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) |
| 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 |
| 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. |
| FROM_ACCOUNT | TEXT | The account address from which the payment/contract originates (the sender account) |
| 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 | TEXT | The account address that funds a new 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 |
| 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 | The account address specifying where to send inflation funds. The concept of inflation on the network has been discontinued |
| INTO_ACCOUNT | TEXT | The account address receiving the deleted account’s lumens. |
| 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 |
| 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 | An 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 transaction. |
| 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. |
| 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_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. |
| 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 | TEXT | The issuing account address. |
| 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 |
| TRUSTOR | TEXT | The trusting account address. |
| 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 |
| TRUSTLINE_ACCOUNT_ID | TEXT | The address of the account whose trustline is no longer sponsored |
| 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. |
| 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. |
| 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_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_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 | Number of pool shares received for deposit. |
| RESERVE_A_MIN_AMOUNT | FLOAT | Minimum withdrawal amount for first reserve asset. |
| RESERVE_B_MIN_AMOUNT | FLOAT | Minimum withdrawal amount for second reserve asset. |
| 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. |
| TX_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. |
| 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. |
| 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. |
| DETAILS_JSON | VARIANT | JSON record containing operation-specific details. |
| 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. |
| TRANSACTION_HASH | TEXT | Hash of the transaction. |
| LEDGER_SEQUENCE | NUMBER | The sequence number of the ledger. |
| TX_ACCOUNT | TEXT | Account executing the transaction. |
| ACCOUNT_SEQUENCE | NUMBER | Sequence number for the account. |
| MAX_FEE | NUMBER | Maximum fee for the transaction. |
| TX_OPERATION_COUNT | NUMBER | Number of operations in the transaction. |
| TX_CREATED_AT | TIMESTAMP_NTZ | Creation timestamp of the transaction. |
| MEMO_TYPE | TEXT | Type of memo attached to transaction. |
| MEMO | TEXT | Memo content of the transaction. |
| TIME_BOUNDS | TEXT | Time bounds for transaction validity. |
| SUCCESSFUL | BOOLEAN | Whether the operation was successful. |
| FEE_CHARGED | NUMBER | Actual fee charged for the operation. |
| FEE_ACCOUNT | TEXT | Account charged the fee. |
| NEW_MAX_FEE | NUMBER | Updated maximum fee. |
| ACCOUNT_MUXED | TEXT | Muxed account identifier. |
| FEE_ACCOUNT_MUXED | TEXT | Muxed fee account identifier. |
| LEDGER_BOUNDS | TEXT | Bounds of the ledger. |
| MIN_ACCOUNT_SEQUENCE | NUMBER | Minimum account sequence number. |
| MIN_ACCOUNT_SEQUENCE_AGE | NUMBER | Minimum age of account sequence. |
| MIN_ACCOUNT_SEQUENCE_LEDGER_GAP | NUMBER | Minimum gap in ledger sequences. |
| EXTRA_SIGNERS | ARRAY | Additional transaction signers. |
| RESOURCE_FEE | NUMBER | Fee for resource usage. |
| SOROBAN_RESOURCES_INSTRUCTIONS | NUMBER | Instructions for Soroban resources. |
| SOROBAN_RESOURCES_READ_BYTES | NUMBER | Bytes read by Soroban resources. |
| SOROBAN_RESOURCES_WRITE_BYTES | NUMBER | Bytes written by Soroban resources. |
| TRANSACTION_RESULT_CODE | TEXT | Result code of the transaction. |
| INCLUSION_FEE_BID | NUMBER | Bid for inclusion fee. |
| INCLUSION_FEE_CHARGED | NUMBER | Actual inclusion fee charged. |
| RESOURCE_FEE_REFUND | NUMBER | Refund of resource fee. |
| LEDGER_HASH | TEXT | The hex-encoded SHA-256 hash that represents the ledger’s XDR-encoded form. |
| PREVIOUS_LEDGER_HASH | TEXT | The hex-encoded SHA-256 hash of the ledger that immediately precedes this ledger. |
| TRANSACTION_COUNT | NUMBER | The number of successful transactions submitted and completed by the network in this ledger. |
| LEDGER_OPERATION_COUNT | NUMBER | Number of operations in the ledger. |
| LEDGER_ID | NUMBER | Unique identifier for the ledger |
| TOTAL_COINS | NUMBER | Total number of lumens in circulation |
| FEE_POOL | NUMBER | The sum of all transaction fees |
| BASE_FEE | NUMBER | The fee (in stroops) the network charges per operation in a transaction for the given ledger. The minimum base fee is 100, with the ability to increase if transaction demand exceeds ledger capacity. When this occurs, the ledger enters surge pricing. |
| BASE_RESERVE | NUMBER | The reserve (in stroops) the network requires an account to retain as a minimum balance in order to be a valid account on the network. The current minimum reserve is 10 XLM. |
| MAX_TX_SET_SIZE | NUMBER | The maximum number of operations that Stellar validator nodes have agreed to process in a given ledger. Since Protocol 11, ledger capacity has been measured in operations rather than transactions. |
| PROTOCOL_VERSION | NUMBER | The protocol verstion that the Stellar network was running when this ledger was committed. Protocol versions are released ~every 6 months. |
| SUCCESSFUL_TRANSACTION_COUNT | NUMBER | The number of successful transactions submitted and completed by the network in this ledger |
| FAILED_TRANSACTION_COUNT | NUMBER | The number of failed transactions submitted to the network in this ledger. The transaction was still paid for but contained an error that prevented it from executing |
| SOROBAN_FEE_WRITE_1KB | NUMBER | The fee associated with writing 1KB of data to the Soroban ledger.The write fee is dynamic fee that grows linearly with the size of the ledger. The write fee for a given ledger is recorded in the ledger header and has a direct relationship to the bucketlist size of the ledger db. |
| NODE_ID | TEXT | The id of winning validator node which is allowed to write transaction set to the network. The winning validator is decided by the network. |
| SIGNATURE | TEXT | The signing hash of the validator node which writes the transaction set to the network.This signature ensures the integrity and authenticity of the ledger, confirming that it has not been tampered with. |
| TOTAL_BYTE_SIZE_OF_BUCKET_LIST | NUMBER | Total size in bytes of the bucket list |
| NON_REFUNDABLE_RESOURCE_FEE_CHARGED | NUMBER | The amount of the resource fee charged for the transaction that is non-refundable. |
| REFUNDABLE_RESOURCE_FEE_CHARGED | NUMBER | The amount of the resource fee charged for the transaction that is refundable. |
| RENT_FEE_CHARGED | NUMBER | The fee charged for renting resources on the network, such as storage space for data. |
| TX_SIGNERS | TEXT | The public keys of the signers who authorized the transaction. |
| REFUNDABLE_FEE | NUMBER | The portion of the transaction fee that is refundable under certain conditions. |
| 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. |
