par_rnMeteor 03
Updated 2024-12-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
ACTION,
COUNT(*) AS transactions,
COUNT(DISTINCT SIGNER_ID) AS users,
SUM(AMOUNT) AS amount
FROM
near.gov.fact_staking_actions
WHERE
ADDRESS = 'meteor.poolv1.near'
AND date >= current_date -30
AND ACTION in ('staking','unstaking')
GROUP BY 1,2
QueryRunArchived: QueryRun has been archived