Query Result
1SELECT
2 'USDC (Circle)' as stablecoin_name,
3 *
4FROM @xrpscan.xrp_ledger.tokens
5WHERE issuer = 'rGm7WCVp9gb4jZHWTEtGUr4dd74z2XuWhE'
6 AND code = 'USDC';| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| USDC (Circle) | 5553444300000000000000000000000000000000.rGm7WCVp9gb4jZHWTEtGUr4dd74z2XuWhE | 67 | USDC | 2025-04-17 21:38:34.392+00 | 5553444300000000000000000000000000000000 | 9581 | rGm7WCVp9gb4jZHWTEtGUr4dd74z2XuWhE | USDC.rGm7WCVp9gb4jZHWTEtGUr4dd74z2XuWhE | 9581 | 2026-03-21 10:40:50.835+00 | nan | False | 5454102.559033117 | 0.694444444887419 | 7853907.679997812 | False | 0.4755840730637527 | nan | nan | 0 | null | 69be21bc24bfd5eba0a7f4ca | USDC is a fully collateralized US Dollar stablecoin. | https://s1.xrplmeta.org/icon/9BA084B339.svg | Circle USDC | 3 | [] | nan | nan | 69be21bc24bfd5eba0a7f4cb | https://s1.xrplmeta.org/icon/ED36F4BE81.png | True | Circle | 3 | 69be21bc24bfd5eba0a7f4cc | 10248 | 9590 | 7853910.56340367 | 5433164.23742082 | 0.691778215903981 | 32243.0780289992 | 689709.699542831 | 704 | 8559 | 91 | 477 |