MLDZMNSSM4
Updated 2022-11-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select
case
when action ilike '%deposit%' then 'Stake'
when action ilike '%withdraw%' then 'Unstake'
when action ilike '%claim%' then 'Claim'
else null end as action_type,
CASE
WHEN amount/pow(10,9) <= 0.5 THEN 'a. below 0.5 SOL'
WHEN amount/pow(10,9) > 0.5 and amount/pow(10,9) <=2 THEN 'b. 0.5-2 SOL'
WHEN amount/pow(10,9) > 2 and amount/pow(10,9) <=10 THEN 'c. 2-10 SOL'
WHEN amount/pow(10,9) > 10 THEN 'd. above 10 SOL'
END as buckets,
count(distinct TX_ID) as sale_no,
count(distinct address) as user_no
from solana.core.fact_stake_pool_actions
where SUCCEEDED='TRUE'
and BLOCK_TIMESTAMP>=CURRENT_DATE-7 --past week
group by 1,2 having action_type is not null
Run a query to Download Data