kiacryptoNumber of unique users
Updated 2022-11-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
select
'stake' as type,
count(distinct address) as unique_user
from solana.core.fact_stake_pool_actions
where
block_timestamp::date >= current_date - 7 and
action ilike '%deposit%' and
succeeded = 'TRUE'
union all
select
'Unstake' as type,
count(distinct address) as unique_user
from solana.core.fact_stake_pool_actions
where
block_timestamp::date >= current_date - 7 and
(action ilike '%unstake%' or action ilike '%withdraw%') and
succeeded = 'TRUE'
Run a query to Download Data