> ## 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 Enriched (XRPL)

> Daily stablecoin balances with address classification on XRPL

The `stablecoins_xrpl.balances_enriched` table extends XRPL stablecoin balances with address classification, whale flags, and a circulating supply flag.

> [card] [Gated dataset](https://dune.com/enterprise#contact-form)
>
> Querying this dataset requires an entitlement on your workspace. See [access tiers](https://docs.dune.com/data-catalog/overview.md#access-tiers-public-vs-gated-datasets), or contact the Dune team to enable access.

Known exchange accounts are labeled `cex` from the served entity lookup (house and hard). Other accounts are `unidentified_whale` at \$10M or more that day, otherwise `unidentified`.

## Table schema

| Column | Type | Description |
| - | - | - |
| `blockchain` | `VARCHAR` | Chain name (`xrpl`) |
| `day` | `DATE` | Balance date (partition column) |
| `address` | `VARCHAR` | Account address |
| `token_symbol` | `VARCHAR` | Token symbol |
| `token_address` | `VARCHAR` | XRPL asset id |
| `token_standard` | `VARCHAR` | Token standard (`issued`) |
| `token_id` | `VARCHAR` | Always `NULL` |
| `balance_raw` | `UINT256` | Raw balance |
| `balance` | `DOUBLE` | Decimals-adjusted balance |
| `balance_usd` | `DOUBLE` | USD value |
| `currency` | `VARCHAR` | ISO 4217 currency code |
| `address_category` | `VARCHAR` | Address category (see below) |
| `address_subcategory` | `VARCHAR` | Address subcategory |
| `address_project` | `VARCHAR` | Exchange entity key (nullable) |
| `address_version` | `VARCHAR` | Always `NULL` |
| `address_label` | `VARCHAR` | Exchange entity key (nullable) |
| `is_smart_contract` | `BOOLEAN` | Always `NULL` |
| `is_whale` | `BOOLEAN` | Account holds >= \$10M total stablecoins that day |
| `is_circulating` | `BOOLEAN` | `true` unless the account is a bridge escrow, an issuer bridge escrow, or the Binance stablecoin proof-of-assets wallet |
| `last_updated` | `TIMESTAMP` | Last balance update time |

## Address categories

| `address_category` | Allowed `address_subcategory` values | Description |
| - | - | - |
| `cex` | `cex` | Known exchange-controlled accounts. |
| `unidentified_whale` | `unidentified_whale` | Unlabeled accounts holding >= \$10M total stablecoin balance that day. |
| `unidentified` | `unidentified` | Accounts with no known classification. |

## Sample query

```sql theme={null}
SELECT
    b.day
    , b.address_category
    , SUM(b.balance_usd) AS balance_usd
FROM stablecoins_xrpl.balances_enriched AS b
WHERE b.day >= CURRENT_DATE - INTERVAL '30' DAY
GROUP BY b.day, b.address_category
ORDER BY b.day DESC
```

## Notes

* Updated daily.
* For best performance, filter by `day`.

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