kasadeghUntitled Query
    Updated 2022-11-12
    select block_timestamp::date as date,
    case when action ilike '%deposit%' then 'Stake/Deposit'
    when action ilike '%withdraw%' then 'Unstake/Withdraw'
    when action ilike 'order_unstake' then 'Unstake/Withdraw'
    when action ilike 'claim' then 'Claim Rewards'
    else null
    end as action_type,
    count (distinct tx_id) as TX_Count,
    count (distinct address) as Users_Count,
    sum (amount/1e9) as Total_Volume,
    avg (amount/1e9) as Average_Volume,
    sum (TX_Count) over (partition by action_type order by date ) as Cumulative_TX_Count,
    sum (Total_Volume) over (partition by action_type order by date ) as Cumulative_Volume
    from solana.core.fact_stake_pool_actions
    where succeeded = 'TRUE'
    and block_timestamp >= CURRENT_DATE - 7
    and action_type is not null
    and stake_pool_name='marinade'
    group by 1,2
    order by 1

    Run a query to Download Data