par_rnM1
Updated 2024-12-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
DATE_TRUNC ('month',BLOCK_TIMESTAMP) AS date,
ACTION,
COUNT(DISTINCT tx_hash) AS transactions,
COUNT(DISTINCT SIGNER_ID) AS users,
SUM(
CASE
WHEN ACTION = 'staking' THEN AMOUNT
ELSE -1 * AMOUNT
END
) AS net_staked_amount
FROM
near.gov.fact_staking_actions
WHERE
ADDRESS = 'meteor.poolv1.near'
AND ACTION IN ('staking', 'unstaking')
AND date >= '2024-01-01'
GROUP BY 1,2
QueryRunArchived: QueryRun has been archived