Stablecoin Balances (XRPL) - Dune Docs

The stablecoins_xrpl.balances table contains daily stablecoin balances per account on XRPL. One row represents one account-token balance snapshot for a specific day. Coverage starts with RLUSD. token_address is the XRPL asset id (issuer:currency).

Table schema

Column	Type	Description
`blockchain`	`VARCHAR`	Chain name (`xrpl`)
`day`	`DATE`	Balance date
`address`	`VARCHAR`	Account address
`token_symbol`	`VARCHAR`	Token symbol
`token_address`	`VARCHAR`	XRPL asset id
`token_standard`	`VARCHAR`	Token standard (`issued`)
`token_id`	`VARCHAR`	Token id (typically NULL)
`balance_raw`	`UINT256`	Raw balance
`balance`	`DOUBLE`	Decimals-adjusted balance
`balance_usd`	`DOUBLE`	USD value
`currency`	`VARCHAR`	ISO 4217 currency code
`last_updated`	`TIMESTAMP`	Last balance update time

Sample Queries

SELECT
    b.day
    , b.token_symbol
    , SUM(b.balance_usd) AS total_supply_usd
FROM stablecoins_xrpl.balances AS b
WHERE b.balance > 0
    AND b.day >= CURRENT_DATE - INTERVAL '30' DAY
GROUP BY b.day, b.token_symbol
ORDER BY b.day DESC

Notes

Balances are forward-filled by day.
For best performance, filter by day.
For multichain aggregate balances, see stablecoins_multichain.balances.