1SELECT
2 'USD (GateHub)' as stablecoin_name,
3 *
4FROM @xrpscan.xrp_ledger.tokens
5WHERE issuer = 'rhub8VRN55s94qWKDv6jmDy1pUykJzF3wq'
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 (GateHub) | USD.rhub8VRN55s94qWKDv6jmDy1pUykJzF3wq | 23 | USD | 2025-01-09 10:29:28.078+00 | USD | 20286 | rhub8VRN55s94qWKDv6jmDy1pUykJzF3wq | USD.rhub8VRN55s94qWKDv6jmDy1pUykJzF3wq | 20286 | 2025-11-01 10:41:23.947+00 | nan | False | 2109571.7437371407 | 0.39664809101092424 | 5318497.155401764 | False | 0.49118306633847053 | nan | nan | 0 | null | 6905912867c7afe3bcd66bee | nan | https://s1.xrplmeta.org/icon/11A420B50B.png | US Dollar | 3 | [] | rwa | stablecoin | 6905912867c7afe3bcd66bef | https://s1.xrplmeta.org/icon/D03C23EDF0.png | True | GateHub Crypto | 3 | 6905912867c7afe3bcd66bf0 | 114796 | 20287 | 5440755.33048042 | 1807463.25199154 | 0.397221797293353 | 9950.70578899996 | 46453.0394769976 | 111 | 883 | 31 | 88 |