mmdrezaactions stats
Updated 2023-05-10Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
count (distinct tx_id) as tx_count,
count (distinct delegator) as users_count,
sum (amount) as Volume,
avg (amount) as average_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'
and tx_succeeded = 'TRUE'
group by action
order by 1 desc
Run a query to Download Data