SAGE upgrading activity

AephiaSAGE upgrading activity

Updated 1 day ago

WITH atlas_claimed AS (

SELECT

player_profile

,faction

FROM $query('3a486211-ccfe-470d-9cf8-a55e4cf39f8d')

GROUP BY 1,2

)

,upgrading AS (

select

date_trunc('day', block_timestamp::date) as date

,count(distinct instruction:accounts[16]) as profiles

,count(distinct case when faction = 'MUD'

then instruction:accounts[16] end) as MUD_profiles

,count(distinct case when faction = 'ONI'

then instruction:accounts[16] end) as ONI_profiles

,count(distinct case when faction = 'USTUR'

then instruction:accounts[16] end) as USTUR_profiles

---------------------------------------------------------------

from atlas_claimed

,solana.core.fact_events

WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE'

AND succeeded = 'true'

AND player_profile = instruction:accounts[16]

AND instruction:accounts[21] = 'LPkmmDQG8iBDAfKkWN6QadeoiLSvD1p3fGgq8m8QdMu'

AND block_timestamp > '2024-04-01' AND block_timestamp < current_date

group by 1

)

Last run: 1 day ago

	DATE	DAU	MUD_DAU	ONI_DAU	USTUR_DAU	DAU_1W_AVG	DAU_1M_AVG
1	2025-04-20 00:00:00.000	81	31	26	24	74	89
2	2025-04-19 00:00:00.000	81	31	26	24	74	90
3	2025-04-18 00:00:00.000	69	23	23	23	74	91
4	2025-04-17 00:00:00.000	72	31	16	25	77	92
5	2025-04-16 00:00:00.000	71	35	8	28	80	93
6	2025-04-15 00:00:00.000	70	36	12	22	84	93
7	2025-04-14 00:00:00.000	75	32	21	22	88	93
8	2025-04-13 00:00:00.000	82	31	28	23	90	94
9	2025-04-12 00:00:00.000	77	30	27	20	91	94
10	2025-04-11 00:00:00.000	91	44	28	19	91	94
11	2025-04-10 00:00:00.000	96	45	29	22	90	94
12	2025-04-09 00:00:00.000	100	45	31	24	91	94
13	2025-04-08 00:00:00.000	97	49	27	21	90	94
14	2025-04-07 00:00:00.000	88	50	17	21	90	94
15	2025-04-06 00:00:00.000	85	55	12	18	92	94
16	2025-04-05 00:00:00.000	81	54	13	14	95	95
17	2025-04-04 00:00:00.000	85	52	14	19	96	96
18	2025-04-03 00:00:00.000	99	59	20	20	97	97
19	2025-04-02 00:00:00.000	94	56	23	15	96	98
20	2025-04-01 00:00:00.000	95	58	23	14	96	98

...

382

18KB

39s

flipside