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