flipside

    trending contracts
    Monad Metrics Guildtrending contracts
    Updated 3 hours ago
    -- by @chainrunner_

    with labelled_contracts as (
    select * from $query('ae1af2d4-a9d1-4cad-a095-6c6a6c33fae4')
    )

    , smart_filter as (
    select
    c.contract_address
    , count(*) as txns
    from (
    select
    to_address as contract_address
    from monad.testnet.fact_transactions
    where 1=1
    and block_timestamp >= sysdate() - interval '1 day'
    and tx_succeeded
    ) right join (
    select
    address as contract_address
    from monad.testnet.dim_contracts
    ) c using(contract_address)
    group by 1
    qualify row_number() over (order by txns desc) <= 1000
    )

    select
    contract_address
    , coalesce(
    case
    when creator_address = '0xc816865f172d640d93712c68a7e1f83f3fa63235' then 'Kuru'
    when creator_address = '0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e' then 'Nad.fun'
    when creator_address = '0x321fb42877b7c61efe489505ab87bf1dff33f1e4' then 'Nad.fun'
    when creator_address = '0x60216fb3285595f4643f9f7cddab842e799bd642' then 'Nad.fun'
    end
    , l_c.name
    Last run: about 3 hours agoAuto-refreshes every 12 hours
    CONTRACT_ADDRESS
    CONTRACT_NAME
    CONTRACT
    CATEGORY
    1
    		0x8462c247356d7deb7e26160dbfab16b351eef242CurvanceCurvanceDeFi
    2
    		0x760afe86e5de5fa0ee542fc7b7b713e1c5425701Wrapped MONWrapped MONToken
    3
    		0xb2f82d0f38dc453d596ad40a37799446cc89274aaPrioriaPrioriDeFi
    4
    		0xd227d3bce59b91380b7bc4a61a045b528b509439AI CraftAI CraftAI
    5
    		0x2c9c959516e9aaedb2c748224a41249202ca8be7Magma StakingMagma StakingDeFi
    6
    		0x88b96af200c8a9c35442c8ac6cd3d22695aae4f0Ambient FinanceAmbient FinanceDeFi
    7
    		0xca810d095e90daae6e867c19df6d9a8c56db2c89Bean ExchangeBean ExchangeDeFi
    8
    		0x3a98250f98dd388c211206983453837c8365bdc1shMONshMONToken
    9
    		0x18c9534dfe16a0314b66395f48549716fff9aa66DustedDustedSocialFi
    10
    		0x4c4eabd5fb1d1a7234a48692551eaecff8194ca7UniswapUniswapDeFi
    11
    		0x4267f317adee7c6478a5ee92985c2bd5d855e274NA0x4267f317adee7c6478a5ee92985c2bd5d855e274NA
    12
    		0xc816865f172d640d93712c68a7e1f83f3fa63235KuruKuruDeFi
    13
    		0x6593f49ca8d3038ca002314c187b63dd348c2f94Narwhal FinanceNarwhal FinanceDeFi
    14
    		0x17642ce98f4abfabcbb5e1a5d5825902cc311cebNarwhal FinanceNarwhal FinanceDeFi
    15
    		0x64aff7245ebdaaecaf266852139c67e4d8dba4deNA0x64aff7245ebdaaecaf266852139c67e4d8dba4deNA
    16
    		0xf6ffe4f3fdc8bbb7f70ffd48e61f17d1e343ddfdIzumi FinanceIzumi FinanceDeFi
    17
    		0xf817257fed379853cde0fa4f97ab987181b1e5eaUSDCUSDCToken
    18
    		0xbce2c725304e09cef4cd7639760b67f8a0af5bc4FastlaneFastlaneDeFi
    19
    		0x07aabd925866e8353407e67c1d157836f7ad923esMONsMONToken
    20
    		0xb6091233aacacba45225a2b2121bbac807af4255NA0xb6091233aacacba45225a2b2121bbac807af4255NA
    ...
    1006
    94KB
    87s