select

date_trunc('day', block_timestamp) as days,

count(DISTINCT(tx_hash)) as staking_transactions,

count(DISTINCT(tx_signer)) as stakers,

count(DISTINCT(pool_address)) as validators,

sum(stake_amount/1e24) as volume

from near.core.dim_staking_actions

where action='Stake'

group by 1

),

unstakers as (

select

date_trunc('day', block_timestamp) as days,

count(DISTINCT(tx_hash)) as staking_transactions,

count(DISTINCT(tx_signer)) as unstakers,

count(DISTINCT(pool_address)) as validators,

sum(stake_amount/1e24) as volume

from near.core.dim_staking_actions

where action='Unstake'

group by 1

select s.days as days, s.staking_transactions as stake_transactions, s.stakers as stakers, s.validators as vstakers, s.volume as volume_stake,

uns.staking_transactions as unstake_transactions, uns.unstakers as unstakers, uns.validators as vunstakers, uns.volume as volume_unstake

from stakers s join unstakers uns using(days)