mamad-5XN3k3Top Monad Contracts 1 copy
    Updated 2025-02-26
    with contractt as (
    select
    address,
    symbol,
    name
    from monad.testnet.dim_contracts
    )


    select *
    from(
    select
    distinct contract_address,
    case
    when contract_address = '0x8462c247356d7deb7e26160dbfab16b351eef242' then 'Pump4gains'
    when contract_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701' then 'Wrapped Monad'
    when contract_address = '0x88b96af200c8a9c35442c8ac6cd3d22695aae4f0' then 'Ambient Finance'
    when contract_address = '0xca810d095e90daae6e867c19df6d9a8c56db2c89' then 'Bean DEX'
    when contract_address = '0xb33d7138c53e516871977094b249c8f2ab89a4f4' then 'OPEN EDITION CHOGSTAR'
    when contract_address = '0xbb444821e159dd6401bb92fb18c2ac0a37113025' then 'FANTASY USD'
    when contract_address = '0xb2f82d0f38dc453d596ad40a37799446cc89274a' then 'aPriori Monad LST'
    when contract_address = '0x2a0d96bc211ec8cdc61c92ba6204bf2df228caba' then 'EMMY ON MONAD'
    when contract_address = '0x758d80767a751fc1634f579d76e1ccaab3485c9c' then 'Nad Name Service'
    when contract_address = '0x836047a99e11f376522b447bffb6e3495dd0637c' then 'ETH'
    when contract_address = '0x436ee7219bb099f71c9db9c7de8862a9bde891ae' then 'Monad x Alchemy'
    when contract_address = '0xc816865f172d640d93712c68a7e1f83f3fa63235' then 'Kuru'
    when contract_address = '0xf6ffe4f3fdc8bbb7f70ffd48e61f17d1e343ddfd' then 'IZUMI Swap'
    when contract_address = '0x66b655de495268eb4c7b70bf4ac1ab4094589f93' then 'Overnads Open Edition'
    when contract_address = '0x2555223a15a931a71951707cb32a541f14e2c730' then 'Vote Escrowed CVE'
    when contract_address = '0xe25c57ff3eea05d0f8be9aaae3f522ddc803ca4e' then 'Chapter 1: Genesis'
    when contract_address = '0x9077d31a794d81c21b0650974d5f581f4000cd1a' then 'Fantasy Minting'
    when contract_address = '0xd97bce4518b886a36e345764333d77b5faf6fe2c' then 'Poply NFT Market'
    when contract_address = '0x7af6ddb984bac7df0dbefa0aa37a7b3dfb5c4020' then 'Blocklive on Monad Testnet!'
    when contract_address = '0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7' then 'Layer3 Cube'
    when contract_address = '0x45a62b090df48243f12a21897e7ed91863e2c86b' then 'LFJ'
    when contract_address = '0x924f1bf31b19a7f9695f3fc6c69c2ba668ea4a0a' then 'USD Coin'