DATE | ACTIVE_CONTRACT | NEW_CONTRACT | RETURNING_CONTRACT | |
|---|---|---|---|---|
1 | 2025-01-10 00:00:00.000 | 43 | 2 | 41 |
2 | 2025-03-22 00:00:00.000 | 71 | 1 | 70 |
3 | 2025-02-16 00:00:00.000 | 61 | 3 | 58 |
4 | 2025-03-02 00:00:00.000 | 70 | 6 | 64 |
5 | 2025-01-19 00:00:00.000 | 52 | 1 | 51 |
6 | 2025-03-19 00:00:00.000 | 78 | 3 | 75 |
7 | 2025-03-15 00:00:00.000 | 63 | 1 | 62 |
8 | 2025-03-14 00:00:00.000 | 86 | 3 | 83 |
9 | 2025-02-17 00:00:00.000 | 62 | 2 | 60 |
10 | 2025-03-31 00:00:00.000 | 319 | 169 | 150 |
11 | 2025-02-13 00:00:00.000 | 96 | 34 | 62 |
12 | 2024-12-20 00:00:00.000 | 56 | 19 | 37 |
13 | 2025-02-20 00:00:00.000 | 56 | 56 | |
14 | 2024-12-27 00:00:00.000 | 59 | 22 | 37 |
15 | 2025-02-09 00:00:00.000 | 66 | 4 | 62 |
16 | 2025-03-06 00:00:00.000 | 187 | 106 | 81 |
17 | 2025-01-30 00:00:00.000 | 59 | 3 | 56 |
18 | 2025-03-11 00:00:00.000 | 77 | 3 | 74 |
19 | 2025-01-01 00:00:00.000 | 44 | 2 | 42 |
20 | 2025-02-15 00:00:00.000 | 63 | 63 |
BlockTrackeractive vs new contracts
Updated 2025-04-06
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
›
⌄
-- forked from active vs new contracts @ https://flipsidecrypto.xyz/studio/queries/6394b0dc-84a9-428a-ba2d-bd0a38c06a8f
with contract_list as (
select
distinct to_address as address
from swell.core.fact_traces
where type ilike '%CREATE%'
and TX_SUCCEEDED
and input <> '0x'
and to_address is not null
and ORIGIN_FUNCTION_SIGNATURE <> '0x'
)
,
total_new_contract as (
select
date_trunc('{{granularity}}', first_tx) as date,
count(distinct address) as new_contract
from (
select
to_address as address,
min(block_timestamp) as first_tx
from swell.core.fact_transactions
where 1 = 1
and to_address IN (select address from contract_list)
group by 1
)
group by 1
)
, total_active_contract as (
select
date_trunc('{{granularity}}', block_timestamp) as date,
count(distinct to_address) as active_contract
from swell.core.fact_transactions
where 1=1
and to_address IN (select address from contract_list)
group by 1
Last run: 22 days ago
...
128
5KB
2s