Drsimonstake / unstake - w
Updated 2023-01-28
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc('WEEK' ,block_timestamp ) as date ,
action,
count(*) as "Number of staking" ,
sum(stake_amount/1e24) as "Amount of staking" ,
min(stake_amount/1e24) as "Min Amount of staking" ,
avg(stake_amount/1e24) as "Average amount of staking",
max(stake_amount/1e24) as "Max Amount of staking",
( "Amount of staking" / "Number of staking" ) AS RAiTO
from near.core.dim_staking_actions
where date >= '2020-01-01'
group by 1 , 2
Run a query to Download Data