Drsimonstake / unstake - w
    Updated 2023-01-28
    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