| id | This unique effect id is the concatenation of the operation id and the effect index | string | | Yes | |
| index | The index of the effect within the transaction. This index helps to order effects that result from the same transaction, indicating the sequence in which they occurred. | integer | | Yes | |
| closed_at | Timestamp in UTC when this ledger closed and committed to the network. Ledgers are expected to close ~every 5 seconds | timestamp | | Yes | |
| ledger_sequence | The sequence number of this ledger. It represents the order of the ledger within the Stellar blockchain. Each ledger has a unique sequence number that increments with every new ledger, ensuring that ledgers are processed in the correct order. | integer | | Yes | |
| 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 | | | |
| address_muxed | Address multiplexed | string | | | |
| operation_id | Unique identifier for an operation | integer | | | |
| type | The number indicating which type of effect | integer | | | |
| 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 | Received asset | string | | | |
| details.reserves_received.amount | Received 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 withdraw | 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_liabilities | 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 an 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 an 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 an 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 | | | |
| 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. | datetime | | | |
| batch_insert_ts | The timestamp in UTC when a batch of records was inserted into the database. | timestamp | | | |