bergDaily Stake and Stakers on Near
    Updated 2022-11-16
    select block_timestamp::date date,
    count(distinct(tx_hash)) as staked_num,
    count(distinct(tx_signer)) as stakers_num,
    sum(stake_amount / pow(10, 24)) as staked_volume,
    (staked_num / stakers_num) as staked_num_per_staker,
    (staked_volume / stakers_num) as staked_volume_per_staker,
    avg(stake_amount / pow(10, 24)) as staked_amount_avg,
    median(stake_amount / pow(10, 24)) as staked_amount_median,
    sum(staked_num) over (order by date) AS staked_num_cum,
    sum(staked_volume) over (order by date) AS staked_volume_cum,
    sum(stakers_num) over (order by date) as stakers_num_cum
    from near.core.dim_staking_actions
    where 1 = 1
    and action = 'Stake'
    and date >= '2022-11-01'
    group by date
    order by date
    Run a query to Download Data