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
Daily OHLCV (open, high, low, close, volume) price data for all trading pairs on the XRP Ledger decentralized exchange (DEX), combining both the central limit order book (CLOB) and automated market maker (AMM) pools. Each row represents one trading pair per calendar day, with all prices expressed as counter token units per one unit of base token. Pair direction is normalized for consistency so the same pair always appears with the same base/counter assignment regardless of which side initiated the trade. Use this table for price charting, liquidity analysis, and DEX volume reporting.Column Descriptions
| Column | type | Description |
|---|---|---|
| ledger_close_date | date | Calendar date of the trading day; all trades for this pair on this date are aggregated into one row |
| base_token_id | bigint | Surrogate key for the base token in the trading pair (→ tokens) |
| base_token_currency | string | Currency code of the base token; ‘XRP’ for native XRP |
| base_token_issuer | string | XRPL address of the base token issuer; null for native XRP |
| counter_token_id | bigint | Surrogate key for the counter (quote) token in the trading pair (→ tokens) |
| counter_token_currency | string | Currency code of the counter token; ‘XRP’ for native XRP |
| counter_token_issuer | string | XRPL address of the counter token issuer; null for native XRP |
| open_price | double | Price of the first trade of the day, expressed as counter token units per one base token |
| high_price | double | Highest trade price recorded during the day, expressed as counter token units per one base token |
| low_price | double | Lowest trade price recorded during the day, expressed as counter token units per one base token |
| close_price | double | Price of the last trade of the day, expressed as counter token units per one base token |
| vwap_price | double | Volume-weighted average price for the day, calculated as the sum of (price × base amount) divided by total base volume |
| volume | double | Total base token amount traded across all CLOB and AMM activity on this day |
| clob_trade_count | bigint | Number of order-book trades (OfferCreate and Payment transactions) included in this day’s aggregation |
| amm_swap_count | bigint | Number of automated market maker (AMM) pool swaps included in this day’s aggregation |
| total_dex_tx_count | bigint | Total number of DEX transactions for this pair on this day, combining CLOB trades and AMM swaps |