mahdishUntitled Query
Updated 2022-11-09
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT Sum(STAKE_AMOUNT / 1e24) AS staked_number,
Avg(STAKE_AMOUNT / 1e24) AS avg_staked_number,
Count(DISTINCT TX_HASH) as amount_tx,
Count(DISTINCT TX_SIGNER) as "unique",
ACTION as type,
DATE_TRUNC('week', BLOCK_TIMESTAMP) AS date
FROM NEAR.CORE.DIM_STAKING_ACTIONS
GROUP BY type,
DATE
Run a query to Download Data