0xHaM-ddistribution in Selected
Updated 2024-04-16Copy Reference Fork
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
›
⌄
with tab1 as (
SELECT
ifnull(LABEL, VALIDATOR_ADDRESS) as stake_pool,
DELEGATOR_ADDRESS as staker_cnt,
avg(CASE
WHEN action in ('delegate', 'redelegate') THEN amount
ELSE amount*-1 END)/1e6 as NEAR_staked
FROM axelar.gov.fact_staking LEFT JOIN axelar.gov.fact_validators on VALIDATOR_ADDRESS = address
WHERE VALIDATOR_ADDRESS LIKE '{{Validator}}'
AND block_timestamp::date >= '{{Since_Date}}'
and block_timestamp::date <= CURRENT_DATE - 1
GROUP BY 1,2
ORDER BY 1 DESC
)
SELECT
CASE
WHEN NEAR_staked < 10 THEN 'a. < 10 NEAR'
WHEN NEAR_staked BETWEEN 10 and 50 THEN 'b. 10 ~ 50 NEAR'
WHEN NEAR_staked BETWEEN 50 and 100 THEN 'c. 50 ~ 100 NEAR'
WHEN NEAR_staked BETWEEN 100 and 500 THEN 'd. 100 ~ 500 NEAR'
WHEN NEAR_staked BETWEEN 500 and 1000 THEN 'e. 500 ~ 1000 NEAR'
WHEN NEAR_staked > 1000 THEN 'f. > 1000 NEAR'
END as distribution,
COUNT(DISTINCT staker_cnt) as staker_cnts
FROM tab1
GROUP by 1
QueryRunArchived: QueryRun has been archived