mlhretention in solana(repeat transaction in next 30 days)
Updated 2022-07-15
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
›
⌄
select
'Old User' as type ,
count(DISTINCT(SIGNERS)) as total
from ( select min(block_timestamp::date) as date ,
SIGNERS
from solana.core.fact_transactions
where block_timestamp::date >= '2022-06-05' and block_timestamp::date < '2022-06-15'
group by 2)
group by 1
UNION
select
'Retention User' as type,
count(DISTINCT(SIGNERS)) as total
from ( select min(block_timestamp::date) as date ,
SIGNERS
from solana.core.fact_transactions
where block_timestamp::date >= '2022-07-05' and block_timestamp::date <= '2022-07-15'
and SIGNERS in ( select SIGNERS from ( select min(block_timestamp::date) as date ,
SIGNERS
from solana.core.fact_transactions
where block_timestamp::date >= '2022-06-05' and block_timestamp::date < '2022-06-15'
group by 2)
)
group by 2)
group by 1
Run a query to Download Data