Date | New Users | Total New Users | |
|---|---|---|---|
1 | 2023-12-30 00:00:00.000 | 4473 | 4473 |
2 | 2023-12-31 00:00:00.000 | 3462 | 7935 |
3 | 2024-01-01 00:00:00.000 | 4579 | 12514 |
4 | 2024-01-02 00:00:00.000 | 7671 | 20185 |
5 | 2024-01-03 00:00:00.000 | 5400 | 25585 |
6 | 2024-01-04 00:00:00.000 | 6216 | 31801 |
7 | 2024-01-05 00:00:00.000 | 12561 | 44362 |
8 | 2024-01-06 00:00:00.000 | 9529 | 53891 |
9 | 2024-01-07 00:00:00.000 | 5118 | 59009 |
10 | 2024-01-08 00:00:00.000 | 10804 | 69813 |
11 | 2024-01-09 00:00:00.000 | 10309 | 80122 |
12 | 2024-01-10 00:00:00.000 | 8366 | 88488 |
13 | 2024-01-11 00:00:00.000 | 9097 | 97585 |
14 | 2024-01-12 00:00:00.000 | 15867 | 113452 |
15 | 2024-01-13 00:00:00.000 | 10361 | 123813 |
16 | 2024-01-14 00:00:00.000 | 7714 | 131527 |
17 | 2024-01-15 00:00:00.000 | 8014 | 139541 |
18 | 2024-01-16 00:00:00.000 | 5831 | 145372 |
19 | 2024-01-17 00:00:00.000 | 8794 | 154166 |
20 | 2024-01-18 00:00:00.000 | 5445 | 159611 |
Eman-RazTotal Number of New Users Over Time
Updated 2024-01-29
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with tab1 as (select tx_from, min(block_timestamp) as min_date
from sei.core.fact_transactions
where tx_succeeded='true'
group by 1)
select date_trunc('{{Time_Frame}}',min_date) as "Date", count(distinct tx_from) as "New Users",
sum("New Users") over (order by "Date" asc) as "Total New Users"
from tab1
where min_date::date>=current_date-{{Time_Period}}
group by 1
order by 1
Last run: about 1 year agoAuto-refreshes every 24 hours
31
1KB
100s