DATE | NEW_USERS | CUMULATIVE_NEW_USERS | DAILY_ACTIVE_USERS | |
|---|---|---|---|---|
1 | 2025-04-21 00:00:00.000 | 198 | 2084 | 291 |
2 | 2025-04-20 00:00:00.000 | 361 | 1886 | 446 |
3 | 2025-04-19 00:00:00.000 | 340 | 1525 | 420 |
4 | 2025-04-18 00:00:00.000 | 14 | 1185 | 87 |
5 | 2025-04-17 00:00:00.000 | 21 | 1171 | 99 |
6 | 2025-04-16 00:00:00.000 | 10 | 1150 | 84 |
7 | 2025-04-15 00:00:00.000 | 10 | 1140 | 84 |
8 | 2025-04-14 00:00:00.000 | 14 | 1130 | 79 |
9 | 2025-04-13 00:00:00.000 | 14 | 1116 | 77 |
10 | 2025-04-12 00:00:00.000 | 11 | 1102 | 68 |
11 | 2025-04-11 00:00:00.000 | 19 | 1091 | 86 |
12 | 2025-04-10 00:00:00.000 | 20 | 1072 | 79 |
13 | 2025-04-09 00:00:00.000 | 13 | 1052 | 75 |
14 | 2025-04-08 00:00:00.000 | 18 | 1039 | 62 |
15 | 2025-04-07 00:00:00.000 | 19 | 1021 | 81 |
16 | 2025-04-06 00:00:00.000 | 10 | 1002 | 56 |
17 | 2025-04-05 00:00:00.000 | 6 | 992 | 51 |
18 | 2025-04-04 00:00:00.000 | 9 | 986 | 57 |
19 | 2025-04-03 00:00:00.000 | 12 | 977 | 54 |
20 | 2025-04-02 00:00:00.000 | 13 | 965 | 57 |
adriaparcerisasdogeswap 1.2
Updated 2025-04-22
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
›
⌄
with daily_users as (
select
trunc(block_timestamp, 'day') as date,
signer_id
from near.core.fact_actions_events_function_call
where block_timestamp > '2024-12-01'
and receiver_id = 'intents.near'
and action_name = 'FunctionCall'
and method_name = 'ft_on_transfer'
and receipt_succeeded = 'TRUE'
and block_timestamp < current_date
),
first_seen as (
select
signer_id,
min(date) as first_interaction_date
from daily_users
group by signer_id
)
select
d.date,
count(distinct case when f.first_interaction_date = d.date then f.signer_id end) as new_users,
sum(count(distinct case when f.first_interaction_date = d.date then f.signer_id end))
over (order by d.date) as cumulative_new_users,
count(distinct d.signer_id) as daily_active_users
from daily_users d
left join first_seen f
on d.signer_id = f.signer_id
group by d.date
order by d.date desc
Last run: 15 days ago
...
142
5KB
28s