New Game Player | |
|---|---|
1 | 997210 |
hess14. Total Game users
Updated 2025-04-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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
count(distinct from_address) as "New Game Player"
from final
where date >= '2025-01-01'
Last run: 18 days ago
1
10B
9s