flipside

    naughty-chocolate
    monadmetrics-JFe1_Rnaughty-chocolate
    Updated 2025-02-27
    SELECT
    to_address AS contract_address,
    COUNT(tx_hash) AS transaction_count
    FROM MONAD.testnet.fact_transactions
    WHERE to_address IN (SELECT address FROM MONAD.testnet.dim_contracts)
    AND block_timestamp >= '2025-02-19 15:00:00.000'
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 10;

    Last run: 22 days ago
    CONTRACT_ADDRESS
    TRANSACTION_COUNT
    1
    		0x8462c247356d7deb7e26160dbfab16b351eef24220663987
    2
    		0x4c4eabd5fb1d1a7234a48692551eaecff8194ca74245477
    3
    		0x760afe86e5de5fa0ee542fc7b7b713e1c54257013838607
    4
    		0xca810d095e90daae6e867c19df6d9a8c56db2c891843468
    5
    		0x88b96af200c8a9c35442c8ac6cd3d22695aae4f01791680
    6
    		0xb2f82d0f38dc453d596ad40a37799446cc89274a1568483
    7
    		0xb33d7138c53e516871977094b249c8f2ab89a4f41459102
    8
    		0xbb444821e159dd6401bb92fb18c2ac0a371130251205335
    9
    		0x2c9c959516e9aaedb2c748224a41249202ca8be71026186
    10
    		0x2a0d96bc211ec8cdc61c92ba6204bf2df228caba977688
    10
    551B
    4s