nitsNEAR Staking Distribution
Updated 2022-12-08Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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