date_trunc('week',block_timestamp) as date,

count (distinct tx_id) as tx_count,

count (distinct delegator) as users_count,

count (distinct node_id) as nodes_count,

sum (amount) as volume,

avg (amount) as average_volume,

sum (tx_count) over (partition by action order by date) as cumulative_tx_count,

sum (volume) over (partition by action order by date) as cumulative_volume,

case

when action in ('DelegatorTokensCommitted','TokensCommitted') then 'Stake'

when action in ('DelegatorUnstakedTokensWithdrawn','UnstakedTokensWithdrawn') then 'Unstake'

when action in ('DelegatorRewardTokensWithdrawn','RewardTokensWithdrawn') then 'Claim Reward'

end as action

from flow.core.ez_staking_actions

where Block_timestamp >= '2023-01-01'

group by date,action