Query Result
1SELECT
2 'USD (Bitstamp)' as stablecoin_name,
3 *
4FROM @xrpscan.xrp_ledger.tokens
5WHERE issuer = 'rvYAfWj5gh67oV6fW32ZzP3Aw4Eubs59B'
6 AND code = 'USD';| stablecoin_name | id | amms | code | createdat | currency | holders | issuer | token | trustlines | updatedat | emailhash | blackholed | marketcap | price | supply | disabled | score | tomldata | ammid | meta_issuer_weblinks_count | meta_issuer_primary_website | meta_token_id | meta_token_desc | meta_token_icon | meta_token_name | meta_token_trust_level | meta_token_weblinks | meta_token_asset_class | meta_token_asset_subclass | meta_issuer_id | meta_issuer_icon | meta_issuer_kyc | meta_issuer_name | meta_issuer_trust_level | metrics_id | metrics_trustlines | metrics_holders | metrics_supply | metrics_marketcap | metrics_price | metrics_volume_24h | metrics_volume_7d | metrics_exchanges_24h | metrics_exchanges_7d | metrics_takers_24h | metrics_takers_7d |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| USD (Bitstamp) | USD.rvYAfWj5gh67oV6fW32ZzP3Aw4Eubs59B | 20 | USD | 2025-01-09 10:29:28.079+00 | USD | 7345 | rvYAfWj5gh67oV6fW32ZzP3Aw4Eubs59B | USD.rvYAfWj5gh67oV6fW32ZzP3Aw4Eubs59B | 7345 | 2026-05-17 09:41:13.026+00 | 5B33B93C7FFE384D53450FC666BB11FB | False | 6552009.8465764625 | 0.6932183145505831 | 9451582.148149336 | False | 0.46992379455998945 | null | null | 0 | null | 6a093b4666b5784e8c4bedff | Bitstamp's USD is a fully backed U.S. Dollar IOU on the XRPL. It can be redeemed into real Dollars on bitstamp.net. For support, visit their website or X @BitstampSupport | https://s1.xrplmeta.org/icon/C676A0DE05.png | US Dollar | 3 | [] | rwa | stablecoin | 6a093b4666b5784e8c4bee00 | https://s1.xrplmeta.org/icon/DDDEC1BEED.png | true | Bitstamp | 3 | 6a093b4666b5784e8c4bee01 | 25770 | 7347 | 9451582.89059706 | 6619080.767792 | 0.700314523441043 | 623.526878999999 | 15084.3306179996 | 97 | 940 | 12 | 41 |