MufasaDaily Unique number of stakers and unstakers on NEAR
    Updated 2022-11-07
    with stakers_data as (
    select
    -- sum(stake_amount/1e24) as volume,
    -- avg(stake_amount/1e24) as average_volume,
    -- count(distinct tx_hash) as transactions_count,
    to_date(block_timestamp) as date,
    count(distinct tx_signer) as unique_users,
    action from near.core.dim_staking_actions
    where date >= '2022-01-01'
    group by action, date
    )
    select * from stakers_data

    Run a query to Download Data