datavortexVolume
Updated 2024-11-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
⌄
/*
WITH stake_volume AS (
SELECT
-- Calculate total stake volume as the difference between committed and staked amounts
SUM(CASE WHEN action = 'DelegatorTokensCommitted' THEN amount ELSE 0 END) -
SUM(CASE WHEN action = 'DelegatorTokensStaked' THEN amount ELSE 0 END) AS total_stake_volume
FROM
flow.gov.ez_staking_actions
WHERE
tx_succeeded = TRUE
AND action IN ('DelegatorTokensCommitted', 'DelegatorTokensStaked')
AND block_timestamp >= DATE_TRUNC('WEEK', CURRENT_DATE) - INTERVAL '3 DAY' -- Start from last Wednesday
AND block_timestamp < DATE_TRUNC('WEEK', CURRENT_DATE) + INTERVAL '4 DAY' -- End at next Wednesday
)
-- Select the total stake volume
*/
SELECT sum(amount) FROM flow.gov.ez_staking_actions
WHERE block_timestamp >= '2024-11-01'
AND action IN ('DelegatorTokensStaked', 'DelegatorTokensCommitted', 'TokensStaked')
QueryRunArchived: QueryRun has been archived