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 | 26 | USD | 2025-01-09 10:29:28.078+00 | USD | 20290 | rhub8VRN55s94qWKDv6jmDy1pUykJzF3wq | USD.rhub8VRN55s94qWKDv6jmDy1pUykJzF3wq | 20290 | 2025-12-12 10:42:14.128+00 | nan | False | 2594056.1374251563 | 0.48798379379248663 | 5315865.343118894 | False | 0.4920140062142351 | nan | nan | 0 | null | 693b9f14cb0011d2b824fe06 | nan | https://s1.xrplmeta.org/icon/11A420B50B.png | US Dollar | 3 | [] | rwa | stablecoin | 693b9f14cb0011d2b824fe07 | https://s1.xrplmeta.org/icon/D03C23EDF0.png | True | GateHub Crypto | 3 | 693b9f14cb0011d2b824fe08 | 114847 | 20291 | 5438123.46499048 | 2680699.28198213 | 0.492945645541136 | 2301.56624499999 | 188448.292245999 | 87 | 609 | 30 | 78 |