Date | total users | Users | New Users | Active Users | |
|---|---|---|---|---|---|
1 | 2025-04-01 00:00:00.000 | 23733 | 334 | 164 | 170 |
2 | 2025-03-01 00:00:00.000 | 23569 | 1572 | 1059 | 513 |
3 | 2025-02-01 00:00:00.000 | 22510 | 1051 | 575 | 476 |
4 | 2025-01-01 00:00:00.000 | 21935 | 1421 | 866 | 555 |
5 | 2024-12-01 00:00:00.000 | 21069 | 1602 | 1090 | 512 |
6 | 2024-11-01 00:00:00.000 | 19979 | 1644 | 1126 | 518 |
7 | 2024-10-01 00:00:00.000 | 18853 | 5341 | 4872 | 469 |
8 | 2024-09-01 00:00:00.000 | 13981 | 1077 | 730 | 347 |
9 | 2024-08-01 00:00:00.000 | 13251 | 1177 | 868 | 309 |
10 | 2024-07-01 00:00:00.000 | 12383 | 1568 | 1276 | 292 |
11 | 2024-06-01 00:00:00.000 | 11107 | 1616 | 1355 | 261 |
12 | 2024-05-01 00:00:00.000 | 9752 | 8295 | 8122 | 173 |
13 | 2024-04-01 00:00:00.000 | 1630 | 714 | 623 | 91 |
14 | 2024-03-01 00:00:00.000 | 1007 | 403 | 297 | 106 |
15 | 2024-02-01 00:00:00.000 | 710 | 391 | 332 | 59 |
16 | 2024-01-01 00:00:00.000 | 378 | 338 | 298 | 40 |
17 | 2023-12-01 00:00:00.000 | 80 | 80 | 80 | 0 |
Flipside Axelar AnalystsNumber of Users Over Time
Updated 43 minutes 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 table1 as (
select
date_trunc('month', created_at) as "Date",
count(distinct call:transaction:from) as "Users"
from
axelar.axelscan.fact_gmp
where
call ilike '%0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c%'
group by
1
),
table2 as (
with tab1 as (
select
call:transaction:from as user,
min(created_at :: date) as first_use
from
axelar.axelscan.fact_gmp
where
call ilike '%0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c%'
group by
1
)
select
date_trunc('month', first_use) as "Date",
count(distinct user) as "New Users",
sum("New Users")over(order by "Date") as "total users"
from
tab1
group by
1
)
select
table1."Date" as "Date",
"total users",
"Users",
Last run: 43 minutes agoAuto-refreshes every 24 hours
17
784B
291s