DEPLOYMENT_DATE | DAILY_CONTRACTS_DEPLOYED | CUMULATIVE_CONTRACTS_DEPLOYED | |
|---|---|---|---|
1 | 2025-03-13 00:00:00.000 | 2 | 2148 |
2 | 2025-03-12 00:00:00.000 | 6 | 2146 |
3 | 2025-03-10 00:00:00.000 | 1 | 2140 |
4 | 2025-03-09 00:00:00.000 | 3 | 2139 |
5 | 2025-03-08 00:00:00.000 | 1 | 2136 |
6 | 2025-03-07 00:00:00.000 | 1 | 2135 |
7 | 2025-03-04 00:00:00.000 | 3 | 2134 |
8 | 2025-03-03 00:00:00.000 | 3 | 2131 |
9 | 2025-03-02 00:00:00.000 | 2 | 2128 |
10 | 2025-03-01 00:00:00.000 | 4 | 2126 |
11 | 2025-02-28 00:00:00.000 | 2 | 2122 |
12 | 2025-02-27 00:00:00.000 | 1 | 2120 |
13 | 2025-02-26 00:00:00.000 | 2 | 2119 |
14 | 2025-02-24 00:00:00.000 | 2 | 2117 |
15 | 2025-02-23 00:00:00.000 | 1 | 2115 |
16 | 2025-02-21 00:00:00.000 | 2 | 2114 |
17 | 2025-02-20 00:00:00.000 | 1 | 2112 |
18 | 2025-02-19 00:00:00.000 | 2 | 2111 |
19 | 2025-02-18 00:00:00.000 | 10 | 2109 |
20 | 2025-02-17 00:00:00.000 | 1 | 2099 |
permaryDaily Contracts Deployed
Updated 5 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with daily_deployments as (
select
date_trunc('day', closed_at) as deployment_date,
count(distinct contract_id) as daily_contracts_deployed
from stellar.core.fact_operations
where
soroban_operation_type = 'create_contract'
group by 1
)
select
deployment_date,
daily_contracts_deployed,
sum(daily_contracts_deployed) over (order by deployment_date) as cumulative_contracts_deployed
from daily_deployments
order by deployment_date desc;
Last run: 5 days ago
...
314
11KB
2s