DATE | Number of Contracts Created | CUM Contracts Created | |
|---|---|---|---|
1 | 2025-03-29 00:00:00.000 | 362 | 362 |
2 | 2025-03-30 00:00:00.000 | 1444 | 1806 |
3 | 2025-03-31 00:00:00.000 | 769 | 2575 |
4 | 2025-04-01 00:00:00.000 | 929 | 3504 |
5 | 2025-04-02 00:00:00.000 | 1006 | 4510 |
6 | 2025-04-03 00:00:00.000 | 354 | 4864 |
7 | 2025-04-04 00:00:00.000 | 143 | 5007 |
8 | 2025-04-05 00:00:00.000 | 72 | 5079 |
9 | 2025-04-06 00:00:00.000 | 181 | 5260 |
10 | 2025-04-07 00:00:00.000 | 469 | 5729 |
11 | 2025-04-08 00:00:00.000 | 300 | 6029 |
12 | 2025-04-09 00:00:00.000 | 270 | 6299 |
13 | 2025-04-10 00:00:00.000 | 553 | 6852 |
14 | 2025-04-11 00:00:00.000 | 518 | 7370 |
15 | 2025-04-12 00:00:00.000 | 174 | 7544 |
16 | 2025-04-13 00:00:00.000 | 546 | 8090 |
17 | 2025-04-14 00:00:00.000 | 768 | 8858 |
18 | 2025-04-15 00:00:00.000 | 330 | 9188 |
19 | 2025-04-16 00:00:00.000 | 181 | 9369 |
20 | 2025-04-17 00:00:00.000 | 346 | 9715 |
Salehcontracts -date
Updated 2025-04-30
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
block_timestamp::date as date
,count(distinct tx_hash) as "Number of Contracts Created"
,sum("Number of Contracts Created") over(order by date) as "CUM Contracts Created"
from mezo.testnet.fact_traces
where TYPE ilike '%create%'
and TX_SUCCEEDED
group by 1
order by 1
Last run: 24 days ago
33
1KB
3s