nitsNEAR Staking Distribution
    Updated 2022-12-08
    SELECT
    trunc(block_timestamp,'month') as months,
    method_name,
    case when method_name in ('deposit_and_stake','stake','stake_all') then 'staking'
    when method_name in ('unstake','unstake_all') then 'unstaking'
    else method_name end as method_name2,
    count(distinct TX_HASH) as actions
    from near.core.fact_actions_events_function_call
    WHERE method_name in ('deposit_and_stake','stake','stake_all','unstake','unstake_all','unbond_delegation','update_validator')
    group by 1,2,3
    order by 1 asc
    Run a query to Download Data