DATE | CHAIN | CONTRACT_DEPLOYED | |
|---|---|---|---|
1 | 2025-02-13 00:00:00.000 | Base | 21894 |
2 | 2025-02-17 00:00:00.000 | Base | 42236 |
3 | 2025-03-31 00:00:00.000 | Base | 62881 |
4 | 2025-02-13 00:00:00.000 | Avalanche | 1346 |
5 | 2025-02-17 00:00:00.000 | Avalanche | 1489 |
6 | 2025-03-31 00:00:00.000 | Avalanche | 1782 |
7 | 2025-02-16 00:00:00.000 | Base | 38361 |
8 | 2025-03-02 00:00:00.000 | Base | 50967 |
9 | 2025-03-22 00:00:00.000 | Base | 56054 |
10 | 2025-03-02 00:00:00.000 | Avalanche | 1534 |
11 | 2025-02-16 00:00:00.000 | Avalanche | 1100 |
12 | 2025-03-22 00:00:00.000 | Avalanche | 2024 |
13 | 2025-03-06 00:00:00.000 | Base | 58342 |
14 | 2025-03-11 00:00:00.000 | Base | 47249 |
15 | 2025-03-11 00:00:00.000 | Avalanche | 1642 |
16 | 2025-03-06 00:00:00.000 | Avalanche | 2820 |
17 | 2025-04-12 00:00:00.000 | Base | 43424 |
18 | 2025-04-16 00:00:00.000 | Base | 73001 |
19 | 2025-05-08 00:00:00.000 | Base | 56763 |
20 | 2025-04-12 00:00:00.000 | Avalanche | 10540 |
BlockTrackercontract deployed
Updated 2025-02-10
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
›
⌄
with base_ as (
select
date_trunc('{{granularity}}', block_timestamp) as date,
'Base' as chain,
count(DISTINCT tx_hash) as contract_deployed
from base.core.fact_traces
where block_timestamp :: date >= dateadd(day, -{{past_days}}, current_date())
and date < current_date
and type ilike 'CREATE%'
group by 1
)
, avalanche_ as (
select
date_trunc('{{granularity}}', block_timestamp) as date,
'Avalanche' as chain,
count(DISTINCT tx_hash) as contract_deployed
from avalanche.core.fact_traces
where block_timestamp :: date >= dateadd(day, -{{past_days}}, current_date())
and date < current_date
and type ilike 'CREATE%'
group by 1
)
select *
from base_
union all
select *
from avalanche_
Last run: 20 days ago
...
180
8KB
376s