DATE | CONTRACT_DEPLOYED | CUMULATIVE_CONTRACT_DEPLOYED | |
|---|---|---|---|
1 | 2025-04-06 00:00:00.000 | 2159 | 562446 |
2 | 2025-04-05 00:00:00.000 | 3149 | 560287 |
3 | 2025-04-04 00:00:00.000 | 3184 | 557138 |
4 | 2025-04-03 00:00:00.000 | 3542 | 553954 |
5 | 2025-04-02 00:00:00.000 | 4979 | 550412 |
6 | 2025-04-01 00:00:00.000 | 7171 | 545433 |
7 | 2025-03-31 00:00:00.000 | 3165 | 538262 |
8 | 2025-03-30 00:00:00.000 | 1058 | 535097 |
9 | 2025-03-29 00:00:00.000 | 828 | 534039 |
10 | 2025-03-28 00:00:00.000 | 819 | 533211 |
11 | 2025-03-27 00:00:00.000 | 1065 | 532392 |
12 | 2025-03-26 00:00:00.000 | 743 | 531327 |
13 | 2025-03-25 00:00:00.000 | 825 | 530584 |
14 | 2025-03-24 00:00:00.000 | 1879 | 529759 |
15 | 2025-03-23 00:00:00.000 | 2501 | 527880 |
16 | 2025-03-22 00:00:00.000 | 1871 | 525379 |
17 | 2025-03-21 00:00:00.000 | 90019 | 523508 |
18 | 2025-03-20 00:00:00.000 | 110570 | 433489 |
19 | 2025-03-19 00:00:00.000 | 119362 | 322919 |
20 | 2025-03-18 00:00:00.000 | 2345 | 203557 |
BlockTrackercontract deployed
Updated 8 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
date_trunc('day', block_timestamp) as date,
count(DISTINCT to_address) as contract_deployed,
sum(contract_deployed) over (order by date) as cumulative_contract_deployed
from ink.core.fact_traces
where type ilike '%CREATE%'
and TX_SUCCEEDED
and to_address is not null
and input <> '0x'
and ORIGIN_FUNCTION_SIGNATURE <> '0x'
group by 1
order by date desc
Last run: 8 days ago
...
119
5KB
15s