HOURLY | Total Contract | New Contract | Active Contract | |
|---|---|---|---|---|
1 | 2025-02-05 22:00:00.000 | 249 | 0 | 249 |
2 | 2025-02-06 19:00:00.000 | 303 | 0 | 303 |
3 | 2025-02-06 23:00:00.000 | 71 | 0 | 71 |
4 | 2025-02-06 09:00:00.000 | 347 | 0 | 347 |
5 | 2025-02-06 10:00:00.000 | 309 | 1 | 308 |
6 | 2025-02-06 13:00:00.000 | 325 | 0 | 325 |
7 | 2025-02-05 00:00:00.000 | 239 | 0 | 239 |
8 | 2025-02-05 10:00:00.000 | 329 | 1 | 328 |
9 | 2025-02-06 08:00:00.000 | 305 | 0 | 305 |
10 | 2025-02-06 07:00:00.000 | 319 | 0 | 319 |
11 | 2025-02-05 06:00:00.000 | 294 | 1 | 293 |
12 | 2025-02-05 14:00:00.000 | 325 | 2 | 323 |
13 | 2025-02-06 22:00:00.000 | 257 | 0 | 257 |
14 | 2025-02-06 14:00:00.000 | 356 | 1 | 355 |
15 | 2025-02-05 02:00:00.000 | 267 | 1 | 266 |
16 | 2025-02-05 08:00:00.000 | 302 | 0 | 302 |
17 | 2025-02-06 15:00:00.000 | 369 | 0 | 369 |
18 | 2025-02-06 05:00:00.000 | 293 | 5 | 288 |
19 | 2025-02-06 18:00:00.000 | 327 | 1 | 326 |
20 | 2025-02-06 01:00:00.000 | 276 | 0 | 276 |
Movement TeamDaily Active Contract and Deployer
Updated 2025-02-06
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
›
⌄
with active_contract as (SELECT trunc(block_timestamp,'hour') as hourly,
count(DISTINCT payload_function) AS no_contract,
FROM
aptos.core.fact_transactions
WHERE
tx_type = 'user_transaction'
and block_timestamp >= current_date - 1
group by 1)
,
new as ( select min(block_timestamp) as time,
payload_function
from aptos.core.fact_transactions
WHERE
tx_type = 'user_transaction'
group by 2)
,
new_contract as ( select trunc(time,'hour') as hourly,
count(DISTINCT payload_function) as "New"
from new
where time >= current_date - 1
group by 1)
select a.hourly,
no_contract as "Total Contract",
ifnull("New",0) as "New Contract",
"Total Contract"-"New Contract" as "Active Contract"
from active_contract a left outer join new_contract b on a.hourly = b.hourly
Last run: 2 months ago
48
2KB
75s