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

> Transfer-level stablecoin activity classification on XRPL

export const PremiumDatasetAccessCard = ({href = "https://dune.com/enterprise#contact-form", note = null}) => <Card title="Gated dataset" icon="lock" href={href}>
    Querying this dataset requires an entitlement on your workspace. See <a href="/data-catalog/overview#access-tiers-public-vs-gated-datasets">access tiers</a>, or contact the Dune team to enable access.
    {note && <><br /><br />{note}</>}
  </Card>;

The `stablecoins_xrpl.activity_enriched` table classifies each stablecoin transfer on XRPL.

<PremiumDatasetAccessCard />

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

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


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