Arkanstaked 1
Updated 2022-12-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH
table1 as(
SELECT
action,
stake_amount,
tx_hash,
tx_signer
FROM
near.core.dim_staking_actions
WHERE
block_timestamp >= '2022-01-01'
)
SELECT
action,
COUNT(DISTINCT tx_hash) tx_count,
COUNT(DISTINCT tx_signer) user_count,
SUM(stake_amount/1e24) AS amount
FROM
table1
GROUP BY 1
Run a query to Download Data