nsa2000Node Performance (weekly)
Updated 2022-10-05
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 pooled_validators as (
select distinct node_address from (
select
split(memo,':')[1] as node_address,
split(memo,':')[2] as bond_provider_address,
asset_e8/1e8 as rune_amount,
*
from thorchain.bond_events
where memo like 'BOND:%:%'
)
),
classic_validators as (
select distinct node_address from (
select
split(memo,':')[1] as node_address,
from_address as bond_provider_address,
asset_e8/1e8 as rune_amount,
*
from thorchain.bond_events
where memo not like 'BOND:%:%' and memo like 'BOND:%'
order by node_address
)
),
txns as (
select
iff(p.node_address is null, 'classic', 'pooled') as type,
s.*
from thorchain.slash_points s
left join pooled_validators p
on p.node_address = s.node_address
)
select
date_trunc('{{date_range}}',block_timestamp) as date,
type,
reason,
Run a query to Download Data