OPERATION_DATE | DAILY_UNIQUE_WASM_UPLOADS | DAILY_UNIQUE_CONTRACT_INVOCATIONS | CUMULATIVE_UNIQUE_WASM_UPLOADS | CUMULATIVE_UNIQUE_CONTRACT_INVOCATIONS | |
|---|---|---|---|---|---|
1 | 2025-03-13 00:00:00.000 | 1 | 135 | 850 | 19324 |
2 | 2025-03-12 00:00:00.000 | 7 | 190 | 849 | 19189 |
3 | 2025-03-11 00:00:00.000 | 13 | 183 | 842 | 18999 |
4 | 2025-03-10 00:00:00.000 | 4 | 200 | 829 | 18816 |
5 | 2025-03-09 00:00:00.000 | 1 | 154 | 825 | 18616 |
6 | 2025-03-08 00:00:00.000 | 1 | 165 | 824 | 18462 |
7 | 2025-03-07 00:00:00.000 | 3 | 176 | 823 | 18297 |
8 | 2025-03-06 00:00:00.000 | 2 | 174 | 820 | 18121 |
9 | 2025-03-05 00:00:00.000 | 2 | 154 | 818 | 17947 |
10 | 2025-03-04 00:00:00.000 | 3 | 152 | 816 | 17793 |
11 | 2025-03-03 00:00:00.000 | 0 | 133 | 813 | 17641 |
12 | 2025-03-02 00:00:00.000 | 1 | 125 | 813 | 17508 |
13 | 2025-03-01 00:00:00.000 | 1 | 123 | 812 | 17383 |
14 | 2025-02-28 00:00:00.000 | 1 | 128 | 811 | 17260 |
15 | 2025-02-27 00:00:00.000 | 1 | 121 | 810 | 17132 |
16 | 2025-02-26 00:00:00.000 | 1 | 122 | 809 | 17011 |
17 | 2025-02-25 00:00:00.000 | 3 | 140 | 808 | 16889 |
18 | 2025-02-24 00:00:00.000 | 0 | 124 | 805 | 16749 |
19 | 2025-02-23 00:00:00.000 | 0 | 114 | 805 | 16625 |
20 | 2025-02-22 00:00:00.000 | 1 | 111 | 805 | 16511 |
permaryDaily unique contract upload and invocation
Updated 5 days ago
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
›
⌄
with daily_operations as (
select
date_trunc('day', closed_at) as operation_date,
soroban_operation_type,
count(distinct case
when soroban_operation_type = 'upload_wasm' then contract_code_hash
when soroban_operation_type = 'invoke_contract' then contract_id
end) as unique_count
from stellar.core.fact_operations
where soroban_operation_type in ('upload_wasm', 'invoke_contract')
and closed_at >= dateadd('month', -12, current_timestamp) -- fetch last 12 months
group by 1, 2
)
select
operation_date,
sum(case when soroban_operation_type = 'upload_wasm' then unique_count else 0 end) as daily_unique_wasm_uploads,
sum(case when soroban_operation_type = 'invoke_contract' then unique_count else 0 end) as daily_unique_contract_invocations,
sum(sum(case when soroban_operation_type = 'upload_wasm' then unique_count else 0 end))
over (order by operation_date) as cumulative_unique_wasm_uploads,
sum(sum(case when soroban_operation_type = 'invoke_contract' then unique_count else 0 end))
over (order by operation_date) as cumulative_unique_contract_invocations
from daily_operations
group by 1
order by operation_date desc;
Last run: 5 days ago
...
366
15KB
2s