mamad-5XN3k3Top Monad Contracts 2
    Updated 3 days ago
    -- forked from Top Monad Contracts 1 @ https://flipsidecrypto.xyz/studio/queries/f42bdc7a-10d5-40c8-90b3-332eec8beae7

    with contractt as (
    select
    address,
    symbol,
    name
    from monad.testnet.dim_contracts
    )


    select *
    from(
    select
    distinct contract_address,
    case
    when contract_address = '0x4c4eabd5fb1d1a7234a48692551eaecff8194ca7' then 'Pump4gains'
    when contract_address = '0x8462c247356d7deb7e26160dbfab16b351eef242' then 'Wrapping and Unwrapping Monad'
    when contract_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701' then 'Wrapped Monad (WMON)'
    when contract_address = '0x88b96af200c8a9c35442c8ac6cd3d22695aae4f0' then 'Uniswap'
    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!'
    Last run: 3 days ago
    CONTRACT_ADDRESS
    LABEL
    TXS
    PAID_FEE
    USERS
    TX_RANK
    USER_RANK
    FEE_RANK
    1
    0x8462c247356d7deb7e26160dbfab16b351eef242Wrapping and Unwrapping Monad65269160114813.7388612512065201612
    2
    0x760afe86e5de5fa0ee542fc7b7b713e1c5425701Wrapped Monad (WMON)13781391113285.310460495975679283
    3
    0x4c4eabd5fb1d1a7234a48692551eaecff8194ca7Pump4gains10134583195377.5642524031812606311
    4
    0xca810d095e90daae6e867c19df6d9a8c56db2c89Bean DEX716002271976.6459002391012760464
    5
    0x88b96af200c8a9c35442c8ac6cd3d22695aae4f0Uniswap623916556476.1552686281104677557
    6
    0xd227d3bce59b91380b7bc4a61a045b528b509439-556505333264.55569194647247862314
    7
    0xb2f82d0f38dc453d596ad40a37799446cc89274aaPriori Monad LST542874343906.96484753914311267212
    8
    0x2c9c959516e9aaedb2c748224a41249202ca8be7-538448851623.0864791031011334879
    9
    0x3a98250f98dd388c211206983453837c8365bdc1ShMonad423489918409.19698062771525191428
    10
    0xc816865f172d640d93712c68a7e1f83f3fa63235Kuru403663751731.28410818746361410258
    11
    0x758d80767a751fc1634f579d76e1ccaab3485c9cNad Name Service279547265776.66826676312390731145
    12
    0x07aabd925866e8353407e67c1d157836f7ad923eStakedMonad(sMON)259585119268.749611151759528121126
    13
    0xf6ffe4f3fdc8bbb7f70ffd48e61f17d1e343ddfdIZUMI Swap254163734577.380064408454807132713
    14
    0xb33d7138c53e516871977094b249c8f2ab89a4f4OPEN EDITION CHOGSTAR239156813989.244328059127113914333
    15
    0x9eaba701a49ade7525dffe338f0c7e06eca7cf07233120912485.18392293342471549636
    16
    0xbb444821e159dd6401bb92fb18c2ac0a37113025FANTASY USD21920506898.671061764665786161759
    17
    0xf817257fed379853cde0fa4f97ab987181b1e5eaUSDC20573126331.226811831744985171262
    18
    0xbce2c725304e09cef4cd7639760b67f8a0af5bc4199417814798.365699299133591187631
    19
    0xc995498c22a012353fae7ecc701810d673e25794-183871050049.495736642312160194110
    20
    0x18c9534dfe16a0314b66395f48549716fff9aa66-168852313656.20111097674545201635
    ...
    4485
    385KB
    124s