DATE | CONTRACT_DEPLOYED | CUMULATIVE_CONTRACT_DEPLOYED | |
|---|---|---|---|
1 | 2025-04-06 00:00:00.000 | 75 | 7594 |
2 | 2025-04-05 00:00:00.000 | 136 | 7519 |
3 | 2025-04-04 00:00:00.000 | 113 | 7383 |
4 | 2025-04-03 00:00:00.000 | 175 | 7270 |
5 | 2025-04-02 00:00:00.000 | 244 | 7095 |
6 | 2025-04-01 00:00:00.000 | 525 | 6851 |
7 | 2025-03-31 00:00:00.000 | 425 | 6326 |
8 | 2025-03-30 00:00:00.000 | 252 | 5901 |
9 | 2025-03-29 00:00:00.000 | 32 | 5649 |
10 | 2025-03-28 00:00:00.000 | 37 | 5617 |
11 | 2025-03-27 00:00:00.000 | 27 | 5580 |
12 | 2025-03-26 00:00:00.000 | 17 | 5553 |
13 | 2025-03-25 00:00:00.000 | 32 | 5536 |
14 | 2025-03-24 00:00:00.000 | 20 | 5504 |
15 | 2025-03-23 00:00:00.000 | 5 | 5484 |
16 | 2025-03-22 00:00:00.000 | 2 | 5479 |
17 | 2025-03-21 00:00:00.000 | 6 | 5477 |
18 | 2025-03-20 00:00:00.000 | 17 | 5471 |
19 | 2025-03-19 00:00:00.000 | 16 | 5454 |
20 | 2025-03-18 00:00:00.000 | 32 | 5438 |
BlockTrackercontract deployed
Updated 2025-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- forked from contract deployed @ https://flipsidecrypto.xyz/studio/queries/8f910da9-97b6-4bda-94db-5a8999ccaf26
select
date_trunc('{{granularity}}', block_timestamp) as date,
count(DISTINCT to_address) as contract_deployed,
sum(contract_deployed) over (order by date) as cumulative_contract_deployed
from swell.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: 21 days ago
...
125
4KB
1s