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
A unified view of all activity in XRP Ledger AMM liquidity pools, combining deposits, withdrawals, fee-setting votes, and auction-slot bids in a single table for cross-event analytics. Each row represents one AMM event with the event category identified by event_type; columns specific to a particular event kind are null for rows of other types. Covers all AMM events recorded on the XRPL mainnet since the AMM amendment was activated.Column Descriptions
| Column | type | Description |
|---|---|---|
| pool_id | bigint | Surrogate key identifying the AMM liquidity pool in which this event occurred. |
| pool_address | string | On-ledger XRP Ledger account address of the AMM pool (the pool’s own account), provided for direct lookup on explorers. |
| transaction_id | bigint | Internal surrogate key for the on-ledger transaction that triggered this event. |
| transaction_hash | string | Cryptographic hash of the XRP Ledger transaction that triggered this event, usable for direct ledger lookup. |
| account_id | bigint | Internal surrogate key for the account that submitted the transaction. |
| account_address | string | XRP Ledger account address of the wallet that submitted the transaction. |
| transaction_type | string | XRPL transaction type (e.g. AMMDeposit, AMMWithdraw, AMMBid, AMMVote) as recorded on the ledger. |
| event_type | string | Business category of this AMM event: Deposit or Withdraw for liquidity changes, AMMBid for auction-slot bids, AMMVote for fee-setting votes. |
| timestamp | timestamp | UTC timestamp of the ledger close in which this event was confirmed. |
| date | date | Calendar date (UTC) of the ledger close, used for daily partitioning and time-series analysis. |
| event_id | varchar | Unique identifier for liquidity events (Deposit or Withdraw); null for bids and votes. |
| token_a_amount | double | Amount of Token A deposited or withdrawn in this liquidity event; null for bids and votes. |
| token_b_amount | double | Amount of Token B deposited or withdrawn in this liquidity event; null for bids and votes. |
| lp_token_amount | double | Amount of LP tokens minted (Deposit), burned (Withdraw), or bid in an auction-slot contest (AMMBid); null for votes. |
| token_a_amount_before | double | Pool balance of Token A immediately before this liquidity event; null for bids and votes. |
| token_a_amount_after | double | Pool balance of Token A immediately after this liquidity event; null for bids and votes. |
| token_b_amount_before | double | Pool balance of Token B immediately before this liquidity event; null for bids and votes. |
| token_b_amount_after | double | Pool balance of Token B immediately after this liquidity event; null for bids and votes. |
| lp_token_amount_before | double | Total LP token supply outstanding immediately before this event; null for votes. |
| lp_token_amount_after | double | Total LP token supply outstanding immediately after this liquidity event; null for bids and votes. |
| bid_id | bigint | Surrogate key for the auction-slot bid record; populated only for AMMBid events, null otherwise. |
| is_winning_bid | boolean | True if this bid successfully claimed the AMM auction slot; populated only for AMMBid events. |
| slot_duration | integer | Duration in seconds that the bidder holds the auction slot after winning, capped at 86,400 (24 hours); populated only for AMMBid events. |
| replaced_by_bid_id | bigint | Surrogate key of the subsequent bid that displaced this auction slot; populated only for AMMBid events. |
| replaced_by_bid_transaction_hash | string | Transaction hash of the bid that replaced this auction slot, enabling chain-of-custody tracing; populated only for AMMBid events. |
| vote_id | bigint | Surrogate key for the fee-vote record; populated only for AMMVote events, null otherwise. |
| vote_trading_fee | integer | Trading fee requested by the voting liquidity provider, in units of 1/100,000 (e.g. 1000 = 1%); populated only for AMMVote events. |
| final_trading_fee | integer | Effective pool trading fee in units of 1/100,000 after incorporating this vote’s LP-weighted influence; populated only for AMMVote events. |
| auction_slot | string | JSON snapshot of the pool’s auction-slot state at the time of this vote, showing the current slot holder and expiry time; populated only for AMMVote events. |