SELECT DISTINCT block_id, reftable.block_timestamp,
SUM(e8) OVER(PARTITION BY block_id) / 1e8 AS churn_reward,
SUM(e8) OVER(ORDER BY block_id ASC) / 1e8 AS cumulative_churn_reward
FROM (thorchain.defi.fact_bond_events AS reftable INNER JOIN thorchain.core.dim_block
ON reftable.dim_block_id = dim_block.dim_block_id)
WHERE bond_type = 'bond_reward'
ORDER BY block_id DESC