DATE | TX_COUNT | CUM_TX_COUNT | |
|---|---|---|---|
1 | 2025-03-24 00:00:00.000 | 1806 | 1806 |
2 | 2025-03-31 00:00:00.000 | 3454 | 5260 |
3 | 2025-04-07 00:00:00.000 | 2830 | 8090 |
4 | 2025-04-14 00:00:00.000 | 2287 | 10377 |
5 | 2025-04-21 00:00:00.000 | 4357 | 14734 |
6 | 2025-04-28 00:00:00.000 | 3264 | 17998 |
7 | 2025-05-05 00:00:00.000 | 4786 | 22784 |
8 | 2025-05-12 00:00:00.000 | 7551 | 30335 |
9 | 2025-05-19 00:00:00.000 | 23197 | 53532 |
10 | 2025-05-26 00:00:00.000 | 843 | 54375 |
elsinaWeekly Number of Contracts Created Recap
Updated 9 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc('week', block_timestamp) as date,
count(distinct tx_hash) as tx_count,
sum(tx_count) over(order by date) as cum_tx_count
from mezo.testnet.fact_traces
where TYPE ilike '%create%'
and TX_SUCCEEDED = 'TRUE'
group by 1
order by 1
Last run: 9 days ago
10
388B
2s