HOURLY | Deployed Contracts | Cumulative New Contracts | |
|---|---|---|---|
1 | 2025-02-06 18:00:00.000 | 1 | 76 |
2 | 2025-02-06 04:00:00.000 | 3 | 64 |
3 | 2025-02-06 06:00:00.000 | 1 | 70 |
4 | 2025-02-05 19:00:00.000 | 1 | 54 |
5 | 2025-02-05 10:00:00.000 | 1 | 26 |
6 | 2025-02-06 05:00:00.000 | 5 | 69 |
7 | 2025-02-05 20:00:00.000 | 2 | 56 |
8 | 2025-02-05 02:00:00.000 | 1 | 1 |
9 | 2025-02-06 11:00:00.000 | 3 | 74 |
10 | 2025-02-05 12:00:00.000 | 4 | 33 |
11 | 2025-02-05 07:00:00.000 | 3 | 24 |
12 | 2025-02-06 03:00:00.000 | 4 | 61 |
13 | 2025-02-05 16:00:00.000 | 1 | 53 |
14 | 2025-02-05 11:00:00.000 | 3 | 29 |
15 | 2025-02-06 10:00:00.000 | 1 | 71 |
16 | 2025-02-06 14:00:00.000 | 1 | 75 |
17 | 2025-02-05 13:00:00.000 | 17 | 50 |
18 | 2025-02-06 00:00:00.000 | 1 | 57 |
19 | 2025-02-05 03:00:00.000 | 5 | 6 |
20 | 2025-02-05 04:00:00.000 | 14 | 20 |
Movement TeamNew Daily Contracts
Updated 2025-02-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with new_contract as (SELECT min(block_timestamp) as date,
(payload_function) AS contract
FROM
aptos.core.fact_transactions
WHERE
tx_type = 'user_transaction'
group by 2 )
select trunc(date,'hour') as hourly,
count(DISTINCT contract) as "Deployed Contracts",
sum("Deployed Contracts") over (order by hourly asc) as "Cumulative New Contracts"
from new_contract
where hourly >= current_date - interval '1 DAY'
group by 1
Last run: 3 months ago
23
760B
87s