DATE | CONTRACT_DEPLOYED | TOTAL_CONTRACT_DEPLOYED | |
|---|---|---|---|
1 | 2025-06-09 00:00:00.000 | 53984 | 22310364 |
2 | 2025-06-08 00:00:00.000 | 140233 | 22256380 |
3 | 2025-06-07 00:00:00.000 | 140526 | 22116147 |
4 | 2025-06-06 00:00:00.000 | 146242 | 21975621 |
5 | 2025-06-05 00:00:00.000 | 156258 | 21829379 |
6 | 2025-06-04 00:00:00.000 | 143318 | 21673121 |
7 | 2025-06-03 00:00:00.000 | 138658 | 21529803 |
8 | 2025-06-02 00:00:00.000 | 118189 | 21391145 |
9 | 2025-06-01 00:00:00.000 | 117780 | 21272956 |
10 | 2025-05-31 00:00:00.000 | 110852 | 21155176 |
11 | 2025-05-30 00:00:00.000 | 136983 | 21044324 |
12 | 2025-05-29 00:00:00.000 | 139242 | 20907341 |
13 | 2025-05-28 00:00:00.000 | 153011 | 20768099 |
14 | 2025-05-27 00:00:00.000 | 158065 | 20615088 |
15 | 2025-05-26 00:00:00.000 | 163463 | 20457023 |
16 | 2025-05-25 00:00:00.000 | 143745 | 20293560 |
17 | 2025-05-24 00:00:00.000 | 156963 | 20149815 |
18 | 2025-05-23 00:00:00.000 | 154588 | 19992852 |
19 | 2025-05-22 00:00:00.000 | 161207 | 19838264 |
20 | 2025-05-21 00:00:00.000 | 157059 | 19677057 |
BlockTrackercontract deployed
Updated 2025-05-26
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: 15 days ago
...
154
6KB
615s