select DISTINCT signer_id as "Staker",
count(*) as "Stakes",
sum(amount) as "Staked Amount",
count(DISTINCT block_timestamp::date) as "Active Days"
from near.gov.fact_staking_actions
WHERE address = 'meteor.poolv1.near'
and action = 'staking'
and block_timestamp::date >= current_date-30
group by 1
order by 3 desc