> ## 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.

# Stablecoin Balances (XRPL)

> Daily stablecoin balances per account on XRPL

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`).

> [card] [Upgrade to the enriched dataset](https://docs.dune.com/data-catalog/curated/stablecoins/balances-enriched/stablecoins-xrpl-balances-enriched.md)
>
> Skip manual reconstruction. The enriched version packages attribution and methodology so you can move from raw data to insights faster.

## 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 |

[https://dune.com/embeds/3419983/5785629?table\_schema\_t6f0df=stablecoins\_xrpl\&table\_name\_t6f0df=balances](https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=stablecoins_xrpl\&table_name_t6f0df=balances)

## Sample Queries

```sql theme={null}
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`.

## Interpreting balances vs circulating supply

<ul><li>This table records onchain balances per address per day. Totals are not equivalent to circulating supply by default — bridge-locked, issuer-escrow, and CEX proof-of-assets balances are intentionally retained so you can analyze them.</li>
<li>Two metrics, two recipes:
<ul><li>**Total balances** — sum `balance_usd` with no exclusion filter. Includes bridge-locked funds (e.g., more than \$4B USDT can appear in the Tether `USDT0Adapter` contract on Ethereum while representing circulating `USDT0` on other chains), issuer escrow, and CEX-locked balances.</li>
<li>**Circulating supply** — this foundation table does not carry the `is_circulating` flag. Use the enriched balances table (`stablecoins_evm.balances_enriched`, `stablecoins_solana.balances_enriched`, or `stablecoins_tron.balances_enriched`) and filter `WHERE is_circulating = true`.</li></ul></li>
<li>We retain bridge / issuer-escrow / CEX-locked balances in the table itself because exclusions are not objective across bridge designs, and some bridge-held balances represent liquidity for chains not covered elsewhere. The `is_circulating` flag encodes Dune's best-known classification — readable, auditable, and revisable as coverage improves.</li></ul>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.