DATE | # Challenges | Cum. # Challenges | 7D MA | |
|---|---|---|---|---|
1 | 2025-04-09 00:00:00.000 | 16 | 5382 | 25.142 |
2 | 2025-04-08 00:00:00.000 | 30 | 5366 | 31.857 |
3 | 2025-04-07 00:00:00.000 | 27 | 5336 | 32.714 |
4 | 2025-04-06 00:00:00.000 | 27 | 5309 | 32.285 |
5 | 2025-04-05 00:00:00.000 | 15 | 5282 | 32.142 |
6 | 2025-04-04 00:00:00.000 | 28 | 5267 | 33.428 |
7 | 2025-04-03 00:00:00.000 | 33 | 5239 | 35.857 |
8 | 2025-04-02 00:00:00.000 | 63 | 5206 | 35.142 |
9 | 2025-04-01 00:00:00.000 | 36 | 5143 | 29.857 |
10 | 2025-03-31 00:00:00.000 | 24 | 5107 | 30.285 |
11 | 2025-03-30 00:00:00.000 | 26 | 5083 | 32.142 |
12 | 2025-03-29 00:00:00.000 | 24 | 5057 | 32.142 |
13 | 2025-03-28 00:00:00.000 | 45 | 5033 | 33.285 |
14 | 2025-03-27 00:00:00.000 | 28 | 4988 | 32.142 |
15 | 2025-03-26 00:00:00.000 | 26 | 4960 | 35.285 |
16 | 2025-03-25 00:00:00.000 | 39 | 4934 | 39.428 |
17 | 2025-03-24 00:00:00.000 | 37 | 4895 | 38.285 |
18 | 2025-03-23 00:00:00.000 | 26 | 4858 | 38 |
19 | 2025-03-22 00:00:00.000 | 32 | 4832 | 38 |
20 | 2025-03-21 00:00:00.000 | 37 | 4800 | 38.142 |
ArioGameID
Updated 2025-04-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
with game_id as (
select
DECODED_INSTRUCTION:args:gameId::string as Game_id,
min(block_timestamp) as first_date
from solana.core.ez_events_decoded
where program_id = 'FitAFk15vtx2PBjfr7QTnefaHRx6HwajRiZMt1DdSSKU'
and event_type in ('deposit', 'depositSol')
group by 1
),
main as (
select
date_trunc(day, first_date) as date,
count(DISTINCT Game_id) as "# Challenges",
sum("# Challenges") over(order by date) as "Cum. # Challenges"
from game_id
group by 1
order by date desc
)
select
*,
avg("# Challenges") over(order by date rows between 6 preceding and current row) as "7D MA"
from main
where date >= current_date - {{Past_Days}}
order by date desc
Last run: 13 days ago
91
4KB
2s