COUNT(DISTINCT tx_signer) as stakers,

COUNT(DISTINCT a.TX_HASH) as stakes,

SUM(b.tx:actions[0]:FunctionCall:deposit/pow(10,24)) as Staked_NEAR,

Staked_NEAR/stakers as near_per_staker

FROM near.core.fact_actions_events_function_call a

JOIN near.core.fact_transactions b ON a.tx_hash = b.tx_hash

WHERE method_name = 'deposit_and_stake'

and a.block_timestamp::date >= CURRENT_DATE - 90