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 | 30 | USD | 2025-01-09 10:29:28.078+00 | USD | 20294 | rhub8VRN55s94qWKDv6jmDy1pUykJzF3wq | USD.rhub8VRN55s94qWKDv6jmDy1pUykJzF3wq | 20294 | 2026-01-31 10:40:49.666+00 | nan | False | 3095768.960598255 | 0.5826726457241046 | 5313050.103375028 | False | 0.4926619998544295 | nan | nan | 0 | null | 697d8800d65f57b9bf93d954 | nan | https://s1.xrplmeta.org/icon/11A420B50B.png | US Dollar | 3 | [] | rwa | stablecoin | 697d8800d65f57b9bf93d955 | https://s1.xrplmeta.org/icon/D03C23EDF0.png | True | GateHub Crypto | 3 | 697d8800d65f57b9bf93d956 | 114872 | 20292 | 5435310.95031736 | 3122308.27630332 | 0.574448877873493 | 11992.9585589999 | 27175.9803719999 | 88 | 669 | 30 | 71 |