DATE | CONTRACT_DEPLOYED | TOTAL_CONTRACT_DEPLOYED | |
|---|---|---|---|
1 | 2025-03-15 00:00:00.000 | 111480 | 5201754 |
2 | 2025-03-14 00:00:00.000 | 246364 | 5090274 |
3 | 2025-03-13 00:00:00.000 | 320120 | 4843910 |
4 | 2025-03-12 00:00:00.000 | 284386 | 4523790 |
5 | 2025-03-11 00:00:00.000 | 296692 | 4239404 |
6 | 2025-03-10 00:00:00.000 | 185831 | 3942712 |
7 | 2025-03-09 00:00:00.000 | 172814 | 3756881 |
8 | 2025-03-08 00:00:00.000 | 157630 | 3584067 |
9 | 2025-03-07 00:00:00.000 | 227375 | 3426437 |
10 | 2025-03-06 00:00:00.000 | 188937 | 3199062 |
11 | 2025-03-05 00:00:00.000 | 187067 | 3010125 |
12 | 2025-03-04 00:00:00.000 | 220024 | 2823058 |
13 | 2025-03-03 00:00:00.000 | 193999 | 2603034 |
14 | 2025-03-02 00:00:00.000 | 215891 | 2409035 |
15 | 2025-03-01 00:00:00.000 | 263403 | 2193144 |
16 | 2025-02-28 00:00:00.000 | 331620 | 1929741 |
17 | 2025-02-27 00:00:00.000 | 363303 | 1598121 |
18 | 2025-02-26 00:00:00.000 | 484602 | 1234818 |
19 | 2025-02-25 00:00:00.000 | 253311 | 750216 |
20 | 2025-02-24 00:00:00.000 | 127188 | 496905 |
BlockTrackercontract deployed
Updated 5 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
date_trunc('{{granularity}}', block_timestamp) as date,
count(DISTINCT tx_hash) as contract_deployed,
sum(contract_deployed) over (order by date) aS TOTAL_contract_deployed
from monad.testnet.fact_traces
where type ilike '%CREATE%'
and TX_SUCCEEDED
and input <> '0x'
and to_address is not null
and ORIGIN_FUNCTION_SIGNATURE <> '0x'
and block_timestamp::date >= '2025-01-07'
group by 1
order by date desc
Last run: 5 days ago
68
3KB
46s