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 every validated transaction recorded on the XRP Ledger, covering payments, token operations, DEX trades, NFT activity, and more. Use this table to analyze on-chain transaction volume, fees, outcomes, and account behavior over time.Column Descriptions
| Column | type | Description |
|---|---|---|
| transaction_id | bigint | Unique surrogate primary key for the transaction record |
| transaction_hash | string | Cryptographic hash uniquely identifying the transaction on the XRP Ledger; used for cross-referencing with on-chain data |
| transaction_type | string | Transaction category (e.g., Payment, OfferCreate, TrustSet, NFTokenMint); determines applicable fields and behavior |
| transaction_result | string | Final outcome code (e.g., tesSUCCESS, tecNO_DST), indicating whether the transaction succeeded or the reason for failure |
| ledger_close_date | date | Calendar date the ledger containing this transaction was closed |
| ledger_close_time | timestamp | Precise timestamp the ledger was closed and the transaction was confirmed |
| ledger_index | bigint | Sequence number of the ledger in which this transaction was included |
| transaction_index | bigint | Position of this transaction within its ledger, reflecting execution order |
| transaction_fee | decimal(38,6) | XRP fee consumed by this transaction, expressed in XRP |
| account_id | bigint | Surrogate key for the sending account (→ accounts) |
| account_address | string | XRPL address of the transaction sender |
| destination_id | bigint | Surrogate key for the receiving account (→ accounts) |
| destination_address | string | XRPL address of the transaction recipient |
| destination_tag | bigint | Off-ledger routing tag identifying the intended beneficiary at the destination address (e.g., a customer account at an exchange) |
| account_transaction_id | string | Chained hash linking to the sender’s previous transaction, used to enforce transaction ordering |
| delivered_amount | struct(currency: string, issuer: string, value: string, mpt_issuance_id: string) | Actual amount delivered to the destination, structured with currency, issuer, value, and MPT issuance ID |
| flags | bigint | Bitwise integer encoding transaction-specific behavior modifiers |
| last_ledger_sequence | bigint | Maximum ledger index at which the transaction remains valid; used to bound transaction expiry |
| memos | array(json) | Array of arbitrary key-value memo objects attached to the transaction for off-ledger annotation or metadata |
| signers | array(json) | Array of signers for multi-signature transactions, each containing account, public key, and signature |
| signing_pub_key | string | Hex-encoded public key used to authorize a single-signed transaction |
| source_tag | bigint | Off-ledger routing tag identifying the originating customer or purpose at the sending address |
| ticket_sequence | bigint | Sequence number of the ticket used in place of a standard account sequence, enabling out-of-order transaction submission |
| transaction_sequence | bigint | Account sequence number ensuring replay protection and ordering for transactions from the same sender |
| transaction_signature | string | Cryptographic signature proving the transaction was authorized by the account’s private key |
| uri | string | URI associated with the transaction, typically used in NFT-related transactions to reference off-chain metadata |