nsa2000Daily pooled validator participants over time
Updated 2022-09-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH
tab1 as (
SELECT
trunc(block_timestamp,'day') as days,
substring(memo, CHARINDEX('UNBOND:', memo) + 7, CHARINDEX('UNBOND:', memo) + 42) as operator,
count(distinct tx_id) as participations,
--cum(bonds) over (partition by operator order by days) as cum_bonds,
sum(e8/pow(10,8)) as rune_to_unbond
--sum(bonded) over (partition by operator order by days) as cum_rune_to_unbond
FROM thorchain.bond_events
WHERE bond_type = 'bond_returned' and memo like '%UNBOND:%' and CHARINDEX('UNBOND:', memo) > 0
group by 1,2
ORDER BY 1
)
SELECT
days,
operator,
participations, sum(participations) over (partition by operator order by days) as cum_participations,
rune_to_unbond, sum(rune_to_unbond) over (partition by operator order by days) as cum_rune_to_unbond
from tab1
order by 1 asc
Run a query to Download Data