select

date(block_timestamp) as day,

action,

TX_SIGNER,

stake_amount/1e24 as amount

from

near.core.dim_staking_actions

where block_timestamp>='2022-11-01'

select

day,

action,

count(distinct TX_SIGNER) as signers

from

actions

group by

action, day