Elprognerd7 - overall staking
Updated 2023-02-06
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
action,
count(distinct tx_hash) as "Number of Total TXs",
count(distinct tx_signer) as "Number of Total Users",
--count(distinct POOL_ADDRESS) as "Total Number of Pools",
sum(stake_amount/pow(10, 24)) as "Total Volume"
FROM near.core.dim_staking_actions
WHERE action in ('Stake', 'Unstake') and block_timestamp >= CURRENT_DATE - INTERVAL '14 days'
group by 1
order by 2 DESC
Run a query to Download Data