Date | Total Users | Active Users | New Users | |
|---|---|---|---|---|
1 | 2023-01-01 00:00:00.000 | 356660 | 115772 | 240888 |
2 | 2023-02-01 00:00:00.000 | 205137 | 98008 | 107129 |
3 | 2023-03-01 00:00:00.000 | 214726 | 99904 | 114822 |
4 | 2023-04-01 00:00:00.000 | 327525 | 106098 | 221427 |
5 | 2023-05-01 00:00:00.000 | 300204 | 100106 | 200098 |
6 | 2023-06-01 00:00:00.000 | 309196 | 111847 | 197349 |
7 | 2023-07-01 00:00:00.000 | 1164185 | 141594 | 1022591 |
8 | 2023-08-01 00:00:00.000 | 1738995 | 242743 | 1496252 |
9 | 2023-09-01 00:00:00.000 | 914476 | 243230 | 671246 |
10 | 2023-10-01 00:00:00.000 | 1516775 | 518812 | 997963 |
11 | 2023-11-01 00:00:00.000 | 746344 | 266282 | 480062 |
12 | 2023-12-01 00:00:00.000 | 989278 | 339337 | 649941 |
13 | 2024-01-01 00:00:00.000 | 1622489 | 371633 | 1250856 |
Eman-RazUsers Over Time
Updated 2024-01-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with table1 as (select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", count(distinct sender) as "Total Users"
from aptos.core.fact_transactions
where sender is not null and success='true'
group by 1
order by 1),
table2 as (with tab1 as (select sender, min(block_timestamp::date) as first_tx
from aptos.core.fact_transactions
where success='true'
group by 1)
select date_trunc('{{Time_Frame}}',first_tx) as "Date", count(distinct sender) as "New Users"
from tab1
group by 1)
select table1."Date" as "Date", "Total Users", "Total Users"-"New Users" as "Active Users", "New Users"
from table1 left join table2 on table1."Date"=table2."Date"
where table1."Date">='{{Start_Date}}' and table1."Date"<='{{End_Date}}'
order by 1
Last run: 7 days ago
13
643B
173s