DATE | New Game Player | Cumulative New Game Player | |
|---|---|---|---|
1 | 2025-01-15 00:00:00.000 | 15127 | 172717 |
2 | 2025-01-08 00:00:00.000 | 7904 | 72289 |
3 | 2025-01-24 00:00:00.000 | 11042 | 309104 |
4 | 2025-02-21 00:00:00.000 | 11911 | 607427 |
5 | 2025-03-12 00:00:00.000 | 3147 | 757967 |
6 | 2025-02-03 00:00:00.000 | 7295 | 402436 |
7 | 2025-02-20 00:00:00.000 | 15941 | 595516 |
8 | 2025-03-10 00:00:00.000 | 6476 | 750171 |
9 | 2025-03-28 00:00:00.000 | 7242 | 914688 |
10 | 2025-01-21 00:00:00.000 | 12537 | 272012 |
11 | 2025-01-07 00:00:00.000 | 26350 | 64385 |
12 | 2025-03-29 00:00:00.000 | 5359 | 920047 |
13 | 2025-03-19 00:00:00.000 | 6555 | 850982 |
14 | 2025-02-02 00:00:00.000 | 5789 | 395141 |
15 | 2025-03-01 00:00:00.000 | 9051 | 675413 |
16 | 2025-03-17 00:00:00.000 | 4041 | 835299 |
17 | 2025-01-16 00:00:00.000 | 16785 | 189502 |
18 | 2025-02-26 00:00:00.000 | 6762 | 651960 |
19 | 2025-02-04 00:00:00.000 | 7486 | 409922 |
20 | 2025-01-27 00:00:00.000 | 29665 | 356914 |
hess13. New Game Users
Updated 2025-04-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with platforms as ( select * from $query('798c2d2f-083d-45a4-90e3-262eb17af08f')
where label_type = 'games'
)
,
final as (select min(block_timestamp::date) as date,
from_address,
count(distinct block_timestamp::Date) as days
from ronin.core.fact_transactions a join platforms b on a.to_address = b.address
group by 2)
select date,
count(distinct from_address) as "New Game Player",
sum("New Game Player") over (order by date asc) as "Cumulative New Game Player"
from final
where date >= '2025-01-01'
group by 1
Last run: 15 days ago
99
4KB
12s