CONTRACTS_RANGE | USERS | |
|---|---|---|
1 | >20 contracts_deployed | 122 |
2 | 1 contract_deployed | 27036 |
3 | 1-5 contracts deployed | 10329 |
4 | 5-10 contracts deployed | 680 |
5 | 10-20 contracts deployed | 366 |
pepperatziCreators Range of Contracts
Updated 2025-02-20
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
›
⌄
with base as (
select
created_block_timestamp,
address,
creator_address,
from monad.testnet.dim_contracts
where date_trunc('hour', created_block_timestamp) >= '2025-02-19 16:00:00'
),
environment as (
select
creator_address,
count(distinct address) as total_contract_deployed
from base
group by 1
)
select
case when total_contract_deployed = 1 then '1 contract_deployed'
when total_contract_deployed between 1 and 5 then '1-5 contracts deployed'
when total_contract_deployed between 5 and 10 then '5-10 contracts deployed'
when total_contract_deployed between 10 and 20 then '10-20 contracts deployed'
when total_contract_deployed > 20 then '>20 contracts_deployed'
end as contracts_Range,
count(distinct creator_address) as users
from environment
group by 1
Last run: 28 days ago
5
160B
1s