DATE | TRANSACTIONS | USERS | CUMULATIVE_TRANSACTIONS | NEW_USERS | RETURNING_USERS | |
---|---|---|---|---|---|---|
1 | 2024-08-01 00:00:00.000 | 2054 | 140 | 2054 | 140 | 0 |
2 | 2024-09-01 00:00:00.000 | 13767 | 1890 | 15821 | 1802 | 88 |
3 | 2024-10-01 00:00:00.000 | 7040 | 1013 | 22861 | 836 | 177 |
4 | 2024-11-01 00:00:00.000 | 41175 | 974 | 64036 | 695 | 279 |
5 | 2024-12-01 00:00:00.000 | 10660 | 1011 | 74696 | 703 | 308 |
6 | 2025-01-01 00:00:00.000 | 5180 | 1046 | 79876 | 602 | 444 |
7 | 2025-02-01 00:00:00.000 | 9532 | 1146 | 89408 | 817 | 329 |
8 | 2025-03-01 00:00:00.000 | 15408 | 1210 | 104816 | 771 | 439 |
9 | 2025-04-01 00:00:00.000 | 12379 | 788 | 117195 | 273 | 515 |
10 | 2025-05-01 00:00:00.000 | 8287 | 507 | 125482 | 156 | 351 |
Afonso_DiazOvertime
Updated 10 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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
main as (
select
tx_hash,
block_timestamp,
sender as user
from
aptos.core.fact_transactions
where
payload_function ilike '0x2fe576faa841347a9b1b32c869685deb75a15e3f62dfe37cbd6d52cc403a16f6%'
),
overtime as (
select
date_trunc('{{ period }}', block_timestamp) as date,
count(distinct tx_hash) as transactions,
count(distinct user) as users,
sum(transactions) over (order by date) as cumulative_transactions
from main
group by 1
),
new_users as (
select
date_trunc('{{ period }}', min_date) as date,
count(distinct user) as new_user
from (
select
user,
min(block_timestamp)::date as min_date
from main
group by 1
)
group by 1
)
Last run: 10 days ago
10
522B
85s