tx_signer as staker,

count(distinct(tx_hash)) as staked_num,

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

avg(stake_amount / pow(10, 24)) as staked_amount_avg,

median(stake_amount / pow(10, 24)) as staked_amount_median

from near.core.dim_staking_actions

where 1 = 1

and action like '%Unstake%'

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

group by staker

order by staked_volume desc

limit 10