hesamDaily New Cosmos Redeligators Query
Updated 2022-12-14
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
31
32
33
34
35
36
›
⌄
WITH Data as (
SELECT
DISTINCT tx_id
FROM
cosmos.core.fact_msgs
WHERE
MSG_TYPE IN ('redelegate')
)
SELECT
*,
sum("New Redeligators") over (
ORDER BY
First_TX
) as "Cumulative Redeligators"
FROM
(
SELECT
First_TX,
count(*) as "New Redeligators"
FROM
(
SELECT
attribute_value,
min(date_trunc('day', block_timestamp)) as First_TX
FROM
cosmos.core.fact_msg_attributes
WHERE
tx_id in (
SELECT
*
from
Data
)
AND attribute_key LIKE 'sender'
GROUP BY
1
Run a query to Download Data