flipside

    New Smart Contracts Deployed per Day
    kentoNew Smart Contracts Deployed per Day
    Updated 2025-04-06
    SELECT
    DATE(created_block_timestamp) AS day,
    COUNT(*) AS new_contracts
    FROM mezo.testnet.dim_contracts
    WHERE created_block_timestamp BETWEEN '2025-01-01' AND '2025-12-31'
    GROUP BY day
    ORDER BY day;

    Last run: about 2 months ago
    DAY
    NEW_CONTRACTS
    1
    		2025-03-29 00:00:00.000364
    2
    		2025-03-30 00:00:00.0001458
    3
    		2025-03-31 00:00:00.000770
    4
    		2025-04-01 00:00:00.000973
    5
    		2025-04-02 00:00:00.0001047
    6
    		2025-04-03 00:00:00.000409
    7
    		2025-04-04 00:00:00.000256
    8
    		2025-04-05 00:00:00.000144
    9
    		2025-04-06 00:00:00.000106
    9
    291B
    1s