BlockTrackerdaily stake
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
date_trunc('week', block_timestamp) as date,
ATTRIBUTE_VALUE as validator,
count(DISTINCT delegators.delegator) as user,
sum(total_amount.amount) as vol
FROM cosmos.core.fact_msg_attributes
CROSS JOIN (
SELECT
ATTRIBUTE_VALUE as delegator
FROM cosmos.core.fact_msg_attributes
WHERE msg_type = 'coin_spent' AND attribute_key = 'spender' AND attribute_index = '0' AND msg_index = '0'
) AS delegators
CROSS JOIN (
SELECT
SPLIT(ATTRIBUTE_VALUE,'uatom')[0]::NUMERIC/1e6 as amount
FROM cosmos.core.fact_msg_attributes
WHERE attribute_key = 'amount' AND msg_type = 'delegate'
) AS total_amount
WHERE date > dateadd('month', -1, current_date)
AND msg_type = 'delegate' AND attribute_key = 'validator'
GROUP BY 1 , 2
ORDER BY 1 DESC
*/
/*
SELECT *
FROM cosmos.core.fact_msg_attributes
WHERE tx_id = '2BE54C348631969CD985EB41B626A24A1B91F4623C32E5EEF80F71A496DEBF3C'
*/
/*
SELECT
validators, count(DISTINCT delegator), sum(amount)
FROM (
SELECT
Run a query to Download Data