Updated 2022-10-19

    SELECT POOL_ADDRESS , SUM(case when ACTION = 'Stake' then STAKE_AMOUNT
    when action = 'Unstake' then -STAKE_AMOUNT end )*power(10,-24) as net_staked ,
    case
    when block_timestamp::date >=CURRENT_DATE -90 then 'Last 90 days'
    else 'Earlier' end as type
    from near.core.dim_staking_actions
    GROUP by 1 , 3
    HAVING(net_staked > 0)

    Run a query to Download Data