mmdrezaactions stats
    Updated 2023-05-10
    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