superflyUntitled Query
    Updated 2023-01-11
    with
    base as (
    select
    date(block_timestamp) as date,
    case
    when action = 'stake' then stake_amount
    else (stake_amount * -1)
    end as change
    from
    near.core.dim_staking_actions
    )
    select
    date,
    sum(change)
    from
    base
    group by date
    order by date asc
    Run a query to Download Data