SELECT
action,
count(distinct tx_hash) as "Number of Total TXs",
count(distinct tx_signer) as "Number of Total Users",
--count(distinct POOL_ADDRESS) as "Total Number of Pools",
sum(stake_amount/pow(10, 24)) as "Total Volume"
FROM near.core.dim_staking_actions
WHERE action in ('Stake', 'Unstake')
group by 1
order by 2 DESC