date_trunc('month', block_timestamp) as date,

signer_id as user,

count(DISTINCT tx_hash) as tx_count,

count(DISTINCT address) as staking_pool_count,

sum(amount) as total_vol,

avg(amount) as avg_tx_vol,

from

near.gov.fact_staking_actions

where

action in ('staking', 'unstaking')

group by

date, user

select

date,

avg(tx_count) as avg_tx_count_per_user,

avg(staking_pool_count) as avg_pool_count_per_user,

avg(total_vol) as avg_tot_vol_per_user

from

users

group by

date

order by

date asc