mehrancrypto-dxoepqQ69-3
Updated 2022-10-19
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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