DATE | NOSF | NOSF_1W_AVG | NOSF_1M_AVG | |
|---|---|---|---|---|
1 | 2025-04-04 00:00:00.000 | 2184 | 2147 | 2022 |
2 | 2025-04-03 00:00:00.000 | 2175 | 2128 | 2009 |
3 | 2025-04-02 00:00:00.000 | 2132 | 2110 | 1996 |
4 | 2025-04-01 00:00:00.000 | 2146 | 2106 | 1985 |
5 | 2025-03-31 00:00:00.000 | 2124 | 2096 | 1966 |
6 | 2025-03-30 00:00:00.000 | 2153 | 2080 | 1947 |
7 | 2025-03-29 00:00:00.000 | 2117 | 2061 | 1925 |
8 | 2025-03-28 00:00:00.000 | 2047 | 2038 | 1905 |
9 | 2025-03-27 00:00:00.000 | 2048 | 2032 | 1894 |
10 | 2025-03-26 00:00:00.000 | 2109 | 2026 | 1884 |
11 | 2025-03-25 00:00:00.000 | 2076 | 2011 | 1869 |
12 | 2025-03-24 00:00:00.000 | 2009 | 2003 | 1855 |
13 | 2025-03-23 00:00:00.000 | 2024 | 2003 | 1844 |
14 | 2025-03-22 00:00:00.000 | 1956 | 2000 | 1833 |
15 | 2025-03-21 00:00:00.000 | 2005 | 2006 | 1815 |
16 | 2025-03-20 00:00:00.000 | 2002 | 2006 | 1795 |
17 | 2025-03-19 00:00:00.000 | 2006 | 2002 | 1775 |
18 | 2025-03-18 00:00:00.000 | 2021 | 1998 | 1755 |
19 | 2025-03-17 00:00:00.000 | 2005 | 1991 | 1733 |
20 | 2025-03-16 00:00:00.000 | 2007 | 1985 | 1711 |
AephiaSAGE scanning fleets activity
Updated 10 hours ago
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH scanning AS (
select
date_trunc('day', block_timestamp::date) as date
,count(distinct instruction:accounts[3]) as scanning_fleets
---------------------------------------------------------------
from solana.core.fact_events
WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE'
AND succeeded = 'true'
AND instruction:accounts[18] = 'DataJpxFgHhzwu4zYJeHCnAv21YqWtanEBphNxXBHdEY'
AND block_timestamp > '2024-04-01' AND block_timestamp < current_date
group by 1
),
final AS (
select
x.date as date
,scanning_fleets as nosf
,round(avg(scanning_fleets) OVER (order by date asc rows between 6 preceding and current row)) as nosf_1w_avg
,round(avg(scanning_fleets) OVER (order by date asc rows between 29 preceding and current row)) as nosf_1m_avg
from scanning x
)
--SELECT * FROM scanning
--/*
SELECT
date
,zeroifnull(nosf) as NOSF
Last run: about 10 hours ago
...
366
15KB
19s