HOUR | NEW_CONTRACTS | TOT_CONTRACTS | |
|---|---|---|---|
1 | 2024-12-07 00:00:00.000 | 2 | 2 |
2 | 2024-12-09 00:00:00.000 | 29 | 31 |
3 | 2024-12-10 00:00:00.000 | 10 | 41 |
4 | 2024-12-11 00:00:00.000 | 23 | 64 |
5 | 2024-12-12 00:00:00.000 | 96 | 160 |
6 | 2024-12-13 00:00:00.000 | 34 | 194 |
7 | 2024-12-14 00:00:00.000 | 7 | 201 |
8 | 2024-12-16 00:00:00.000 | 59 | 260 |
9 | 2024-12-17 00:00:00.000 | 216 | 476 |
10 | 2024-12-18 00:00:00.000 | 428 | 904 |
11 | 2024-12-19 00:00:00.000 | 521 | 1425 |
12 | 2024-12-20 00:00:00.000 | 292 | 1717 |
13 | 2024-12-21 00:00:00.000 | 263 | 1980 |
14 | 2024-12-22 00:00:00.000 | 406 | 2386 |
15 | 2024-12-23 00:00:00.000 | 450 | 2836 |
16 | 2024-12-24 00:00:00.000 | 454 | 3290 |
17 | 2024-12-25 00:00:00.000 | 581 | 3871 |
18 | 2024-12-26 00:00:00.000 | 533 | 4404 |
19 | 2024-12-27 00:00:00.000 | 528 | 4932 |
20 | 2024-12-28 00:00:00.000 | 456 | 5388 |
mamad-5XN3k3INK 5
Updated 2025-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
date_trunc('day', min_date) as hour,
count(distinct contract) as new_contracts,
sum(count(distinct contract)) over (order by date_trunc('day', min_date) asc) as tot_contracts
from (
select
contract_address as contract,
min(block_timestamp) as min_date
from ink.core.fact_event_logs
where tx_succeeded = 'TRUE'
--and block_timestamp >= '2024-12-17 11:00:00.000'
group by 1
)
group by 1
order by 1 asc
Last run: 18 days ago
...
119
4KB
3s