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 | 59 | USDC | 2025-04-17 21:38:34.392+00 | 5553444300000000000000000000000000000000 | 1539 | rGm7WCVp9gb4jZHWTEtGUr4dd74z2XuWhE | USDC.rGm7WCVp9gb4jZHWTEtGUr4dd74z2XuWhE | 1539 | 2025-12-13 10:41:45.432+00 | nan | False | 2716838.6021664515 | 0.4901240013723472 | 5543165.800000211 | False | 0.24455478861987004 | nan | nan | 0 | null | 693cf0a52689b2bd1634e940 | USDC is a fully collateralized US Dollar stablecoin. | https://s1.xrplmeta.org/icon/24C40DF01C.svg | Circle USDC | 3 | [] | nan | nan | 693cf0a52689b2bd1634e941 | https://s1.xrplmeta.org/icon/CB64AA860F.png | True | Circle | 3 | 693cf0a52689b2bd1634e942 | 8155 | 1540 | 5543168.6834039 | 2729777.79477497 | 0.492458005643568 | 42155.6318089998 | 323103.648293984 | 337 | 4562 | 64 | 178 |