cryptodatadiveDaily Contract Deployments
    Updated 2025-04-10
    WITH contracts AS (
    SELECT
    CREATED_BLOCK_TIMESTAMP,
    ADDRESS AS CONTRACT_ADDRESS,
    CREATOR_ADDRESS
    FROM mezo.testnet.dim_contracts
    )

    SELECT
    DATE_TRUNC('day', CREATED_BLOCK_TIMESTAMP) AS DAY,
    COUNT(*) AS CONTRACT_COUNT
    FROM contracts
    GROUP BY 1
    ORDER BY 1;

    Last run: 3 months ago
    DAY
    CONTRACT_COUNT
    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.000252
    10
    2025-04-07 00:00:00.000533
    11
    2025-04-08 00:00:00.000395
    12
    2025-04-09 00:00:00.000375
    13
    2025-04-10 00:00:00.000162
    13
    419B
    1s