pool_address,

count(distinct(tx_hash)) as staked_num,

count(distinct(tx_signer)) as stakers_num,

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

(staked_num / stakers_num) as staked_num_per_staker,

(staked_volume / stakers_num) as staked_volume_per_staker,

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

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

sum(staked_num) over (order by date) as staked_num_cum,

sum(staked_volume) over (order by date) as staked_volume_cum,

sum(stakers_num) over (order by date) as stakers_num_cum,

row_number() over (partition by date order by staked_volume desc) as rank

from near.core.dim_staking_actions

where 1 = 1

and action = 'Stake'

and date >= '2022-11-01'

group by date, pool_address

qualify rank <= 10

order by date, rank