datavortexsocialist-cyan
Updated 2024-11-30
999
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
31
32
33
34
35
36
›
⌄
⌄
⌄
⌄
/*
SELECT
COUNT(tx_id) AS total_transactions,
COUNT(DISTINCT delegator) AS unique_delegators,
COUNT(DISTINCT node_id) AS unique_nodes,
SUM(amount) AS "flow_amount_staked",
666244542.07 AS "tested"
FROM
flow.gov.ez_staking_actions
WHERE
block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '24 HOURS';
*/
/*
SELECT node_id, project_name, validator_type FROM flow.gov.dim_validator_labels
WHERE node_id = '2cfab7e9163475282f67186b06ce6eea7fa0687d25dd9c7a84532f2016bc2e5e'
*/
/*
SELECT
COUNT(tx_id) AS total_transactions,
-- node_id,
COUNT(DISTINCT delegator) AS unique_delegators,
SUM(amount)
FROM
flow.gov.ez_staking_actions
WHERE node_id = '2cfab7e9163475282f67186b06ce6eea7fa0687d25dd9c7a84532f2016bc2e5e'
AND block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '24 HOURS'
*/
--for total delegators the code below works
SELECT
a.node_id,
l.project_name,
COUNT(DISTINCT a.delegator_id) AS total_delegators,
SUM(a.amount) AS total_staked
QueryRunArchived: QueryRun has been archived