Day | Players | Total players | |
|---|---|---|---|
1 | 2025-03-31 00:00:00.000 | 1 | 526326 |
2 | 2025-03-30 00:00:00.000 | 25 | 526325 |
3 | 2025-03-29 00:00:00.000 | 31 | 526300 |
4 | 2025-03-28 00:00:00.000 | 25 | 526269 |
5 | 2025-03-27 00:00:00.000 | 77 | 526244 |
6 | 2025-03-26 00:00:00.000 | 72 | 526167 |
7 | 2025-03-25 00:00:00.000 | 24 | 526095 |
8 | 2025-03-24 00:00:00.000 | 25 | 526071 |
9 | 2025-03-23 00:00:00.000 | 26 | 526046 |
10 | 2025-03-22 00:00:00.000 | 35 | 526020 |
11 | 2025-03-21 00:00:00.000 | 28 | 525985 |
12 | 2025-03-20 00:00:00.000 | 15 | 525957 |
13 | 2025-03-19 00:00:00.000 | 38 | 525942 |
14 | 2025-03-18 00:00:00.000 | 26 | 525904 |
15 | 2025-03-17 00:00:00.000 | 50 | 525878 |
16 | 2025-03-16 00:00:00.000 | 47 | 525828 |
17 | 2025-03-15 00:00:00.000 | 57 | 525781 |
18 | 2025-03-14 00:00:00.000 | 69 | 525724 |
19 | 2025-03-13 00:00:00.000 | 39 | 525655 |
20 | 2025-03-12 00:00:00.000 | 50 | 525616 |
csp88gNew players and total players daily chart
Updated 2025-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with moon_users as (
select TO_ADDRESS as player, block_timestamp as start_playing_date
from near.core.ez_token_transfers
where block_timestamp::date >= '2024-04-01'
and CONTRACT_ADDRESS = 'aa-harvest-moon.near'
/*and player = 'minicooper.near'*/
qualify
row_number() over (partition by player order by block_timestamp ASC) = 1
)
/*select * from moon_users*/
select trunc(start_playing_date,'day') as "Day",
count (player) as "Players",
sum("Players") over (order by "Day" asc) as "Total players"
from moon_users
group by 1
order by 1 desc
Last run: 3 months ago
...
361
14KB
68s