select

date_trunc('day', block_timestamp) as date,

sum(e8)/pow(10,8) as rune_bond

from thorchain.defi.fact_bond_events

where bond_type IN (

'bond_reward',

'bond_paid'

)

group by 1

,

unbond as (

select

date_trunc('day', block_timestamp) as date,

sum(e8)/pow(10,8) as rune_unbond

from thorchain.defi.fact_bond_events

where bond_type IN (

'bond_returned',

'bond_cost'

)

group by 1

,

calender as (

with dates as (

select

to_date('2021-02-28') as date

union all

select

date + 1

from dates

where date < current_date)

select *

from dates