Documentation Index
Fetch the complete documentation index at: https://docs.dune.com/llms.txt
Use this file to discover all available pages before exploring further.
Table Description
Contains all Automated Market Maker (AMM) liquidity pools on the XRP Ledger, one row per pool. Each pool pairs two assets and issues LP tokens to liquidity providers in return for their deposit. Use this table to analyze pool composition, trading fees, liquidity depth, and pool lifecycle events.Column Descriptions
| Column | type | Description |
|---|---|---|
| pool_id | bigint | Unique surrogate primary key for the AMM pool record |
| amm_account_id | bigint | The on-ledger account that represents this AMM pool (→ accounts) |
| amm_account_address | string | XRPL address of the AMM pool’s on-ledger account |
| token_a_id | bigint | Surrogate key for the first asset in the pool (→ tokens) |
| token_a_currency | string | Currency code of the first pool asset (e.g. XRP, USD, or a hex-encoded custom code) |
| token_a_issuer_address | string | XRPL address of the account that issued the first pool asset; null if the asset is XRP |
| token_a_pool_balance | double | Current reserve of the first asset held in the pool; shifts with each swap |
| token_b_id | bigint | Surrogate key for the second asset in the pool (→ tokens) |
| token_b_currency | string | Currency code of the second pool asset (e.g. XRP, USD, or a hex-encoded custom code) |
| token_b_issuer_address | string | XRPL address of the account that issued the second pool asset; null if the asset is XRP |
| token_b_pool_balance | double | Current reserve of the second asset held in the pool; shifts with each swap |
| lp_token_id | bigint | Surrogate key for the LP token issued to liquidity providers in exchange for their deposit (→ tokens) |
| lp_token_currency | string | Currency code of the LP token representing a proportional share of this pool |
| lp_token_balance | varchar | Total outstanding LP token supply across all liquidity providers, stored as a string to preserve XRPL IOU precision; cast to a numeric type for arithmetic. Decreases as providers withdraw |
| trading_fee | double | Percentage fee charged on each swap through this pool; collected and shared among liquidity providers |
| created_ledger_index | bigint | Ledger index at which this AMM pool was created |
| created_timestamp | timestamp | Timestamp when this AMM pool was created |
| last_updated_ledger_index | bigint | Ledger index of the most recent swap, deposit, or withdrawal that changed this pool’s state |
| last_updated_timestamp | timestamp | Timestamp of the most recent change to this pool’s state |
| current_xrp_balance | double | Current XRP balance of the AMM pool account, if one of the paired assets is XRP |
| is_deleted | boolean | Whether this pool has been dissolved and is no longer active on the ledger |
| deleted_timestamp | timestamp | Timestamp when this pool was dissolved; null if still active |