MONTH | MONTH_NAME | N_DEPLOYMENTS | |
|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | January | 1471 |
2 | 2025-02-01 00:00:00.000 | February | 2114258 |
3 | 2025-04-01 00:00:00.000 | April | 2792972 |
4 | 2025-03-01 00:00:00.000 | March | 8127152 |
hess14. New Contracts II
Updated 2025-04-14
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select trunc(block_timestamp,'month') as month,
month_name,
count(*) as n_deployments
from monad.testnet.fact_traces a join crosschain.core.dim_dates b on a.block_timestamp::Date = b.date_day
where block_timestamp::Date >= '2025-01-08'
and TYPE IN ('CREATE', 'CREATE2')
and OUTPUT IS NOT NULL
and TX_SUCCEEDED = 'TRUE'
and TRACE_SUCCEEDED = 'TRUE'
group by 1,2
Last run: 12 days ago
4
179B
29s