Mrftitheoretical-apricot
    Updated 19 hours ago
    with tbl AS
    (
    SELECT
    creator_address AS "Address",
    COUNT(*) as "Contract deployed",
    RANK() OVER (ORDER BY COUNT(*) DESC) as deployer_rank
    FROM monad.testnet.dim_contracts
    where inserted_timestamp >= '2025-02-19 15:00:00.000'
    GROUP BY 1
    )

    SELECT
    count (DISTINCT "Address") as "Unique contract deployer",
    sum ("Contract deployed") as "Contract deployed"
    from tbl
    Last run: about 19 hours agoAuto-refreshes every 12 hours
    Unique contract deployer
    Contract deployed
    1
    11948076713256
    1
    19B
    26s