flipside

    Top Monad Contracts 1 copy
    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'
    Last run: 17 days ago
    CONTRACT_ADDRESS
    LABEL
    DAYS
    TXS
    PAID_FEE
    USERS
    TX_RANK
    USER_RANK
    FEE_RANK
    1
    		0x8462c247356d7deb7e26160dbfab16b351eef242Pump4gains2025-02-22 00:00:00.00019340373366.74472888129181301
    2
    		0x8462c247356d7deb7e26160dbfab16b351eef242Pump4gains2025-02-23 00:00:00.00049237348555.76021248183051261
    3
    		0x8462c247356d7deb7e26160dbfab16b351eef242Pump4gains2025-02-19 00:00:00.000137971241.593467232127212511
    4
    		0x8462c247356d7deb7e26160dbfab16b351eef242Pump4gains2025-02-20 00:00:00.0006007361051.07930068652401388
    5
    		0x8462c247356d7deb7e26160dbfab16b351eef242Pump4gains2025-02-25 00:00:00.00036061886279.47800664213841404
    6
    		0xb33d7138c53e516871977094b249c8f2ab89a4f4OPEN EDITION CHOGSTAR2025-02-20 00:00:00.000196919998.44655145280519219
    7
    		0xb33d7138c53e516871977094b249c8f2ab89a4f4OPEN EDITION CHOGSTAR2025-02-24 00:00:00.000173380873.14070065908695425
    8
    		0xb33d7138c53e516871977094b249c8f2ab89a4f4OPEN EDITION CHOGSTAR2025-02-21 00:00:00.000141993721.027627906652004511
    9
    		0xb2f82d0f38dc453d596ad40a37799446cc89274aaPriori Monad LST2025-02-26 00:00:00.0004276733126.337145904245313539
    10
    		0x8462c247356d7deb7e26160dbfab16b351eef242Pump4gains2025-02-21 00:00:00.00010117011769.435339984111421296
    11
    		0x9077d31a794d81c21b0650974d5f581f4000cd1aFantasy Minting2025-02-21 00:00:00.000953512637.25661045390491524
    12
    		0x88b96af200c8a9c35442c8ac6cd3d22695aae4f0Ambient Finance2025-02-23 00:00:00.0002433983021.14962404182385424
    13
    		0xb2f82d0f38dc453d596ad40a37799446cc89274aaPriori Monad LST2025-02-23 00:00:00.0001356711145.63120377579535819
    14
    		0xb33d7138c53e516871977094b249c8f2ab89a4f4OPEN EDITION CHOGSTAR2025-02-19 00:00:00.000137359741.17392765360223212
    15
    		0xca810d095e90daae6e867c19df6d9a8c56db2c89Bean DEX2025-02-25 00:00:00.0004842464664.270954563125737485
    16
    		0xca810d095e90daae6e867c19df6d9a8c56db2c89Bean DEX2025-02-26 00:00:00.0004916984638.821152395132195493
    17
    		0x88b96af200c8a9c35442c8ac6cd3d22695aae4f0Ambient Finance2025-02-25 00:00:00.0004314683728.483458848159950567
    18
    		0x8462c247356d7deb7e26160dbfab16b351eef242Pump4gains2025-02-26 00:00:00.00025073134376.393493404277351304
    19
    		0x88b96af200c8a9c35442c8ac6cd3d22695aae4f0Ambient Finance2025-02-22 00:00:00.0001417412008.48390211845556464
    20
    		0x88b96af200c8a9c35442c8ac6cd3d22695aae4f0Ambient Finance2025-02-24 00:00:00.0002462202705.83148935780795456
    22
    3KB
    16s