maybeyonasthor_bond_slashing
    Updated 2022-06-11
    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