DATE | $ Wagers | 7 Day MA | |
|---|---|---|---|
1 | 2025-02-03 00:00:00.000 | 2228 | 2228 |
2 | 2025-02-04 00:00:00.000 | 2637 | 2432.5 |
3 | 2025-02-05 00:00:00.000 | 1953 | 2272.666 |
4 | 2025-02-06 00:00:00.000 | 1675 | 2123.25 |
5 | 2025-02-07 00:00:00.000 | 1642 | 2027 |
6 | 2025-02-08 00:00:00.000 | 1630 | 1960.833 |
7 | 2025-02-09 00:00:00.000 | 2188 | 1993.285 |
8 | 2025-02-10 00:00:00.000 | 2783 | 2072.571 |
9 | 2025-02-11 00:00:00.000 | 1790 | 1951.571 |
10 | 2025-02-12 00:00:00.000 | 1854 | 1937.428 |
11 | 2025-02-13 00:00:00.000 | 2042 | 1989.857 |
12 | 2025-02-14 00:00:00.000 | 1762 | 2007 |
13 | 2025-02-15 00:00:00.000 | 2076 | 2070.714 |
14 | 2025-02-16 00:00:00.000 | 3131 | 2205.428 |
15 | 2025-02-17 00:00:00.000 | 2809 | 2209.142 |
16 | 2025-02-18 00:00:00.000 | 2047 | 2245.857 |
17 | 2025-02-19 00:00:00.000 | 1249 | 2159.428 |
18 | 2025-02-20 00:00:00.000 | 1716 | 2112.857 |
19 | 2025-02-21 00:00:00.000 | 1579 | 2086.714 |
20 | 2025-02-22 00:00:00.000 | 1869 | 2057.142 |
ArioDaily Number of Transactions
Updated 2025-05-04
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc(day, block_timestamp) as date,
count(DISTINCT tx_id) as "$ Wagers",
avg(count(DISTINCT tx_id)) over(order by date rows between 6 preceding and current row) as "7 Day MA"
from
solana.core.ez_events_decoded
where
program_id = 'FitAFk15vtx2PBjfr7QTnefaHRx6HwajRiZMt1DdSSKU'
and block_timestamp >= current_date - {{Past_Days}}
and event_type in ('deposit', 'depositSol')
and SUCCEEDED
group by 1
Last run: about 2 months ago
91
4KB
3s