Stablecoin Transfers (XRPL) - Dune Docs

The stablecoins_xrpl.transfers table contains curated stablecoin transfer records on XRPL. One row represents one stablecoin transfer. Coverage starts with RLUSD. token_address is the XRPL asset id (issuer:currency).

Table schema

Column	Type	Description
`blockchain`	`VARCHAR`	Chain name (`xrpl`)
`block_month`	`DATE`	First day of month (partition column)
`block_date`	`DATE`	Transaction date
`block_time`	`TIMESTAMP`	Transaction timestamp
`block_number`	`BIGINT`	XRPL ledger index
`tx_hash`	`VARCHAR`	Transaction hash
`evt_index`	`BIGINT`	Always `NULL`
`trace_address`	`ARRAY(BIGINT)`	Always `NULL`
`token_standard`	`VARCHAR`	Token standard (`issued`)
`token_address`	`VARCHAR`	XRPL asset id
`token_symbol`	`VARCHAR`	Token symbol
`currency`	`VARCHAR`	ISO 4217 currency code
`amount_raw`	`UINT256`	Raw transfer amount
`amount`	`DOUBLE`	Decimals-adjusted amount
`price_usd`	`DOUBLE`	USD price used for valuation
`amount_usd`	`DOUBLE`	USD amount
`from`	`VARCHAR`	Sender account
`to`	`VARCHAR`	Recipient account
`unique_key`	`VARCHAR`	Unique transfer identifier

Sample Queries

SELECT
    t.block_date
    , SUM(t.amount_usd) AS volume_usd
    , COUNT(*) AS transfers
FROM stablecoins_xrpl.transfers AS t
WHERE t.token_symbol = 'RLUSD'
    AND t.block_date >= CURRENT_DATE - INTERVAL '30' DAY
GROUP BY t.block_date
ORDER BY t.block_date DESC

Notes

For partition pruning, filter by block_month.
History starts on 2024-12-17.