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