DAILY | NEW_USERS | CUM_NEW_USERS | |
|---|---|---|---|
1 | 2025-03-10 00:00:00.000 | 86984 | 969504 |
2 | 2025-02-24 00:00:00.000 | 27233 | 305991 |
3 | 2025-03-16 00:00:00.000 | 73012 | 1319954 |
4 | 2025-02-20 00:00:00.000 | 41847 | 169487 |
5 | 2025-02-21 00:00:00.000 | 26523 | 196010 |
6 | 2025-03-03 00:00:00.000 | 31378 | 505128 |
7 | 2025-03-12 00:00:00.000 | 53367 | 1067835 |
8 | 2025-02-17 00:00:00.000 | 33191 | 33191 |
9 | 2025-03-14 00:00:00.000 | 55070 | 1179088 |
10 | 2025-03-15 00:00:00.000 | 67854 | 1246942 |
11 | 2025-03-04 00:00:00.000 | 38498 | 543626 |
12 | 2025-02-27 00:00:00.000 | 25669 | 407052 |
13 | 2025-03-02 00:00:00.000 | 28618 | 473750 |
14 | 2025-03-01 00:00:00.000 | 11441 | 445132 |
15 | 2025-03-17 00:00:00.000 | 100435 | 1420389 |
16 | 2025-03-20 00:00:00.000 | 6801 | 1527586 |
17 | 2025-02-23 00:00:00.000 | 40841 | 278758 |
18 | 2025-03-19 00:00:00.000 | 61502 | 1520785 |
19 | 2025-02-26 00:00:00.000 | 56478 | 381383 |
20 | 2025-03-08 00:00:00.000 | 86175 | 783122 |
saeedmzn[New accounts on SEI] new accounts over time
Updated 2025-03-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with New_users as (
select TX_FROM ,
min (BLOCK_TIMESTAMP) ::date min_date
from sei.core.fact_transactions
group by 1 having min_date >= (current_date-1) - 30
)
select min_date daily ,
count (TX_FROM) new_users ,
sum (new_users) over (order by daily) cum_new_users
from New_users
group by 1
Last run: 28 days agoAuto-refreshes every 24 hours
32
1KB
255s