mamad-5XN3k3Top Monad Contracts 1
    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 'USDC'
    Last run: 17 days ago
    CONTRACT_ADDRESS
    LABEL
    DAYS
    TXS
    PAID_FEE
    USERS
    TX_RANK
    USER_RANK
    FEE_RANK
    1
    0xb2f82d0f38dc453d596ad40a37799446cc89274aaPriori Monad LST2025-02-23 00:00:00.0001356711145.63120377579535819
    2
    0xb2f82d0f38dc453d596ad40a37799446cc89274aaPriori Monad LST2025-02-26 00:00:00.0003658842737.1444239492091635410
    3
    0x8462c247356d7deb7e26160dbfab16b351eef242Pump4gains2025-02-22 00:00:00.00019340373366.74472888129181301
    4
    0x8462c247356d7deb7e26160dbfab16b351eef242Pump4gains2025-02-21 00:00:00.00010117011769.435339984111421296
    5
    0x8462c247356d7deb7e26160dbfab16b351eef242Pump4gains2025-02-19 00:00:00.000137971241.593467232127212511
    6
    0x8462c247356d7deb7e26160dbfab16b351eef242Pump4gains2025-02-20 00:00:00.0006007361051.07930068652401388
    7
    0xb33d7138c53e516871977094b249c8f2ab89a4f4OPEN EDITION CHOGSTAR2025-02-20 00:00:00.000196919998.44655145280519219
    8
    0xb33d7138c53e516871977094b249c8f2ab89a4f4OPEN EDITION CHOGSTAR2025-02-21 00:00:00.000141993721.027627906652004511
    9
    0xbb444821e159dd6401bb92fb18c2ac0a37113025FANTASY USD2025-02-22 00:00:00.000155397516.8840818633530731029
    10
    0xbb444821e159dd6401bb92fb18c2ac0a37113025FANTASY USD2025-02-21 00:00:00.000263921800.55915792591229219
    11
    0x836047a99e11f376522b447bffb6e3495dd0637cETH2025-02-22 00:00:00.0001052851759.82687981651187545
    12
    0x760afe86e5de5fa0ee542fc7b7b713e1c5425701Wrapped Monad2025-02-24 00:00:00.0005365173095.845848331505592115
    13
    0x760afe86e5de5fa0ee542fc7b7b713e1c5425701Wrapped Monad2025-02-25 00:00:00.0008329266381.250105033992632103
    14
    0x8462c247356d7deb7e26160dbfab16b351eef242Pump4gains2025-02-25 00:00:00.00036061886279.47800664213841404
    15
    0x8462c247356d7deb7e26160dbfab16b351eef242Pump4gains2025-02-24 00:00:00.00041062197139.574259168186051272
    16
    0x8462c247356d7deb7e26160dbfab16b351eef242Pump4gains2025-02-26 00:00:00.00023255584058.967192972252851314
    17
    0xbb444821e159dd6401bb92fb18c2ac0a37113025FANTASY USD2025-02-20 00:00:00.000129481465.495007614226514921
    18
    0xb33d7138c53e516871977094b249c8f2ab89a4f4OPEN EDITION CHOGSTAR2025-02-19 00:00:00.000137359741.17392765360223212
    19
    0x9077d31a794d81c21b0650974d5f581f4000cd1aFantasy Minting2025-02-21 00:00:00.000953512637.25661045390491524
    20
    0xb33d7138c53e516871977094b249c8f2ab89a4f4OPEN EDITION CHOGSTAR2025-02-24 00:00:00.000173380873.14070065908695425
    30
    4KB
    18s