from thorchain.slash_amounts

where asset = 'THOR.RUNE'

group by 1,2,3,4,5,6),

tvl as (select day, total_value_bonded

from thorchain.daily_tvl),

lasts as (select date_trunc('day', block_timestamp) as dt, sum(slashed) as slashed_rune,

SUM(slashed_rune) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_slashed

from slash

group by 1)

select a.day, a.total_value_bonded, b.cumulative_slashed, b.slashed_rune

from tvl a

left outer join lasts b on a.day = b.dt