| address | The address of the account. The address is the account's public key encoded in base32. All account addresses start with a `G` | string | | | | cluster | | |
| address_muxed | Address multiplexed | string | | | | | | |
| operation_id | Unique identifier for an operation | integer | | | | cluster | | |
| type | The number indicating which type of effect | integer | | | | cluster | | |
| type_string | The string indicating which type of effect | string | | | | | | |
| details | Unstructured JSON object that contains details based on the type of effect. Each effect will return its own relevant details, with the rest of the details as null | record | | | | | | |
| details.liquidity_pool | Liquidity pools provide a simple, non-interactive way to trade large amounts of capital and enable high volumes of trading | record | | | | | | |
| details.liquidity_pool.fee_bp | The number of basis points charged as a percentage of the trade in order to complete the transaction. The fees earned on all trades are divided amongst pool shareholders and distributed as an incentive to keep money in the pools | integer | | | | | | |
| details.liquidity_pool.id | 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. | string | | | | | | |
| details.liquidity_pool.total_shares | Total number of pool shares issued | numeric | | | | | | |
| details.liquidity_pool.total_trustlines | Number of trustlines for the associated pool shares | integer | | | | | | |
| details.liquidity_pool.type | 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. | string | | | | | | |
| details.liquidity_pool.reserves | Reserved asset in liquidity pool | record | | | | | | |
| details.liquidity_pool.reserves.asset | Reserve asset | string | | | | | | |
| details.liquidity_pool.reserves.amount | Reserve asset amount | numeric | | | | | | |
| details.reserves_received | Asset amount received for reserves from liquidity pool withdraw | record | | | | | | |
| details.reserves_received.asset | Recieved asset | string | | | | | | |
| details.reserves_received.amount | Recieved asset amount | numeric | | | | | | |
| details.reserves_deposited | Asset amount deposited for reserves from liquidity pool deposit | record | | | | | | |
| details.reserves_deposited.asset | Deposited asset | string | | | | | | |
| details.reserves_deposited.amount | Deposited asset amount | numeric | | | | | | |
| details.reserves_revoked | Asset amount revoked for reserves from liquidity pool revoke | record | | | | | | |
| details.reserves_revoked.asset | Revoked asset | string | | | | | | |
| details.reserves_revoked.amount | Revoked asset amount | numeric | | | | | | |
| details.reserves_revoked.claimable_balance_id | Claimable balance id | string | | | | | | |
| details.bought | Asset bought from trade | record | | | | | | |
| details.bought.asset | Asset bought | string | | | | | | |
| details.bought.amount | Asset amount bought | numeric | | | | | | |
| details.sold | Asset sold from trade | record | | | | | | |
| details.sold.asset | Asset sold | string | | | | | | |
| details.sold.amount | Asset amount sold | numeric | | | | | | |
| details.shares_revoked | Shares revoked from liquidity pool revoke | numeric | | | | | | |
| details.shares_received | Shares received from liquidity pool deposit | numeric | | | | | | |
| details.shares_redeemed | Shares redeemed from liquidity pool withrdaw | numeric | | | | | | |
| details.liquidity_pool_id | Unique identifier for a liquidity pool | string | | | | | | |
| details.balance_id | The 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 balance | string | | | | | | |
| details.new_seq | New sequence number after bump sequence | integer | | | | | | |
| details.name | The 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. | string | | | | | | |
| details.value | Value of data from manage data effect | string | | | | | | |
| details.trustor | Account address of trustor | string | | | | | | |
| details.limit | The upper bound amount of an asset that an account can hold | numeric | | | | | | |
| details.inflation_destination | Inflation destination account id | string | | | | | | |
| details.authorized_flag | Auth value for set trustline flags | boolean | | | | | | |
| details.auth_immutable_flag | Auth value for set trustline flags | boolean | | | | | | |
| details.authorized_to_maintain_liabilites | Auth value for set trustline flags | boolean | | | | | | |
| details.auth_revocable_flag | Auth value for set trustline flags | boolean | | | | | | |
| details.auth_required_flag | Auth value for set trustline flags | boolean | | | | | | |
| details.auth_clawback_enabled_flag | Auth value for set trustline flags | boolean | | | | | | |
| details.claimable_balance_clawback_enabled_flag | Auth value for set trustline flags | boolean | | | | | | |
| details.clawback_enabled_flag | Auth value for set trustline flags | boolean | | | | | | |
| details.high_threshold | 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. | integer | | | | | | |
| details.med_threshold | 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. | integer | | | | | | |
| details.low_threshold | 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. | integer | | | | | | |
| details.home_domain | The home domain used for the stellar.toml file discovery | string | | | | | | |
| details.asset_issuer | The account address of the original asset issuer that created the asset | string | | | | | | |
| details.asset | Asset on network | string | | | | | | |
| details.asset_code | The 4 or 12 character code representation of the asset on the network | string | | | | | | |
| details.asset_type | The identifier for type of asset code, can be a alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM. | string | | | | | | |
| details.signer | The address of the account that is allowed to authorize (sign) transactions for another account. This process is called multi-sig | string | | | | | | |
| details.sponsor | The account address of the sponsor who is paying the reserves for this signer | string | | | | | | |
| details.new_sponsor | The new account address of the sponsor who is paying the reserves for this signer | string | | | | | | |
| details.former_sponsor | The former account address of the sponsor who is paying the reserves for this signer | string | | | | | | |
| details.weight | Signer weight | integer | | | | | | |
| details.public_key | Signer public key | string | | | | | | |
| details.amount | Asset amount | numeric | | | | | | |
| details.starting_balance | Account asset starting balance | numeric | | | | | | |
| details.seller | Selling account | string | | | | | | |
| details.seller_muxed | Account multiplexed | string | | | | | | |
| details.seller_muxed_id | Account multiplexed id | integer | | | | | | |
| details.offer_id | The unique id for the offer. This id can be joined with the `offers` table | integer | | | | | | |
| details.sold_amount | Amount of asset sold | numeric | | | | | | |
| details.sold_asset_type | The identifier for type of asset code, can be a alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM. | string | | | | | | |
| details.sold_asset_code | The 4 or 12 character code representation of the asset on the network | string | | | | | | |
| details.sold_asset_issuer | The account address of the original asset issuer that created the asset | string | | | | | | |
| details.bought_asset_type | The identifier for type of asset code, can be a alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM. | string | | | | | | |
| details.bought_asset_code | The 4 or 12 character code representation of the asset on the network | string | | | | | | |
| details.bought_asset_issuer | The account address of the original asset issuer that created the asset | string | | | | | | |
| details.bought_amount | Amount of asset bought | numeric | | | | | | |
| details.data_name | Ledger entry data name | string | | | | | | |
| details.predicate | The condition which must be satisfied so the destination can claim the balance. The predicate can include logical rules using AND, OR and NOT logic. | record | | | | | | |
| details.predicate.not | | record | | | | | | |
| details.predicate.not.abs_before | | string | | | | | | |
| details.predicate.not.rel_before | | integer | | | | | | |
| details.predicate.not.unconditional | | boolean | | | | | | |
| details.predicate.not.and | | record | | | | | | |
| details.predicate.not.and.abs_before | | string | | | | | | |
| details.predicate.not.and.rel_before | | integer | | | | | | |
| details.predicate.not.and.unconditional | | boolean | | | | | | |
| details.predicate.not.and.abs_before_epoch | | integer | | | | | | |
| details.predicate.not.or | | record | | | | | | |
| details.predicate.not.or.abs_before | | string | | | | | | |
| details.predicate.not.or.rel_before | | integer | | | | | | |
| details.predicate.not.or.unconditional | | boolean | | | | | | |
| details.predicate.not.or.abs_before_epoch | | integer | | | | | | |
| details.predicate.not.not | | record | | | | | | |
| details.predicate.not.not.abs_before | | string | | | | | | |
| details.predicate.not.not.rel_before | | integer | | | | | | |
| details.predicate.not.not.unconditional | | boolean | | | | | | |
| details.predicate.not.not.abs_before_epoch | | integer | | | | | | |
| details.predicate.not.abs_before_epoch | | integer | | | | | | |
| details.predicate.type | | integer | | | | | | |
| details.predicate.and | | record | | | | | | |
| details.predicate.and.abs_before | | string | | | | | | |
| details.predicate.and.rel_before | | integer | | | | | | |
| details.predicate.and.unconditional | | boolean | | | | | | |
| details.predicate.and.and | | record | | | | | | |
| details.predicate.and.and.abs_before | | string | | | | | | |
| details.predicate.and.and.rel_before | | integer | | | | | | |
| details.predicate.and.and.unconditional | | boolean | | | | | | |
| details.predicate.and.and.abs_before_epoch | | integer | | | | | | |
| details.predicate.and.or | | record | | | | | | |
| details.predicate.and.or.abs_before | | string | | | | | | |
| details.predicate.and.or.rel_before | | integer | | | | | | |
| details.predicate.and.or.unconditional | | boolean | | | | | | |
| details.predicate.and.or.abs_before_epoch | | integer | | | | | | |
| details.predicate.and.not | | record | | | | | | |
| details.predicate.and.not.abs_before | | string | | | | | | |
| details.predicate.and.not.rel_before | | integer | | | | | | |
| details.predicate.and.not.unconditional | | boolean | | | | | | |
| details.predicate.and.not.abs_before_epoch | | integer | | | | | | |
| details.predicate.and.abs_before_epoch | | integer | | | | | | |
| details.predicate.or | | record | | | | | | |
| details.predicate.or.abs_before | | string | | | | | | |
| details.predicate.or.rel_before | | integer | | | | | | |
| details.predicate.or.unconditional | | boolean | | | | | | |
| details.predicate.or.and | | record | | | | | | |
| details.predicate.or.and.abs_before | | string | | | | | | |
| details.predicate.or.and.rel_before | | integer | | | | | | |
| details.predicate.or.and.unconditional | | boolean | | | | | | |
| details.predicate.or.and.not | | record | | | | | | |
| details.predicate.or.and.not.abs_before | | string | | | | | | |
| details.predicate.or.and.not.rel_before | | integer | | | | | | |
| details.predicate.or.and.not.unconditional | | boolean | | | | | | |
| details.predicate.or.and.not.abs_before_epoch | | integer | | | | | | |
| details.predicate.or.and.abs_before_epoch | | integer | | | | | | |
| details.predicate.or.or | | record | | | | | | |
| details.predicate.or.or.abs_before | | string | | | | | | |
| details.predicate.or.or.rel_before | | integer | | | | | | |
| details.predicate.or.or.unconditional | | boolean | | | | | | |
| details.predicate.or.or.abs_before_epoch | | integer | | | | | | |
| details.predicate.or.not | | record | | | | | | |
| details.predicate.or.not.abs_before | | string | | | | | | |
| details.predicate.or.not.rel_before | | integer | | | | | | |
| details.predicate.or.not.unconditional | | boolean | | | | | | |
| details.predicate.or.not.abs_before_epoch | | integer | | | | | | |
| details.predicate.or.abs_before_epoch | | integer | | | | | | |
| details.predicate.abs_before | Deadline for when the balance must be claimed. If a balance is claimed before the date then the clause of the condition is satisfied. | string | | | | | | |
| details.predicate.rel_before | A relative deadline for when the claimable balance can be claimed. The value represents the number of seconds since the close time of the ledger which created the claimable balance #### Notes: This condition is useful when creating a timebounds based on creation conditions. If the creator wanted a balance only claimable one week after creation, this condition would satisfy that rule. | integer | | | | | | |
| details.predicate.unconditional | If true it means this clause of the condition is always satisfied. #### Notes: When the predicate is only unconditional = true, it means that the balance can be claimed under any conditions | boolean | | | | | | |
| details.predicate.abs_before_epoch | A UNIX epoch value in seconds representing the same deadline date as abs_before. | integer | | | | | | |
| batch_id | 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 | string | | | | | | |
| batch_run_date | 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. | datetime | | | | MONTH partition | | |
| batch_insert_ts | 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 | timestamp | | | | | | |