WITH
bond_emission AS (
SELECT DATE(block_timestamp) AS date, bond_e8 AS rune_e8
FROM thorchain.rewards_events
),
pool_emission AS (
SELECT DATE(block_timestamp) AS date, rune_e8
FROM thorchain.rewards_event_entries
)
SELECT date, POWER(10,-8) * SUM(rune_e8) AS emitted_rune
FROM (
(SELECT * FROM bond_emission)
UNION ALL
(SELECT * FROM pool_emission)
)
GROUP BY date
QUALIFY date <> MAX(date) OVER()
ORDER BY date DESC