Stablecoin Balances Enriched (XRPL) - Dune Docs

The stablecoins_xrpl.balances_enriched table extends XRPL stablecoin balances with address classification, whale flags, and a circulating supply flag. 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

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.