Stablecoin Activity Enriched (XRPL) - Dune Docs

The stablecoins_xrpl.activity_enriched table classifies each stablecoin transfer on XRPL. A transfer is cex when the sender or recipient is a house or hard exchange address from the served entity lookup. Everything else is unidentified.

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`
`activity_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_address`	`VARCHAR`	Sender account
`to_address`	`VARCHAR`	Recipient account
`category`	`VARCHAR`	Activity category
`activity`	`VARCHAR`	Activity label
`project_address`	`VARCHAR`	Matched exchange address (nullable)
`project_name`	`VARCHAR`	Matched exchange entity key (nullable)
`project_version`	`VARCHAR`	Always `NULL`
`unique_key`	`VARCHAR`	Unique transfer identifier

Value possibilities

`category`	Allowed `activity` values	Description
`cex`	`cex_deposit`, `cex_withdraw`, `cex_internal_transfer`	Transfers to, from, or between known exchange accounts.
`unidentified`	`unidentified_activity`	Transfers not matched to an exchange account.

Sample query

SELECT
    a.block_date
    , a.activity
    , SUM(a.amount_usd) AS volume_usd
FROM stablecoins_xrpl.activity_enriched AS a
WHERE a.block_date >= CURRENT_DATE - INTERVAL '30' DAY
GROUP BY a.block_date, a.activity
ORDER BY a.block_date DESC

Notes

Updated daily.
For partition pruning, filter by block_month.