kaibladeWeekly Stake Amount Volume
Updated 2022-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
WITH raw_data AS
(
SELECT tx_hash, block_timestamp, stake_amount/1e24 as stake_amount,action
FROM near.core.dim_staking_actions
WHERE action = 'Stake'
)
-- revised_stake AS
-- (SELECT tx_hash, block_timestamp,
-- (CASE
-- WHEN action = 'Stake' THEN stake_amount
-- ELSE stake_amount * -1
-- END) AS signed_amount
-- FROM raw_data)
-- SELECT
-- FROM near.core.fact_receipts
-- WHERE receiver_id ='bflame.poolv1.near'
-- AND array_size(logs) > 0
-- ORDER BY block_timestamp DESC)
SELECT DATE_TRUNC('week',block_timestamp) AS "Weeks", SUM(stake_amount) AS "Total Stake Amount"
FROM raw_data
GROUP BY "Weeks"
Run a query to Download Data