MLDZMNSSM4
    Updated 2022-11-14
    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