ramishoow2023-02-21 09:50 PM
    Updated 2023-02-21
    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