DATE | Active Contract | New Contract | |
|---|---|---|---|
1 | 2025-04-22 00:00:00.000 | 75 | 527 |
2 | 2025-05-01 00:00:00.000 | 114 | 435 |
3 | 2025-04-07 00:00:00.000 | 113 | 533 |
4 | 2025-03-29 00:00:00.000 | 6 | 364 |
5 | 2025-04-24 00:00:00.000 | 73 | 803 |
6 | 2025-04-17 00:00:00.000 | 72 | 380 |
7 | 2025-04-11 00:00:00.000 | 90 | 575 |
8 | 2025-03-30 00:00:00.000 | 9 | 1453 |
9 | 2025-04-21 00:00:00.000 | 60 | 774 |
10 | 2025-04-08 00:00:00.000 | 154 | 395 |
11 | 2025-04-27 00:00:00.000 | 98 | 820 |
12 | 2025-04-26 00:00:00.000 | 110 | 208 |
13 | 2025-04-23 00:00:00.000 | 77 | 734 |
14 | 2025-04-29 00:00:00.000 | 64 | 295 |
15 | 2025-04-03 00:00:00.000 | 119 | 409 |
16 | 2025-04-18 00:00:00.000 | 81 | 144 |
17 | 2025-03-28 00:00:00.000 | 1 | |
18 | 2025-04-06 00:00:00.000 | 120 | 252 |
19 | 2025-04-12 00:00:00.000 | 72 | 214 |
20 | 2025-03-31 00:00:00.000 | 3 | 770 |
hess16. Daily Number of Contracts
Updated 2025-05-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
with new_contract as (select block_timestamp::Date as date,
count(*) as new
from mezo.testnet.fact_traces
where block_timestamp::Date >= '2025-03-01'
and TYPE IN ('CREATE', 'CREATE2')
and OUTPUT IS NOT NULL
and TX_SUCCEEDED = 'TRUE'
and TRACE_SUCCEEDED = 'TRUE'
group by 1)
,
hourly_active as ( select block_timestamp::Date as date,
count(distinct to_address) as total_contract
from mezo.testnet.fact_transactions
where block_timestamp::date >= '2025-03-01'
and to_address in (select distinct to_address from mezo.testnet.fact_traces
where block_timestamp::Date >= '2025-03-01'
and TYPE IN ('CREATE', 'CREATE2')
and OUTPUT IS NOT NULL
and TX_SUCCEEDED = 'TRUE'
and TRACE_SUCCEEDED = 'TRUE')
group by 1)
select a.date,
total_contract as "Active Contract",
new as "New Contract"
from hourly_active a full outer join new_contract b on a.date = b.date
Last run: 21 days ago
35
1KB
4s