tx_signer as staker,

sum(stake_amount) / pow(10, 24) as staked_volume,

count(distinct(tx_hash)) as staked_num

from near.core.dim_staking_actions

where 1 = 1

and action = 'Stake'

and block_timestamp::date > '2022-11-01'

group by tx_signer

when staked_volume < 100 then '< 100'

when staked_volume < 1000 then '< 1000'

when staked_volume < 10000 then '< 10,000'

when staked_volume < 100000 then '< 100,000'

else '> 100,000' end as volume,

count(distinct(staked_num)) as staked_num,

count(distinct(staker)) as stakers_num

from list

group by volume