MasiContracts Daily
    Updated 2025-05-12
    SELECT trunc(block_timestamp,'day') as daily,
    COUNT(*) as n_deployments,
    sum(n_deployments) over (order by daily asc) as Cumulative_Contracts
    FROM mezo.testnet.fact_traces
    WHERE 1=1
    AND TYPE IN ('CREATE', 'CREATE2')
    AND OUTPUT IS NOT NULL
    AND TX_SUCCEEDED = 'TRUE'
    AND TRACE_SUCCEEDED = 'TRUE'
    GROUP BY 1
    Last run: 20 days ago
    DAILY
    N_DEPLOYMENTS
    CUMULATIVE_CONTRACTS
    1
    2025-05-08 00:00:00.000115222041
    2
    2025-04-16 00:00:00.00033710570
    3
    2025-04-12 00:00:00.0002148387
    4
    2025-04-25 00:00:00.00088415481
    5
    2025-04-26 00:00:00.00020815689
    6
    2025-03-31 00:00:00.0007702587
    7
    2025-05-09 00:00:00.000121123252
    8
    2025-03-29 00:00:00.000364364
    9
    2025-05-04 00:00:00.00062720105
    10
    2025-04-08 00:00:00.0003956596
    11
    2025-05-06 00:00:00.00027620538
    12
    2025-04-02 00:00:00.00010474607
    13
    2025-04-20 00:00:00.00030211759
    14
    2025-03-30 00:00:00.00014531817
    15
    2025-04-22 00:00:00.00052713060
    16
    2025-04-09 00:00:00.0003756971
    17
    2025-05-10 00:00:00.00034523597
    18
    2025-04-13 00:00:00.0005828969
    19
    2025-04-07 00:00:00.0005336201
    20
    2025-05-02 00:00:00.00022118982
    45
    2KB
    2s