hessRetention Users on Solana
Updated 2022-06-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with solana as ( select min(block_timestamp::date) as date , SIGNERS
from solana.core.fact_transactions
where block_timestamp::date >= '2022-05-20' and block_timestamp::date < '2022-05-31'
group by 2)
,
solana_retention as ( select min(block_timestamp::date) as date , SIGNERS
from solana.core.fact_transactions
where block_timestamp::date >= '2022-06-01' and block_timestamp::date <= '2022-06-10' and SIGNERS in ( select SIGNERS from solana)
group by 2)
select 'Solana Old User' as type , count(DISTINCT(SIGNERS)) as total
from solana
group by 1
UNION
select 'Solana Retention User' as type, count(DISTINCT(SIGNERS)) as total
from solana_retention
group by 1
Run a query to Download Data