ramishoow2023-02-21 09:50 PM
Updated 2023-02-21
9
1
2
3
4
5
6
7
›
⌄
SELECT action, count(distinct tx_hash) as Number_of_Total_TXs, count(distinct tx_signer) as Number_of_Total_Users,
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' --ramishow
group by 1 order by 2 DESC --group by 1 order by 2 DESC
Run a query to Download Data