XRPL Token Transfers

The tokens_xrpl.transfers table contains token movement data for XRP Ledger assets indexed on Dune. It brings native XRP transfers, issued currency payments, checks, escrows, payment channel claims, and AMM-related token movement into one curated table. This dataset includes:

Native XRP and issued currency transfer rows
Payment, check, escrow, payment channel, AMM deposit, and AMM withdraw activity
Asset identifiers using xrpl_asset_id, issuer, currency, and currency hex fields
USD valuation when an hourly USD price is available for the asset

This table represents token movement on XRP Ledger, not just simple Payment transactions. It also includes AMM liquidity movements and other transaction types that move XRP or issued currencies, so filter by transfer_type or transaction_type when you need a narrower view.

Utility

The XRPL transfers table provides a consistent view of token movement on XRP Ledger, enabling you to:

Track flows of XRP and issued currencies between XRPL accounts
Analyze transfer activity by asset, issuer, transaction type, and day
Separate regular payments from checks, escrows, payment channels, and AMM liquidity activity
Monitor partial payments and transaction results alongside the normalized transfer amount

Methodology

According to the official XRP Ledger docs, fungible assets include native XRP and issued currencies held through trust lines, while Payment transactions can deliver XRP or issued currencies and may also use partial payment semantics. XRPL also has protocol-native checks, escrows, payment channels, and AMM deposit and withdraw transactions that can move assets. The tokens_xrpl.transfers table is built around those XRPL transaction semantics:

It keeps successful XRPL transactions that produce token movement, including Payment, CheckCash, EscrowFinish, PaymentChannelClaim, AMMDeposit, and AMMWithdraw.
It normalizes native XRP and issued currencies into a shared transfer schema with from, to, issuer, currency, symbol, and xrpl_asset_id.
It labels each row with both the underlying transaction_type and a normalized transfer_type, such as payment, check_cash, escrow_finish, payment_channel_claim, amm_deposit, amm_withdraw, amm_lp_mint, and amm_lp_burn.
It carries partial_payment_flag for XRPL Payment rows where partial payment semantics apply.
Native XRP uses 6 decimals; issued currencies may not have a decimal value populated because XRPL issued currencies use their own decimal representation.

Pricing Methodology

The price_usd and amount_usd columns come from Dune’s external hourly price feed for XRPL assets. If an asset has a price for that hour, the transfer row gets a USD price and value. If not, both columns stay NULL. For more details on Dune’s pricing methodology, see the Prices documentation.

Table Schema

Column	Type	Description
`unique_key`	`VARCHAR`	Surrogate key to identify a unique transfer row
`blockchain`	`VARCHAR`	Blockchain name; always `xrpl`
`block_month`	`DATE`	Month of the ledger close time
`block_date`	`DATE`	Date of the ledger close time
`block_time`	`TIMESTAMP WITH TIME ZONE`	Ledger close timestamp
`block_number`	`BIGINT`	XRPL ledger index
`tx_hash`	`VARCHAR`	Transaction hash
`token_standard`	`VARCHAR`	Token standard label, such as `native` or `issued`
`tx_from`	`VARCHAR`	Account that submitted the transaction
`tx_to`	`VARCHAR`	Destination account from the transaction when available
`tx_index`	`BIGINT`	Transaction index within the ledger
`from`	`VARCHAR`	Source account for the token movement
`to`	`VARCHAR`	Destination account for the token movement
`xrpl_asset_id`	`VARCHAR`	Dune asset identifier for the XRPL asset
`issuer`	`VARCHAR`	Issuer account for issued currencies; native XRP uses the native XRP identifier
`currency`	`VARCHAR`	XRPL currency code or native XRP symbol
`currency_hex`	`VARCHAR`	Hex-encoded currency code when applicable
`symbol`	`VARCHAR`	Display symbol for the asset
`decimals`	`INTEGER`	Number of decimals used to scale `amount_raw` when available
`amount_raw`	`DOUBLE`	Raw amount from the XRPL transfer representation
`amount`	`DOUBLE`	Normalized transfer amount
`price_usd`	`DOUBLE`	Hourly USD price used to calculate `amount_usd`
`amount_usd`	`DOUBLE`	USD value of the transfer
`transfer_type`	`VARCHAR`	Normalized transfer category
`transaction_type`	`VARCHAR`	Underlying XRPL transaction type
`transaction_result`	`VARCHAR`	XRPL transaction result code
`partial_payment_flag`	`BOOLEAN`	Whether the transaction used XRPL partial payment semantics
`_updated_at`	`TIMESTAMP WITH TIME ZONE`	Timestamp when the curated row was last written

Sample Queries

Query token movement for a specific XRPL account This query returns recent incoming and outgoing token transfers for an XRPL account:

SELECT
    block_time,
    tx_hash,
    symbol,
    transfer_type,
    transaction_type,
    CASE
        WHEN "from" = 'r3CUuqXukpx393PvgP6Cn2z3kx5vPmesWf' THEN 'Outgoing'
        WHEN "to" = 'r3CUuqXukpx393PvgP6Cn2z3kx5vPmesWf' THEN 'Incoming'
    END AS direction,
    amount,
    amount_usd
FROM tokens_xrpl.transfers
WHERE (
        "from" = 'r3CUuqXukpx393PvgP6Cn2z3kx5vPmesWf'
        OR "to" = 'r3CUuqXukpx393PvgP6Cn2z3kx5vPmesWf'
    )
    AND block_date >= current_date - interval '30' day
ORDER BY block_time DESC
LIMIT 100

Calculate daily transfer volume for native XRP This query aggregates recent native XRP transfer activity:

SELECT
    block_date,
    symbol,
    COUNT(*) AS num_rows,
    SUM(amount) AS total_amount,
    SUM(amount_usd) AS total_amount_usd
FROM tokens_xrpl.transfers
WHERE xrpl_asset_id = 'xrp'
    AND block_date >= current_date - interval '30' day
GROUP BY 1, 2
ORDER BY 1 DESC

Split XRPL activity by transfer type This query separates regular payments from checks, escrows, payment channels, and AMM activity:

SELECT
    block_date,
    transfer_type,
    transaction_type,
    COUNT(*) AS num_rows,
    SUM(amount) AS total_amount,
    SUM(amount_usd) AS total_amount_usd
FROM tokens_xrpl.transfers
WHERE block_date >= current_date - interval '30' day
GROUP BY 1, 2, 3
ORDER BY 1 DESC, 4 DESC

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

XRPL Token Transfers

Utility

Methodology

Pricing Methodology

Table Schema

Sample Queries

​Utility

​Methodology

​Pricing Methodology

​Table Schema

​Sample Queries

Utility

Methodology

Pricing Methodology

Table Schema

Sample Queries