Query Result
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 | 20303 | rhub8VRN55s94qWKDv6jmDy1pUykJzF3wq | USD.rhub8VRN55s94qWKDv6jmDy1pUykJzF3wq | 20303 | 2026-03-19 10:40:50.532+00 | nan | False | 3243400.052474329 | 0.6697430196033782 | 4842753.052349945 | False | 0.49323226020383215 | nan | nan | 0 | null | 69bb80c8b183af1ecccc2c39 | nan | https://s1.xrplmeta.org/icon/11A420B50B.png | US Dollar | 3 | [] | rwa | stablecoin | 69bb80c8b183af1ecccc2c3a | https://s1.xrplmeta.org/icon/B59A3121D7.png | True | GateHub Crypto | 3 | 69bb80c8b183af1ecccc2c3b | 115012 | 20308 | 4965012.82371706 | 3386407.98298085 | 0.682054226890317 | 2225.98174599999 | 47798.9796289974 | 146 | 969 | 29 | 67 |