DATE | TRANSACTIONS | ACTIVE_CONTRACTS | USERS | CUMULATIVE_TRANSACTIONS | NEW_CONTRACTS | OLD_CONTRACTS | |
|---|---|---|---|---|---|---|---|
1 | 2024-12-07 00:00:00.000 | 2 | 1 | 1 | 2 | 1 | 0 |
2 | 2024-12-08 00:00:00.000 | 2 | 1 | 1 | 4 | 0 | 1 |
3 | 2024-12-09 00:00:00.000 | 37 | 4 | 4 | 41 | 3 | 1 |
4 | 2024-12-10 00:00:00.000 | 18 | 4 | 4 | 59 | 3 | 1 |
5 | 2024-12-11 00:00:00.000 | 92 | 19 | 6 | 151 | 16 | 3 |
6 | 2024-12-12 00:00:00.000 | 239 | 15 | 12 | 390 | 12 | 3 |
7 | 2024-12-13 00:00:00.000 | 202 | 28 | 12 | 592 | 23 | 5 |
8 | 2024-12-14 00:00:00.000 | 119 | 8 | 9 | 711 | 5 | 3 |
9 | 2024-12-15 00:00:00.000 | 101 | 2 | 3 | 812 | 0 | 2 |
10 | 2024-12-16 00:00:00.000 | 279 | 49 | 21 | 1091 | 29 | 20 |
11 | 2024-12-17 00:00:00.000 | 12625 | 139 | 1378 | 13716 | 124 | 15 |
12 | 2024-12-18 00:00:00.000 | 24646 | 296 | 3917 | 38362 | 239 | 57 |
13 | 2024-12-19 00:00:00.000 | 20712 | 366 | 5980 | 59074 | 266 | 100 |
14 | 2024-12-20 00:00:00.000 | 11347 | 233 | 2302 | 70421 | 124 | 109 |
15 | 2024-12-21 00:00:00.000 | 7779 | 201 | 1919 | 78200 | 92 | 109 |
16 | 2024-12-22 00:00:00.000 | 7698 | 190 | 1895 | 85898 | 96 | 94 |
17 | 2024-12-23 00:00:00.000 | 10111 | 187 | 2677 | 96009 | 86 | 101 |
18 | 2024-12-24 00:00:00.000 | 16793 | 188 | 4438 | 112802 | 81 | 107 |
19 | 2024-12-25 00:00:00.000 | 18705 | 206 | 4177 | 131507 | 110 | 96 |
20 | 2024-12-26 00:00:00.000 | 21567 | 186 | 5493 | 153074 | 71 | 115 |
Afonso_DiazOvertime
Updated 2025-03-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
30
31
32
33
34
35
36
›
⌄
with
main as (
select
tx_hash,
block_timestamp,
origin_from_address as user,
origin_to_address as contract_address
from
ink.core.fact_event_logs
where
tx_succeeded
),
t1 as (
select
date_trunc('{{ period }}', block_timestamp) as date,
count(distinct tx_hash) as transactions,
count(distinct contract_address) as active_contracts,
count(distinct user) as users,
sum(transactions) over (order by date) as cumulative_transactions
from
main
group by 1
),
t2 as (
select
date_trunc('{{ period }}', min_date) as date,
count(distinct contract_address) as new_contract
from (
select
contract_address,
min(block_timestamp) as min_date
from
main
Last run: about 1 month ago
90
5KB
8s