DATE | # of deployed contracts | Total contract deployments | |
|---|---|---|---|
1 | 2025-04-01 00:00:00.000 | 1886 | 709709 |
2 | 2025-03-01 00:00:00.000 | 9793 | 707823 |
3 | 2025-02-01 00:00:00.000 | 12044 | 698030 |
4 | 2025-01-01 00:00:00.000 | 13367 | 685986 |
5 | 2024-12-01 00:00:00.000 | 51714 | 672619 |
6 | 2024-11-01 00:00:00.000 | 69091 | 620905 |
7 | 2024-10-01 00:00:00.000 | 75184 | 551814 |
8 | 2024-09-01 00:00:00.000 | 53499 | 476630 |
9 | 2024-08-01 00:00:00.000 | 9974 | 423131 |
10 | 2024-07-01 00:00:00.000 | 54362 | 413157 |
11 | 2024-06-01 00:00:00.000 | 102695 | 358795 |
12 | 2024-05-01 00:00:00.000 | 59751 | 256100 |
13 | 2024-04-01 00:00:00.000 | 67759 | 196349 |
14 | 2024-03-01 00:00:00.000 | 121519 | 128590 |
15 | 2024-02-01 00:00:00.000 | 7071 | 7071 |
rezarwzContract Deployments
Updated 2025-03-28
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
28
29
30
31
32
33
34
35
36
›
⌄
⌄
/*with all_contracts as (
SELECT
block_number,
block_timestamp,
tx_hash,
to_address AS created_contract_address,
from_address AS creator_address,
input AS created_contract_input,
INSERTED_TIMESTAMP
from
blast.core.fact_traces
WHERE
TYPE ILIKE 'create%'
AND to_address IS NOT NULL
AND input IS NOT NULL
AND input != '0x'
AND tx_status = 'SUCCESS'
AND trace_status = 'SUCCESS'
)*/
SELECT
date_trunc('{{interval}}', block_Timestamp) as date,
count(tx_hash) as "# of deployed contracts",
sum("# of deployed contracts") over (
ORDER by
date asc
) as "Total contract deployments"
from
blast.core.fact_traces
WHERE
TYPE ILIKE 'create%'
AND to_address IS NOT NULL
AND input IS NOT NULL
AND input != '0x'
AND tx_status = 'SUCCESS'
AND trace_status = 'SUCCESS'
group by
Last run: 18 days ago
15
612B
201s