maybeyonasthor_bond_slashing
Updated 2022-06-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with
slash_daily as (
select
date(block_timestamp) as date,
count(block_id) as slashings,
count(distinct block_id) as blocks,
sum(asset_e8/pow(10,8)) as rune_slashed
from thorchain.slash_amounts
where asset = 'THOR.RUNE'
group by 1
)
select *,
sum(slashings) over(order by date rows between unbounded preceding and current row) as total_slashings,
sum(blocks) over(order by date rows between unbounded preceding and current row) as total_blocks,
sum(rune_slashed) over(order by date rows between unbounded preceding and current row) as total_rune_slashed
from slash_daily
-- limit 100
Run a query to Download Data