headitmanagerRUNE bonded + slashed amounts : Total Bond
    Updated 2022-06-14
    with total_bond as (select
    sum(asset_amount)
    from thorchain.bond_actions
    where bond_type = 'bond_paid')
    , bond_overtime as (select
    sum(asset_amount),block_timestamp::date
    from thorchain.bond_actions
    where bond_type = 'bond_paid'
    group by 2)
    ,total_slash as (select
    sum(ASSET_E8/1e8)
    from thorchain.slash_amounts
    where asset='THOR.RUNE')
    ,slash_overtime as (select
    sum(ASSET_E8/1e8),block_timestamp::date
    from thorchain.slash_amounts
    where asset='THOR.RUNE'
    group by 2)
    select * from total_bond
    Run a query to Download Data