kasadeghUntitled Query
Updated 2022-11-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
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