Aephia AMR - active users p.m. MR
Updated 2024-12-19
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 score AS (
SELECT
date_trunc('month', block_timestamp::date) as date,
count(distinct signers) as FF_FC_active_users
FROM solana.core.fact_events
WHERE (program_Id = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW' OR program_Id = 'STAKEr4Bh8sbBMoAVmTDBRqouPzgdocVrvtjmhJhd65')
AND succeeded = 'true'
AND block_timestamp > '2022-07-01' --AND block_timestamp < '2023-12-01'
Group BY 1
ORDER BY 1 DESC
),
sage AS (
SELECT
date_trunc('month', block_timestamp::date) as date,
count(distinct signers[0]) as sage_active_users
FROM solana.core.fact_events
WHERE program_Id IN ('TESTWCwvEv2idx6eZVQrFFdvEJqGHfVA1soApk2NFKQ', 'SAGEqqFewepDHH6hMDcmWy7yjHPpyKLDnRXKb3Ki8e6')
AND succeeded = 'true'
AND block_timestamp > '2023-04-01' --AND block_timestamp < '2023-12-01'
Group BY 1
ORDER BY 1 DESC
)
SELECT
x.date as date,
ff_fc_active_users,
sage_active_users
FROM score x
left outer join sage y on x.date = y.date
QueryRunArchived: QueryRun has been archived