DATE | CONTRACT_ADDRESSES | CUMULATIVE_CONTRACT_ADDRESSES | NEW_CONTRACT_ADDRESSES | OLD_NEW_CONTRACT_ADDRESSES | |
|---|---|---|---|---|---|
1 | 2024-05-01 00:00:00.000 | 531 | 531 | 531 | 0 |
2 | 2024-06-01 00:00:00.000 | 1973 | 2504 | 1790 | 183 |
3 | 2024-07-01 00:00:00.000 | 2665 | 5169 | 2329 | 336 |
4 | 2024-08-01 00:00:00.000 | 3607 | 8776 | 3115 | 492 |
5 | 2024-09-01 00:00:00.000 | 6421 | 15197 | 5261 | 1160 |
6 | 2024-10-01 00:00:00.000 | 62365 | 77562 | 61198 | 1167 |
7 | 2024-11-01 00:00:00.000 | 132067 | 209629 | 130645 | 1422 |
8 | 2024-12-01 00:00:00.000 | 244638 | 454267 | 242958 | 1680 |
9 | 2025-01-01 00:00:00.000 | 480379 | 934646 | 478636 | 1743 |
10 | 2025-02-01 00:00:00.000 | 368331 | 1302977 | 366629 | 1702 |
11 | 2025-03-01 00:00:00.000 | 24604 | 1327581 | 22850 | 1754 |
12 | 2025-04-01 00:00:00.000 | 77257 | 1404838 | 75852 | 1405 |
Afonso_DiazNew and old contracts overtime
Updated 2025-04-16
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
main as (
select
tx_hash,
block_timestamp,
contract_address
from
sei.core_evm.fact_event_logs
where
tx_status = 'SUCCESS'
and block_timestamp >= '2024-01-01'
),
new_contract_addresses as (
select
date_trunc('{{ period }}', min_date) as date,
count(distinct contract_address) as new_contract_address
from (
select
contract_address,
min(block_timestamp) as min_date
from
main
where block_timestamp >= '2024-01-01'
group by 1
)
group by 1
),
overtime as (
select
date_trunc('{{ period }}', block_timestamp) as date,
count(distinct contract_address) as contract_addresses,
Last run: 26 days ago
12
607B
11s