with stakers_data as (
select
-- sum(stake_amount/1e24) as volume,
-- avg(stake_amount/1e24) as average_volume,
-- count(distinct tx_hash) as transactions_count,
to_date(block_timestamp) as date,
count(distinct tx_signer) as unique_users,
action from near.core.dim_staking_actions
where date >= '2022-01-01'
group by action, date
)
select * from stakers_data